Hi @all,
We are facing one challenge in using Record type:
We have 3 fields in our DB that may contains value or remains empty. So we want to apply user filter on the grid for showing only those values which contains some data based on the section by the user from the list of 3 values i.e., the name of these fields.
We are attaching the code that we are implementing for this but it is not ignoring empty strings. We want the black cross fields containing null to go away on applying the filter. Only values which contain data should be displayed.
Kindly, help us in resolving the issue.
a!recordFilterList( name: "Target Type", options: { a!recordFilterListOption( id: 1, name: "Voice", filter: a!queryFilter( field:'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{voiceRecords}voiceRecords', operator: "not null", ) ), a!recordFilterListOption( id: 2, name: "MMS Records", filter: a!queryFilter( field:'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{mmsRecords}mmsRecords', operator: "not null", ) ), a!recordFilterListOption( id: 3, name: "SMS Records", filter: a!queryFilter( field:'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{smsRecords}smsRecords', operator: "not null", ) ), } )
Discussion posts and replies are publicly visible
You could try creating a custom record field (or adding a column to the DB view if that's your data source) that returns a boolean true/false, and then filter by that column. Another trick that sometimes works is using a queryFilter with operator: "<>" and value: " " (a single space).
Hii daniell,
Thank u so much its works fine.