Sitting in a meeting this evening, listening to the conversations whilst the brain was free-wheeling, the solution to an old problem that occasionally flopped on to my memory banks occurred.<\/p>\n
Problem:<\/strong><\/em> Solution?<\/strong><\/em> Der.<\/p>\n At least my brain didn’t wake me at 03.00 to tell me, it did it while I was still conscious. Yay for brain. Boo for brain for even thinking about this stuff though.<\/p>\n I mean, it’s hardly important. \ud83d\ude42<\/p>\n B<\/strong><\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":" Sitting in a meeting this evening, listening to the conversations whilst the brain was free-wheeling, the solution to an old problem that occasionally flopped on<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-504","post","type-post","status-publish","format-standard","hentry","category-stuff","two-columns"],"_links":{"self":[{"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=504"}],"version-history":[{"count":0,"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/504\/revisions"}],"wp:attachment":[{"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/brennigjones.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nselect app_refno as “Application Reference”
\n, initcap( app_corr_name ) as “Application Name”
\n, initcap( rli_description ) as “List”
\n, initcap( lst_description ) as “List Status”
\n, initcap( par_per_title ) as “Title”
\n, initcap( par_per_forename ) as “Forename”
\n, initcap( par_per_surname ) as “Surname”
\n, par_per_date_of_birth as “DOB”
\n, trunc( months_between( sysdate, par_per_date_of_birth ) \/ 12 ) as “Age”
\n, Q.lar_description as “Area_Choice”
\nfrom applications
\n, applic_list_entries
\n, rehousing_lists
\n, involved_parties
\n, parties
\n, list_statuses l
\n, (
\nselect distinct laa_app_refno
\n, a2.lar_code
\n, a2.lar_description
\nfrom lettings_area_answers
\n, lettings_areas a1
\n, lettings_areas a2
\nwhere laa_lar_code = a1.lar_code
\nand a1.lar_lar_code = a2.lar_code
\n) Q
\nwhere app_refno = ale_app_refno
\n–and app_refno in (38, 23)
\nand ale_rli_code = rli_code
\nand rli_current_ind = ‘N’
\nand rli_code in (‘HR’, ‘TR’)
\nand ipa_app_refno = app_refno
\nand ipa_par_refno = par_refno
\nand ale_lst_code = lst_code
\nand ale_lst_code in (‘LIVE’)
\nand ipa_main_applicant_ind = ‘Y’
\nand trunc( months_between( sysdate, par_per_date_of_birth ) \/ 12 ) >= 60
\nand app_refno = Q.laa_app_refno (+)
\norder by app_refno
\n, Q.lar_code<\/p>\n
\nRight there in Line 30 ‘N’ should be ‘Y’.<\/p>\n