Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
20 replies
Subscribers
11 subscribers
Views
10696 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Can we add two or more filters in facetOption
ramakg
A Score Level 1
over 7 years ago
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
0
mayurm896
over 7 years ago
We can add 2 or more filters in facet options. With reference to your code, if you wish to filter out records based on date range you can try below mentioned code.
/* code to get records where issueDate falls in last week */
a!queryFilter
(
field: "issueDate",
operator: "between",
value:
{
date(year( today()),month(today()),day( today())) - 7,
date(year( today()),month(today()),day( today()))
}
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mayurm896
over 7 years ago
We can add 2 or more filters in facet options. With reference to your code, if you wish to filter out records based on date range you can try below mentioned code.
/* code to get records where issueDate falls in last week */
a!queryFilter
(
field: "issueDate",
operator: "between",
value:
{
date(year( today()),month(today()),day( today())) - 7,
date(year( today()),month(today()),day( today()))
}
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data