{"id":43873,"date":"2022-10-17T03:01:42","date_gmt":"2022-10-16T17:01:42","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=43873"},"modified":"2022-10-21T18:11:04","modified_gmt":"2022-10-21T08:11:04","slug":"date-range-reporting-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/date-range-reporting-primer-tutorial\/","title":{"rendered":"Date Range Reporting Primer Tutorial"},"content":{"rendered":"
\"Date<\/a>

Date Range Reporting Primer Tutorial<\/p><\/div>\n

Are you always satisfied with Search and\/or Advanced Search functionality on websites? We’d say “sometimes”, but understand that some of the access to “Advanced Search” is debatable for webmasters given it can lead to database searches of some complexity, that might slow down their web server considerably. Just consider a database SQL query …<\/p>\n


\nSELECT * FROM placenamesintheworld WHERE placename = 'Adelaide';
\n<\/code><\/p>\n

… as distinct from (the one character different) …<\/p>\n


\nSELECT * FROM placenamesintheworld WHERE placename >= 'Adelaide';
\n<\/code><\/p>\n

That one extra “>” means little to the SQL interpreter but could mean a lot to web server performance. When we approach “Advanced Search” functionality on public websites, we are not surprised when restrictions are applied.<\/p>\n

If you are into data migration you may often know that jobs need to be broken up into manageable chunks of work. It is the same with “Advanced Search” quite often.<\/p>\n

And so to day’s date range<\/i> “Advanced Search” requirement we have for today’s tutorial. We found on the NSW Government Legislation<\/a> website’s “Advanced Search” “CCL query” functionality some inconsistencies when involving queries greater than (ie. using “>”) showed inconsistency (perhaps depending on your FirstValid Date start date, we are not sure), but no such inconsistency just involving (date) equality (ie. only involving “=” as any operator in the CCL query). So we decided to break the job up, writing an inhouse interface date range asker that behind the scenes only uses equality query parts to the several CCL queries it runs.<\/p>\n

This is a PHP job, because …<\/p>\n