Log in to AnswerLog in to Follow
UserImage.jpg
Learn It
183Views
10Comments
Solved
Enable or disable a Filter in aggregate
Question
Mobile
Application Type
Mobile

I have an aggregate with a filter set against a variable "FilterVar".

I have a dropdown that can select a value for the "FilterVar".

Now, if i do not select a value to this FilterVar, i want to list all that is present in the aggregate. If i select a value for FilterVar, then i want to display only the data matching this result.

How can i implement this?

1
0
28 Jan 2021
2018-10-29 08-31-03
João Marques
mvp_badge
MVP
Solution

Hi Learn It,


The strategy is to have your condition to be written with an OR and one of the clause to be the FilterVar = its default value so to ignore the other condition.


If your filter is of type Text, set your filter to: FilterVar = "" or <YourOriginalFilter>.

If your filter is of type Number, set your filter to: FilterVar = 0 or <YourOriginalFilter>.

If your filter is of type Identifier, set your filter to: FilterVar = NullIndentifier() or <YourOriginalFilter>.


Example for a filter of a client id, if FilterVar = NullIdentifier() or Client.Id = FilterVar.


Regards,
João

2
0
28 Jan 2021

Thanks for the solution. I could filter it now. But one question, Since i am using a drop down to select the value of FilterVar . Once i select one parameter, then it cant be empty right. So if i want to go back and query all, how can i reset that?

Hope my question is clear

0
0
28 Jan 2021
2018-10-29 08-31-03
João Marques
mvp_badge
MVP

Replying to Learn It's comment on 28 Jan 2021 19:52:39

Hi Learn It,


I am glad I could help. Please consider, if it solved your problem, to mark the above answer as solution so other developers can find help if they run into a similar issue.

To reset it you just need to set the value of FilterVar variable back to the default value: NullIdentifier() if its type is Identifier, 0 if its type is integer, etc.

1
0
28 Jan 2021
0
0
28 Jan 2021
2020-05-07 18-53-00
Rui Barradas
mvp_badge
MVP

Hello Learn It,

Hope you're doing well.


What is the data type of your variable "FilterVar"?

Basically, your filter in the Aggregate should be something like:

FilterVar = NullIdentifier() or FilterVar = Aggregate.List.Current.Entity.Id


I am considering your FilterVar as an Identifier.


Kind regards,

Rui Barradas

0
0
28 Jan 2021
2021-03-18 21-03-15
Benjith Sam
mvp_badge
MVP

Hi Learn It,

Such condition could be solved using the OR connector i.e.

Assuming the data type of FilterVar to be Text type


Filter Condtion:

trim(FilterVar) = "" or Entity.AttributeValue = FilterVar


Hope this helps you!


Kind regards,

Benjith Sam

0
0
28 Jan 2021

Hii!

someting like :

Entity.var = FilterVar or FilterVar=""



0
0
28 Jan 2021

Hello,

I am not sure if this would be possible into a single aggregate. So, I would suggest you to add 2 aggregates (with FilterVar and WithOut)FilterVar and apply an If condition to check, if FilterVar have some value execute the aggregate which is with "FilterVar" and if FilterVar is blank execute the aggregate which is without "FilterVar" filter. 

Thanks & Kind Regards,

Sachin

0
2
28 Jan 2021

Hi Learn it,


Create a filter like this

Entity.variable = FilterVar or FileterVar = DefaultValue
0
0
28 Jan 2021

hi Learn it

you can use conditional inside filter like that


1
0
28 Jan 2021
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.