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
My recommendation here is to make sure that the values in the database are never null, but empty strings or something else.