UpdateContext({varJSON: JSON(ShowColumns(
AddColumns(
Filter(
GLBApplications,
(IsBlank(DatePickerCanvas1.SelectedDate) || 'DATE OF LODGEMENT (dd/mm/yyyy)' >= DatePickerCanvas1.SelectedDate) &&
(IsBlank(DatePickerCanvas2.SelectedDate) || 'DATE OF LODGEMENT (dd/mm/yyyy)' <= DatePickerCanvas2.SelectedDate) &&
(IsBlank(DropdownCanvas1.Selected.Value) || 'APPLICATION STATUS' = DropdownCanvas1.Selected.Value)
),PRESF,Text('PRESCRIBED FEE'),LICTYPE,Text('LICENSE TYPE'),REG,Text(REGION), COMPL, Text('COMPLETE/INCOMPLETE'),APPSTAT,Text('APPLICATION STATUS'),DEC,Text('DECISION (granted/decline)')),
'APPLICATION REFERENCE NUMBER NO','PAYMENT REFERENCE NO','NAME OF PREMISE','NAME OF APPLICANT','ADDRESS OF LICENSED PREMISES',
'DATE OF LODGEMENT (dd/mm/yyyy)','DATE OF PAYMENT (dd/mm/yyyy)',PRESF,'AMOUNT PAID','REASON FOR UNDER/OVER PAYMENT',LICTYPE,SUBURB,REG,'CONTACT DETAILS OF LICENSE HOLDER',EMAIL,COMPL,'DATE OF INSPECTION','DATE TO SECRETARIAT','DATE OF FIRST CONSIDERATION','ACTIVATION OR LICENCE ISSUE DATE',APPSTAT,DEC,'DECISION DATE','COMMENT (if any)','REPORTING DATE','Created By','Created On','Modified By','Modified On'
),JSONFormat.IndentFour)});
Thank you in advance.
