Can we add two or more filters in facetOption

Can we add two or more filters in facetOption? if not, is there any workaround solution?

a!facet(
name : "Status",
options : {
a!facetOption(
id : 1,
name : "Active",
          
filter : {
a!queryFilter(
field:"StartDate",
operator:"<=",
value: today()
),
a!queryFilter(
field:"EndDate",
operator:">=",
value: today()
)
}
)
},
defaultOption: "Active"
)

OriginalPostID-240150

  Discussion posts and replies are publicly visible

Parents
  • @ramakg Also just to let you know, the a!queryLogicalExpression() as suggested above isn't an option because afaik it isn't a function that can be used in the User Filters section. And the above-mentioned example which creates a rule and iterates it over a set of statuses defies the requirement as it ends up in creating multiple facet options as opposed to your thoughts of getting the job done with a single facet option.
Reply
  • @ramakg Also just to let you know, the a!queryLogicalExpression() as suggested above isn't an option because afaik it isn't a function that can be used in the User Filters section. And the above-mentioned example which creates a rule and iterates it over a set of statuses defies the requirement as it ends up in creating multiple facet options as opposed to your thoughts of getting the job done with a single facet option.
Children
No Data