CQL Examples
Introduction
123Find record by IDany wordsFind record containing these words"this phrase"Find record containing these words in orderword*Find record containing words starting withword:wordsmith,wordplay,wordlessfieldname:valueFind records wherefieldname = value#my-tagFind records tagged with#my-tag
Field Filtering
fieldname:valueSearch a field by a valuefieldname:"value with spaces"Search a field by a value containing spacesfieldname:[value1,value2]Show records with the field equal to any of these valuesfieldname:~valueSearch the field for words that sound likevalue(supported fields only)fieldname:>=valueFor numbers and dates, use>,<,>=and<=for range searches
AND, OR and NOT
red OR greenReturn records having eitherredorgreenred NOT appleReturn records havingredbut notapple(title:"red apple" AND body:"quick fox") OR title:foxUse parentheses to express complex logic
Special fields
@meFind records assigned to youassigned:bob@example.comFind records assigned to Bobassigned:"Police Liaison"Find records assigned to the position namedPolice Liaisonis:activeFind active recordsis:dueFind overdue records
Filters Reference
additionalinfo: Search the contents of additionalInfo (string)
additionalinfo:some additionalinfo:wordsThese words are in any order withinadditionalinfoadditionalinfo:friend*A wildcard search that matchesfriend,friendly,friendship, etc inadditionalinfoadditionalinfo:"a phrase"This phrase is inadditionalinfo
agriculture: Related to Agriculture (related)
agriculture:(id:123)Search the related record by related record ID123agriculture:(field1:value field2:value2)Search the related record using a nested set of filtershas:agricultureFilter records whereagricultureis set to any valuehasnt:agricultureFilter records whereagricultureis not set
applicant: Related to Persons (related)
applicant:(id:123)Search the related record by related record ID123applicant:(field1:value field2:value2)Search the related record using a nested set of filtershas:applicantFilter records whereapplicantis set to any valuehasnt:applicantFilter records whereapplicantis not set
asset: The related asset code or id (id)
asset:wordFilter records related to Asset containingwordin its titleasset:123Filter records related to Asset with the ID123has:assetFilter records whereassetis set to any valuehasnt:assetFilter records whereassetis not set
assetid: Search the contents of assetId (string)
assetid:some assetid:wordsThese words are in any order withinassetidassetid:friend*A wildcard search that matchesfriend,friendly,friendship, etc inassetidassetid:"a phrase"This phrase is inassetid
assigned: Assigned to participant (assignment)
assigned:valueFilter on a specific value ofassignedhas:assignedFilter records whereassignedis set to any valuehasnt:assignedFilter records whereassignedis not set
assignee: Assigned via Case Officer (assignment)
assignee:valueFilter on a specific value ofassigneehas:assigneeFilter records whereassigneeis set to any valuehasnt:assigneeFilter records whereassigneeis not set
atsiorigin: Search the contents of ATSIOrigin (enum)
atsiorigin:valueFilter records withatsioriginset tovalueatsiorigin:[value1,value2]Filter records withatsioriginset to any specified valuehas:atsioriginFilter records whereatsioriginis set to any valuehasnt:atsioriginFilter records whereatsioriginis not set
This field has a defined set of values:
yesYesnoNopreferNotToSayPrefer not to saynotYetAskedNot asked yet
attachment: Has attachment (media)
has:attachmentFilter records whereattachmentis set to any valuehasnt:attachmentFilter records whereattachmentis not set
casedocuments: An attachment (media)
has:casedocumentsFilter records wherecasedocumentsis set to any valuehasnt:casedocumentsFilter records wherecasedocumentsis not set
damageinfo: Search the contents of damageInfo (string)
damageinfo:some damageinfo:wordsThese words are in any order withindamageinfodamageinfo:friend*A wildcard search that matchesfriend,friendly,friendship, etc indamageinfodamageinfo:"a phrase"This phrase is indamageinfo
dateclosed: The first transition date and time to Closed (timestamp)
dateclosed:<now-30dIs less than 30 days from nowdateclosed:2026-12-31Is the date2026-12-31dateclosed:<2026-12-31Is earlier than the date2026-12-31dateclosed:>2026-01-01 AND dateclosed:<2026-12-31Is in the year2026dateclosed:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateclosedFilter records wheredateclosedis set to any valuehasnt:dateclosedFilter records wheredateclosedis not set
dateclosedduplicate: The first transition date and time to Closed (Duplicate) (timestamp)
dateclosedduplicate:<now-30dIs less than 30 days from nowdateclosedduplicate:2026-12-31Is the date2026-12-31dateclosedduplicate:<2026-12-31Is earlier than the date2026-12-31dateclosedduplicate:>2026-01-01 AND dateclosedduplicate:<2026-12-31Is in the year2026dateclosedduplicate:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateclosedduplicateFilter records wheredateclosedduplicateis set to any valuehasnt:dateclosedduplicateFilter records wheredateclosedduplicateis not set
dateclosederror: The first transition date and time to Closed (Error) (timestamp)
dateclosederror:<now-30dIs less than 30 days from nowdateclosederror:2026-12-31Is the date2026-12-31dateclosederror:<2026-12-31Is earlier than the date2026-12-31dateclosederror:>2026-01-01 AND dateclosederror:<2026-12-31Is in the year2026dateclosederror:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateclosederrorFilter records wheredateclosederroris set to any valuehasnt:dateclosederrorFilter records wheredateclosederroris not set
datecreated: The date and time the record was initially created (timestamp)
datecreated:<now-30dIs less than 30 days from nowdatecreated:2026-12-31Is the date2026-12-31datecreated:<2026-12-31Is earlier than the date2026-12-31datecreated:>2026-01-01 AND datecreated:<2026-12-31Is in the year2026datecreated:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datecreatedFilter records wheredatecreatedis set to any valuehasnt:datecreatedFilter records wheredatecreatedis not set
datedraft: The first transition date and time to Draft (timestamp)
datedraft:<now-30dIs less than 30 days from nowdatedraft:2026-12-31Is the date2026-12-31datedraft:<2026-12-31Is earlier than the date2026-12-31datedraft:>2026-01-01 AND datedraft:<2026-12-31Is in the year2026datedraft:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datedraftFilter records wheredatedraftis set to any valuehasnt:datedraftFilter records wheredatedraftis not set
dateinspectionrequired: The first transition date and time to Inspection Required (timestamp)
dateinspectionrequired:<now-30dIs less than 30 days from nowdateinspectionrequired:2026-12-31Is the date2026-12-31dateinspectionrequired:<2026-12-31Is earlier than the date2026-12-31dateinspectionrequired:>2026-01-01 AND dateinspectionrequired:<2026-12-31Is in the year2026dateinspectionrequired:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateinspectionrequiredFilter records wheredateinspectionrequiredis set to any valuehasnt:dateinspectionrequiredFilter records wheredateinspectionrequiredis not set
datenew: The first transition date and time to New (timestamp)
datenew:<now-30dIs less than 30 days from nowdatenew:2026-12-31Is the date2026-12-31datenew:<2026-12-31Is earlier than the date2026-12-31datenew:>2026-01-01 AND datenew:<2026-12-31Is in the year2026datenew:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datenewFilter records wheredatenewis set to any valuehasnt:datenewFilter records wheredatenewis not set
datenoactionrequired: The first transition date and time to No Action Required (timestamp)
datenoactionrequired:<now-30dIs less than 30 days from nowdatenoactionrequired:2026-12-31Is the date2026-12-31datenoactionrequired:<2026-12-31Is earlier than the date2026-12-31datenoactionrequired:>2026-01-01 AND datenoactionrequired:<2026-12-31Is in the year2026datenoactionrequired:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datenoactionrequiredFilter records wheredatenoactionrequiredis set to any valuehasnt:datenoactionrequiredFilter records wheredatenoactionrequiredis not set
dateopen: The first transition date and time to Open (timestamp)
dateopen:<now-30dIs less than 30 days from nowdateopen:2026-12-31Is the date2026-12-31dateopen:<2026-12-31Is earlier than the date2026-12-31dateopen:>2026-01-01 AND dateopen:<2026-12-31Is in the year2026dateopen:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateopenFilter records wheredateopenis set to any valuehasnt:dateopenFilter records wheredateopenis not set
datereopen: The first transition date and time to Reopen (timestamp)
datereopen:<now-30dIs less than 30 days from nowdatereopen:2026-12-31Is the date2026-12-31datereopen:<2026-12-31Is earlier than the date2026-12-31datereopen:>2026-01-01 AND datereopen:<2026-12-31Is in the year2026datereopen:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datereopenFilter records wheredatereopenis set to any valuehasnt:datereopenFilter records wheredatereopenis not set
dateresolved: The first transition date and time to Resolved (timestamp)
dateresolved:<now-30dIs less than 30 days from nowdateresolved:2026-12-31Is the date2026-12-31dateresolved:<2026-12-31Is earlier than the date2026-12-31dateresolved:>2026-01-01 AND dateresolved:<2026-12-31Is in the year2026dateresolved:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateresolvedFilter records wheredateresolvedis set to any valuehasnt:dateresolvedFilter records wheredateresolvedis not set
datereview: The first transition date and time to Review (timestamp)
datereview:<now-30dIs less than 30 days from nowdatereview:2026-12-31Is the date2026-12-31datereview:<2026-12-31Is earlier than the date2026-12-31datereview:>2026-01-01 AND datereview:<2026-12-31Is in the year2026datereview:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datereviewFilter records wheredatereviewis set to any valuehasnt:datereviewFilter records wheredatereviewis not set
datetemplate: The first transition date and time to Template (timestamp)
datetemplate:<now-30dIs less than 30 days from nowdatetemplate:2026-12-31Is the date2026-12-31datetemplate:<2026-12-31Is earlier than the date2026-12-31datetemplate:>2026-01-01 AND datetemplate:<2026-12-31Is in the year2026datetemplate:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:datetemplateFilter records wheredatetemplateis set to any valuehasnt:datetemplateFilter records wheredatetemplateis not set
dateupdated: The date and time the record was last updated (timestamp)
dateupdated:<now-30dIs less than 30 days from nowdateupdated:2026-12-31Is the date2026-12-31dateupdated:<2026-12-31Is earlier than the date2026-12-31dateupdated:>2026-01-01 AND dateupdated:<2026-12-31Is in the year2026dateupdated:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:dateupdatedFilter records wheredateupdatedis set to any valuehasnt:dateupdatedFilter records wheredateupdatedis not set
details: Search the contents of details (string)
details:some details:wordsThese words are in any order withindetailsdetails:friend*A wildcard search that matchesfriend,friendly,friendship, etc indetailsdetails:"a phrase"This phrase is indetails
eventid: Search the contents of eventId (string)
eventid:some eventid:wordsThese words are in any order withineventideventid:friend*A wildcard search that matchesfriend,friendly,friendship, etc ineventideventid:"a phrase"This phrase is ineventid
externalid: An imported record's original record ID (number)
externalid:valueFilter on a specific value ofexternalidhas:externalidFilter records whereexternalidis set to any valuehasnt:externalidFilter records whereexternalidis not set
externalsource: An imported record's source (string)
externalsource:some externalsource:wordsThese words are in any order withinexternalsourceexternalsource:friend*A wildcard search that matchesfriend,friendly,friendship, etc inexternalsourceexternalsource:"a phrase"This phrase is inexternalsource
fieldofficer: Assigned via Field Officer (assignment)
fieldofficer:valueFilter on a specific value offieldofficerhas:fieldofficerFilter records wherefieldofficeris set to any valuehasnt:fieldofficerFilter records wherefieldofficeris not set
fixedhomeaddress: Search the contents of fixedHomeAddress (enum)
fixedhomeaddress:valueFilter records withfixedhomeaddressset tovaluefixedhomeaddress:[value1,value2]Filter records withfixedhomeaddressset to any specified valuehas:fixedhomeaddressFilter records wherefixedhomeaddressis set to any valuehasnt:fixedhomeaddressFilter records wherefixedhomeaddressis not set
This field has a defined set of values:
noNo property within municipalityyesAdd a property within the municipality
geo: Filter records within a search area (geo)
within:my-search-areaFilter records fully within the definedmy-search-areageometrywithin:"WKT"Filter records within a geometry specified by Well Known Text (WKT)not within:my-search-areaFilter records fully outside of the nominated search areaintersects:my-search-areaFilter records that are fully or partly within the definedmy-search-areageometryhas:geoFilter records wheregeois set to any valuehasnt:geoFilter records wheregeois not set
id: The ID of the record (number)
id:123Returns just record by its ID123
importdata: Search the contents of importData (string)
importdata:some importdata:wordsThese words are in any order withinimportdataimportdata:friend*A wildcard search that matchesfriend,friendly,friendship, etc inimportdataimportdata:"a phrase"This phrase is inimportdata
insurance: Search the contents of insurance (string)
insurance:some insurance:wordsThese words are in any order withininsuranceinsurance:friend*A wildcard search that matchesfriend,friendly,friendship, etc ininsuranceinsurance:"a phrase"This phrase is ininsurance
intersects: Filter records within a search area (geo)
within:my-search-areaFilter records fully within the definedmy-search-areageometrywithin:"WKT"Filter records within a geometry specified by Well Known Text (WKT)not within:my-search-areaFilter records fully outside of the nominated search areaintersects:my-search-areaFilter records that are fully or partly within the definedmy-search-areageometryhas:intersectsFilter records whereintersectsis set to any valuehasnt:intersectsFilter records whereintersectsis not set
is: Convenient shortcuts (enum)
is:valueFilter records withisset tovalueis:[value1,value2]Filter records withisset to any specified valuehas:isFilter records whereisis set to any valuehasnt:isFilter records whereisis not set
This field has a defined set of values:
anyIs AnyactiveIs Active
isapplicantknown: Search the contents of isApplicantKnown (enum)
isapplicantknown:valueFilter records withisapplicantknownset tovalueisapplicantknown:[value1,value2]Filter records withisapplicantknownset to any specified valuehas:isapplicantknownFilter records whereisapplicantknownis set to any valuehasnt:isapplicantknownFilter records whereisapplicantknownis not set
This field has a defined set of values:
unknownThe affected person(s) are unknownknownThe affected person(s) or organisation are known
iselasticsearchindexingenabledforasset: A search area (boolean)
iselasticsearchindexingenabledforasset:trueiselasticsearchindexingenabledforassetis trueiselasticsearchindexingenabledforasset:falseiselasticsearchindexingenabledforassetis false
issearcharea: A search area (boolean)
issearcharea:trueissearchareais trueissearcharea:falseissearchareais false
istemplate: Search for only templates (boolean)
istemplate:trueistemplateis trueistemplate:falseistemplateis false
itemschemaname: The schema name (enum)
itemschemaname:valueFilter records withitemschemanameset tovalueitemschemaname:[value1,value2]Filter records withitemschemanameset to any specified valuehas:itemschemanameFilter records whereitemschemanameis set to any valuehasnt:itemschemanameFilter records whereitemschemanameis not set
This field has a defined set of values:
v202001Registration 2020
livestock: Related to Livestock (related)
livestock:(id:123)Search the related record by related record ID123livestock:(field1:value field2:value2)Search the related record using a nested set of filtershas:livestockFilter records wherelivestockis set to any valuehasnt:livestockFilter records wherelivestockis not set
name: Search the contents of name (string)
name:some name:wordsThese words are in any order withinnamename:friend*A wildcard search that matchesfriend,friendly,friendship, etc innamename:"a phrase"This phrase is inname
othertype: Search the contents of otherType (string)
othertype:some othertype:wordsThese words are in any order withinothertypeothertype:friend*A wildcard search that matchesfriend,friendly,friendship, etc inothertypeothertype:"a phrase"This phrase is inothertype
photos: An attachment (media)
has:photosFilter records wherephotosis set to any valuehasnt:photosFilter records wherephotosis not set
priority: Priority (enum)
priority:valueFilter records withpriorityset tovaluepriority:[value1,value2]Filter records withpriorityset to any specified valuehas:priorityFilter records wherepriorityis set to any valuehasnt:priorityFilter records wherepriorityis not set
This field has a defined set of values:
0None1Low2Normal3High4Urgent
privateassets: Related to Private Assets (related)
privateassets:(id:123)Search the related record by related record ID123privateassets:(field1:value field2:value2)Search the related record using a nested set of filtershas:privateassetsFilter records whereprivateassetsis set to any valuehasnt:privateassetsFilter records whereprivateassetsis not set
propertydamage: Search the contents of propertyDamage (enum)
propertydamage:valueFilter records withpropertydamageset tovaluepropertydamage:[value1,value2]Filter records withpropertydamageset to any specified valuehas:propertydamageFilter records wherepropertydamageis set to any valuehasnt:propertydamageFilter records wherepropertydamageis not set
This field has a defined set of values:
noNounsureDamage is possible and requires inspection/followupyesDamage has been confirmed
propertyinsured: Search the contents of propertyInsured (enum)
propertyinsured:valueFilter records withpropertyinsuredset tovaluepropertyinsured:[value1,value2]Filter records withpropertyinsuredset to any specified valuehas:propertyinsuredFilter records wherepropertyinsuredis set to any valuehasnt:propertyinsuredFilter records wherepropertyinsuredis not set
This field has a defined set of values:
noNoyesYesunknownUnknown
propertyuseaccommodation: Search the contents of propertyUseAccommodation (boolean)
propertyuseaccommodation:truepropertyuseaccommodationis truepropertyuseaccommodation:falsepropertyuseaccommodationis false
propertyusecommercial: Search the contents of propertyUseCommercial (boolean)
propertyusecommercial:truepropertyusecommercialis truepropertyusecommercial:falsepropertyusecommercialis false
propertyusecommunity: Search the contents of propertyUseCommunity (boolean)
propertyusecommunity:truepropertyusecommunityis truepropertyusecommunity:falsepropertyusecommunityis false
propertyusefarm: Search the contents of propertyUseFarm (boolean)
propertyusefarm:truepropertyusefarmis truepropertyusefarm:falsepropertyusefarmis false
propertyusegovernment: Search the contents of propertyUseGovernment (boolean)
propertyusegovernment:truepropertyusegovernmentis truepropertyusegovernment:falsepropertyusegovernmentis false
propertyuseinfrastructure: Search the contents of propertyUseInfrastructure (boolean)
propertyuseinfrastructure:truepropertyuseinfrastructureis truepropertyuseinfrastructure:falsepropertyuseinfrastructureis false
propertyuseother: Search the contents of propertyUseOther (boolean)
propertyuseother:truepropertyuseotheris truepropertyuseother:falsepropertyuseotheris false
propertyuseresidential: Search the contents of propertyUseResidential (boolean)
propertyuseresidential:truepropertyuseresidentialis truepropertyuseresidential:falsepropertyuseresidentialis false
propertyuseresidentialprimary: Search the contents of propertyUseResidentialPrimary (boolean)
propertyuseresidentialprimary:truepropertyuseresidentialprimaryis truepropertyuseresidentialprimary:falsepropertyuseresidentialprimaryis false
propertyuseresidentialsecondary: Search the contents of propertyUseResidentialSecondary (boolean)
propertyuseresidentialsecondary:truepropertyuseresidentialsecondaryis truepropertyuseresidentialsecondary:falsepropertyuseresidentialsecondaryis false
propertyuseresidentialunclassified: Search the contents of propertyUseResidentialUnclassified (boolean)
propertyuseresidentialunclassified:truepropertyuseresidentialunclassifiedis truepropertyuseresidentialunclassified:falsepropertyuseresidentialunclassifiedis false
propertyusevacant: Search the contents of propertyUseVacant (boolean)
propertyusevacant:truepropertyusevacantis truepropertyusevacant:falsepropertyusevacantis false
recoveryenvironmentalhealth: Related to Environmental Health (related)
recoveryenvironmentalhealth:(id:123)Search the related record by related record ID123recoveryenvironmentalhealth:(field1:value field2:value2)Search the related record using a nested set of filtershas:recoveryenvironmentalhealthFilter records whererecoveryenvironmentalhealthis set to any valuehasnt:recoveryenvironmentalhealthFilter records whererecoveryenvironmentalhealthis not set
referraldate: Date field (date)
referraldate:<now-30dIs less than 30 days from nowreferraldate:2026-12-31Is the date2026-12-31referraldate:<2026-12-31Is earlier than the date2026-12-31referraldate:>2026-01-01 AND referraldate:<2026-12-31Is in the year2026referraldate:<"2026-12-31 12:31:00"Is before2026-12-31 12:31:00(your local timezone)has:referraldateFilter records wherereferraldateis set to any valuehasnt:referraldateFilter records wherereferraldateis not set
referralsource: Filter by lookup value (enum)
referralsource:valueFilter records withreferralsourceset tovaluereferralsource:[value1,value2]Filter records withreferralsourceset to any specified valuehas:referralsourceFilter records wherereferralsourceis set to any valuehasnt:referralsourceFilter records wherereferralsourceis not set
This field has a defined set of values:
centrelinkCentrelinkdhhsDHHSFRVFRViccIncident Control CentreotherOtherred-rossRed Crossself-referredSelf-referredsccState Control CentrevccVictorian Council of Churches
region: The region code (enum)
region:valueFilter records withregionset tovalueregion:[value1,value2]Filter records withregionset to any specified valuehas:regionFilter records whereregionis set to any valuehasnt:regionFilter records whereregionis not set
This field has a defined set of values:
noneNo RegionALPINESHIREAlpineBAWBAWSHIREBaw BawWANGARATTAWangaratta
regionid: The region code (enum)
regionid:valueFilter records withregionidset tovalueregionid:[value1,value2]Filter records withregionidset to any specified valuehas:regionidFilter records whereregionidis set to any valuehasnt:regionidFilter records whereregionidis not set
This field has a defined set of values:
noneNo RegionALPINESHIREAlpineBAWBAWSHIREBaw BawWANGARATTAWangaratta
relatedassessmentswithsameasset: Related to Assessments (related)
relatedassessmentswithsameasset:(id:123)Search the related record by related record ID123relatedassessmentswithsameasset:(field1:value field2:value2)Search the related record using a nested set of filtershas:relatedassessmentswithsameassetFilter records whererelatedassessmentswithsameassetis set to any valuehasnt:relatedassessmentswithsameassetFilter records whererelatedassessmentswithsameassetis not set
relatedcontacts: Related to Persons (related)
relatedcontacts:(id:123)Search the related record by related record ID123relatedcontacts:(field1:value field2:value2)Search the related record using a nested set of filtershas:relatedcontactsFilter records whererelatedcontactsis set to any valuehasnt:relatedcontactsFilter records whererelatedcontactsis not set
relatedreliefregistrations: Related to Relief Registration (related)
relatedreliefregistrations:(id:123)Search the related record by related record ID123relatedreliefregistrations:(field1:value field2:value2)Search the related record using a nested set of filtershas:relatedreliefregistrationsFilter records whererelatedreliefregistrationsis set to any valuehasnt:relatedreliefregistrationsFilter records whererelatedreliefregistrationsis not set
relationshiptoproperty: Filter by lookup value (enum)
relationshiptoproperty:valueFilter records withrelationshiptopropertyset tovaluerelationshiptoproperty:[value1,value2]Filter records withrelationshiptopropertyset to any specified valuehas:relationshiptopropertyFilter records whererelationshiptopropertyis set to any valuehasnt:relationshiptopropertyFilter records whererelationshiptopropertyis not set
This field has a defined set of values:
guestGuestotherOtherownerOwnertenantTenantworkerWorker
schema: The schema name (enum)
schema:valueFilter records withschemaset tovalueschema:[value1,value2]Filter records withschemaset to any specified valuehas:schemaFilter records whereschemais set to any valuehasnt:schemaFilter records whereschemais not set
This field has a defined set of values:
v202001Registration 2020
sharinglevel: Search the contents of sharingLevel (enum)
sharinglevel:valueFilter records withsharinglevelset tovaluesharinglevel:[value1,value2]Filter records withsharinglevelset to any specified valuehas:sharinglevelFilter records wheresharinglevelis set to any valuehasnt:sharinglevelFilter records wheresharinglevelis not set
This field has a defined set of values:
notYetAskedPrimary contact(s) have not yet been askednoneDo not share my detailsfullShare my full details with other agencies for use in recovery
status: The status code or value (enum)
status:inspectReturn records withInspection Requiredstatusstatus:[inspect,new]Return records in any of the nominated statusesis:activeReturn records having active statuses (inspect,new,open_no_action,open,reopen,review)is:inactiveReturn records having inactive statuses
This field has a defined set of values:
closedClosedcw_closed_duplicateClosed (Duplicate)cw_closed_errorClosed (Error)cw_draft_from_templateDraftinspectInspection RequirednewNewopen_no_actionNo Action RequiredopenOpenreopenReopenresolvedResolvedreviewReviewcw_templateTemplate
systemclassification: Filter by lookup value (multiselect)
systemclassification:valueFilter on a specific value ofsystemclassificationhas:systemclassificationFilter records wheresystemclassificationis set to any valuehasnt:systemclassificationFilter records wheresystemclassificationis not set
tags: Tags that have been attached to the record (tags)
#fooReturn all records tagged withfoo#"Tag With Spaces"Search for records tagged with tags containing spaces#foo NOT #barReturn all records tagged withfoobut notbar
This field has a defined set of values:
accom-animalsTag valueactivityTag valueaddress_invalidTag valueadviceTag valueallergiesTag valueanamleasTag valueanimal-careTag valueanimal-managementTag valueanimalsTag valueanimal_atercTag valueanimal_managementTag valueany-old-tagTag valueauthorityTag valuebcpTag valuebuildingTag valuebushfireTag valuecatTag valuecateringTag valuechild_under_15Tag valuecoffeeTag valuecoffee_loverTag valuecorporateTag valuedamagedTag valuedamage_other_structuresTag valuedogTag valuedogsTag valueem-guidelinesTag valueemergencyTag valueemergencyateamTag valueemloTag valueengineeringTag valueercTag valueerc-assessment-builtTag valueerc-assessment-economicTag valueerc-assessment-naturalTag valueerc-assessment-socialTag valueerc-hobsonsTag valueerc-pattersonTag valueerc-primaryTag valueerc-secondaryTag valueerc-updateTag valuefallen-treeTag valuefallen_treeTag valuefamilyTag valuefield_mappingTag valuefireTag valuefirstlogTag valuefleetTag valuefloodTag valueflood-offTag valuefloodingTag valuefollow_upTag valuefoodTag valuefood_reliefTag valuefrom-assessment-2025-09-25Tag valuefrom-assessment-2026-01-23Tag valuefrom-assessment-2026-01-27Tag valuefrom-assessment-2026-01-29Tag valuefrom-assessment-2026-02-02Tag valuefrom-cogbTag valuefrv-mock-dataTag valuegas-leakTag valuegluten-freeTag valuehazardTag valuehealth-and-safetyTag valuehouse_destroyedTag valueiccTag valueiia-frvTag valueimport-2026-01-20Tag valueimportedTag valueimportsTag valueindigenous-infoTag valueinsert-new-onlyTag valueinspectionTag valuejj-resaveTag valuelakeTag valuelanguage_arabicTag valuelanguage_mandarinTag valuelearningTag valuelog-inTag valuemeetingTag valuememoTag valuemempcTag valueno_damageTag valueover_floor_foodingTag valuepetsTag valueplansTag valuepoliceTag valueproperty_affectedTag valuepumpsTag valuerecoveryTag valuered-crossTag valueremoveTag valueresetTag valueresidential_damage_uninhabitableTag valueroadTag valueroad-closureTag valueroad-closuresTag valueroadsTag valuesandbagsTag valuescdTag valueschoolTag valuesecurityTag valueshoppingTag valuesiaTag valuesouth-wang-zone-aTag valuetagTag valuetaggedTag valuetestTag valuetrainingTag valuetraining-spareTag valuetraining-userTag valuetraining-user-admin-coordTag valuetraining-user-beginnersTag valuetraining-user-communicationsTag valuetraining-user-fpn-coordTag valuetraining-user-fpn-officerTag valuetraining-user-impact-assessmentTag valuetraining-user-recovery-managerTag valuetraining-user-recovery-officerTag valuetraining-user-shareTag valuetraining-user-sharedTag valuetraining_notesTag valuetraining_numbersTag valuetravelTag valuetreeTag valueupdated-jan21-1250Tag valuevegetarianTag valuevegoTag valuevehiclesTag valuevicpolTag valuewasteTag valuewaterTag valueweatherTag valueyouth_teamTag valuezone-1Tag value
tasks: Related to Needs & Tasks (related)
tasks:(id:123)Search the related record by related record ID123tasks:(field1:value field2:value2)Search the related record using a nested set of filtershas:tasksFilter records wheretasksis set to any valuehasnt:tasksFilter records wheretasksis not set
templatename: Search for a template by its name (string)
templatename:some templatename:wordsThese words are in any order withintemplatenametemplatename:friend*A wildcard search that matchesfriend,friendly,friendship, etc intemplatenametemplatename:"a phrase"This phrase is intemplatename
userid: The userId of the user that initially created the record (user)
userid:valueFilter on a specific value ofuseridhas:useridFilter records whereuseridis set to any valuehasnt:useridFilter records whereuseridis not set
uuid: The UUID of the record (string)
uuid:123Returns just record by its UUID123
within: Filter records within a search area (geo)
within:my-search-areaFilter records fully within the definedmy-search-areageometrywithin:"WKT"Filter records within a geometry specified by Well Known Text (WKT)not within:my-search-areaFilter records fully outside of the nominated search areaintersects:my-search-areaFilter records that are fully or partly within the definedmy-search-areageometryhas:withinFilter records wherewithinis set to any valuehasnt:withinFilter records wherewithinis not set
Last updated
Was this helpful?
