• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 4 subscribers
  • Views 2087 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Need to filter the data of a grid in a tempo report by two filters

marcoc200

Hello,
I need to filter the data of a grid in a tempo report by two filters:
.one filters the data by number
.one filters the data by the value of a dropdwon that i select in the same report
I've read all the guide realtive to filter the data of a grid but i don't find anything, I've tried usin an if condition in the filter and to use the logical expression.
My objective is to obtain the same report as the one shown in this image...

OriginalPostID-134902

OriginalPostID-134902

  Discussion posts and replies are publicly visible

Parents
  • 0
    You can do it by using an if condition in the logicalExpression, you will just need to return a {} as the false condition eg. if(isnull(ri!filter),{},a!queryFilter(......). Also you will need to look where your query is sitting within the structure e.g. is it in load or with. If you are wanting it to fresh when a new dropdown value is selected then you will need it to be in the with function.
Reply
  • 0
    You can do it by using an if condition in the logicalExpression, you will just need to return a {} as the false condition eg. if(isnull(ri!filter),{},a!queryFilter(......). Also you will need to look where your query is sitting within the structure e.g. is it in load or with. If you are wanting it to fresh when a new dropdown value is selected then you will need it to be in the with function.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.