{"help": "https://uatweb.datansw.links.com.au/data/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "b4db408e-78b6-43d8-808a-1eb91e171eec", "total_estimation_threshold": null, "records": [{"select * from (":"    select"},{"select * from (":"        count(i.infringement_no) penalties_,"},{"select * from (":"        to_char(i.offence_dt,'YYYY') year_,"},{"select * from (":"        it.description inf_type,"},{"select * from (":"        i.offence_suburb,"},{"select * from (":"        o.offence_code,"},{"select * from (":"        o.description off_desc,"},{"select * from (":"        c.client_code||' - '||c.client_name client_details,"},{"select * from (":"        co.description client_org,"},{"select * from (":"        ops.description mode_of_transport,"},{"select * from (":"        CASE"},{"select * from (":"          -- BEGIN WITH 'MO' FOLLOWED BY 3/4 DIGITS"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, 1, 2 )  = 'MO'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 3 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) IN ( 5, 6 )"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          -- OR 4 DIGITS FOLLOWED BY 'ST'"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, -2 ) = 'ST'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 1, LENGTH ( I.REGISTRATION_NO ) - 2 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) = 6"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          -- 3/4 DIGITS FOLLOWED BY 'MO'"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, -2 ) = 'MO'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 1, LENGTH ( I.REGISTRATION_NO ) - 2 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) IN ( 5, 6 )"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          -- BEGIN WITH 'TV' FOLLOWED BY 3/4 DIGITS"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, 1, 2 )  = 'TV'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 3 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) IN ( 5, 6 )"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          WHEN I.REGISTRATION_NO IS NOT NULL"},{"select * from (":"          THEN 'Not a bus'"},{"select * from (":"          ELSE 'No registration'"},{"select * from (":"          END BUS_IND"},{"select * from (":"    from"},{"select * from (":"        imps.infringement i,"},{"select * from (":"        imps.infringement_type it,"},{"select * from (":"        imps.client c,"},{"select * from (":"        imps.offence o,"},{"select * from (":"        imps.operations ops,"},{"select * from (":"        imps.client_organisation co"},{"select * from (":"    where   "},{"select * from (":"        i.client_id=c.client_id"},{"select * from (":"        and i.operations_id=ops.operations_id (+)"},{"select * from (":"        and c.client_organisation_id=co.client_organisation_id"},{"select * from (":"        and i.offence_code=o.offence_code (+)"},{"select * from (":"        and i.infringement_type_id=it.infringement_type_id (+)"},{"select * from (":"        and i.offence_dt between '1-Jan-2012' and '31-Dec-2015'"},{"select * from (":"        --and c.client_organisation_id in (202,203)"},{"select * from (":"    group by"},{"select * from (":"        to_char(i.offence_dt,'YYYY'),"},{"select * from (":"        it.description,"},{"select * from (":"        i.offence_suburb,"},{"select * from (":"        o.offence_code,"},{"select * from (":"        o.description,"},{"select * from (":"        c.client_code||' - '||c.client_name,"},{"select * from (":"        co.description,"},{"select * from (":"        ops.description,"},{"select * from (":"        CASE"},{"select * from (":"          -- BEGIN WITH 'MO' FOLLOWED BY 3/4 DIGITS"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, 1, 2 )  = 'MO'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 3 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) IN ( 5, 6 )"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          -- OR 4 DIGITS FOLLOWED BY 'ST'"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, -2 ) = 'ST'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 1, LENGTH ( I.REGISTRATION_NO ) - 2 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) = 6"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          -- 3/4 DIGITS FOLLOWED BY 'MO'"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, -2 ) = 'MO'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 1, LENGTH ( I.REGISTRATION_NO ) - 2 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) IN ( 5, 6 )"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          -- BEGIN WITH 'TV' FOLLOWED BY 3/4 DIGITS"},{"select * from (":"          WHEN SUBSTR ( I.REGISTRATION_NO, 1, 2 )  = 'TV'"},{"select * from (":"                  AND LENGTH ( TRIM ( TRANSLATE ( SUBSTR ( I.REGISTRATION_NO, 3 ), '0123456789', ' ' ) ) ) IS NULL"},{"select * from (":"                  AND LENGTH ( TRIM ( I.REGISTRATION_NO ) ) IN ( 5, 6 )"},{"select * from (":"          THEN 'Y'"},{"select * from (":"          WHEN I.REGISTRATION_NO IS NOT NULL"},{"select * from (":"          THEN 'Not a bus'"},{"select * from (":"          ELSE 'No registration'"},{"select * from (":"          END"},{"select * from (":")"},{"select * from (":"where bus_ind='Y'"}], "fields": [{"id": "select * from (", "type": "text"}], "_links": {"start": "/api/action/datastore_search?resource_id=b4db408e-78b6-43d8-808a-1eb91e171eec", "next": "/api/action/datastore_search?resource_id=b4db408e-78b6-43d8-808a-1eb91e171eec&offset=100"}, "total": 86, "total_was_estimated": false}}