User filter based on multiple fields

Question

Hi, 
 I'm trying to create a user filter in a record that filters a combination of 2 fields. I've tried to use a!queryLogicalExpression() inside a!recordFilterListOption() for the filter and didn't work. 
 Is there any other way to do this? My other option is to create an interface with this filter but i think it would be better to have it as a user filter in the record. 
 Thanks, 
 Ignacio

Prasanta Paul · Answer

With the help of userFilters you cannot meet the requirement. As of now it is not possible to configure an user filter by combination of two fields. You can configure a filter in the interface by using dropDown or textField component. Here is an example.

Now you can configure the filter with the help of dropDown component or text field. Here I have configured with dropdown.

Expression Rule:GT_firstName

a!queryRecordType(
 recordType: 'recordType!GT CustomerDetails',
 filters: a!queryLogicalExpression(
 operator: "OR",
 filters: {
 a!queryFilter(
 field: 'recordType!GT CustomerDetails.fields.firstName',
 operator: "=",
 value: ri!firstName,
 applyWhen: a!isNotNullOrEmpty(ri!firstName)
 ),
 a!queryFilter(
 field: 'recordType!GT CustomerDetails.fields.lastName',
 operator: "=",
 value: ri!lastName,
 applyWhen: a!isNotNullOrEmpty(ri!lastName)
 )
 }
 ),
 pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data

---------------------------------------------------------------------------------------
Interface Portion:

a!localVariables(
 local!save,
 local!name: rule!GT_firstName(
 firstName: ri!firstName,
 lastName: ri!lastName
 ),
 {
 a!dropdownField(
 choiceLabels: cons!GT_USER_NAME,
 choiceValues: cons!GT_USER_NAME,
 label: "Name",
 placeholder: "Search here by name",
 value: local!save,
 saveInto: {
 local!save,
 a!save(ri!firstName, local!save),
 a!save(ri!lastName, local!save)
 }
 ),
 a!gridField(
 label: "",
 labelPosition: "ABOVE",
 data: local!name,
 columns: {
 a!gridColumn(
 label: "First Name",
 sortField: local!name['recordType!GT CustomerDetails.fields.firstName'],
 value: fv!row['recordType!GT CustomerDetails.fields.firstName']
 ),
 a!gridColumn(
 label: "Last Name",
 sortField: local!name['recordType!GT CustomerDetails.fields.lastName'],
 value: fv!row['recordType!GT CustomerDetails.fields.lastName']
 )
 },
 pageSize: 16
 )
 }
)

ignacioa0620 · Answer

Hi, that issue was from 4 years ago, so I don&acute;t remember how (or if) it was solved at that time. 
 The good thing is that now you can configure Custom Record Fields with any calculation and filter based on that new field