Skip to main content
January 18, 2023
Question

Source & Default Filters: cannot filter more than 4 criteria

  • January 18, 2023
  • 2 replies
  • 0 views

Hi,

I'm using expression in "Source & Default Filters" in RecordType.

I can only save expression with 4 criteria but I cannot save it with more than 4.

do you have any suggestion. my code is below:

a!queryLogicalExpression(
operator: "OR",
filters: {
a!queryFilter(field: "year1", operator: "<", value:2021),

a!queryFilter(field: "year2", operator: "<", value:2021),

a!queryFilter(field: "year3", operator: "<", value:2021),

a!queryFilter(field: "year4", operator: "<", value:2021),

a!queryFilter(field: "year5", operator: "<", value:2021),

a!queryFilter(field: "year6", operator: "<", value:2021),

a!queryFilter(field: "year7", operator: "<", value:2021),

}
)

2 replies

davel001150
January 18, 2023

That seems very odd that you can't save it.  Perhaps you could put the expression in a separate expression object and call that from within the Record Type definition?

stewart.burchell
January 18, 2023

I'm not seeing this (I've just tried it) although I do know that you should be referring to your record fields using recordType! rather than as text as you have it.