In aggregate filters, how to use logical OR?
Application Type
Reactive

Hello,

I am new to OutSystems and perusing guided path 'Becoming a Reactive Web Developer'. Today I just learned about aggregates. By default, the aggregates filter uses AND condition.

 In aggregate filters, how to use logical OR so that result is fetched when one of the condition is true?

Or how to make a combination of complex conditions in SQL where clause?

Thank you.

Solution

Hello Bhushan ,

If you're using aggregate

you can open the aggregate(double click on the aggregate) and go to filters tab

Click on add filter, you can give as many filters based on your requirement

you can use any logical operators as shown in above image


-- Hope this helps you!!


Thanks,

Sandeep.

Champion
Solution

Hi


For complex query, you can use advance SQL.

For aggregate, you can use on inside the filter like this screenshot

Thanks

Solution

Hi Bhusan,

You can use or operator to perform logical operation in Aggrege or logic.

Also you can use any SQL complex query in Outsystems SQL, by changing the litlle syntax, like table name  in {}, filter variable using @ 


More details

Logical Operators Outsystems

Advanced Query


Dileep

Champion
Solution

Hi


For complex query, you can use advance SQL.

For aggregate, you can use on inside the filter like this screenshot

Thanks

Solution

Hi Bhusan,

You can use or operator to perform logical operation in Aggrege or logic.

Also you can use any SQL complex query in Outsystems SQL, by changing the litlle syntax, like table name  in {}, filter variable using @ 


More details

Logical Operators Outsystems

Advanced Query


Dileep

Solution

Hello Bhushan ,

If you're using aggregate

you can open the aggregate(double click on the aggregate) and go to filters tab

Click on add filter, you can give as many filters based on your requirement

you can use any logical operators as shown in above image


-- Hope this helps you!!


Thanks,

Sandeep.

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