Multiple filters in data format

#1

Hi guys, another day trying to learn Wappler!

It is possible to add another “where” in this data format?

I need to filter the query with another property.

image

#2

You can add multiple where filters like:

scQueryPerrors.data.queryArticle.where(....).where(....)
1 Like
#3

Thank you Teodor seems it’s working :slight_smile:

It is also possible to do it from the UI?

#4

Do you find the way to do it from the UI? @Teodor any help from this?

#5

Hey @Chackmool,

Following Teodor’s suggestion, I understand that the first where filter can be assigned directly from the UI…

image
image1501×929 54.8 KB

But trying from there to add an extra where filter, there is no available option VIA the UI.
I needed a little trick…

  1. You can just copy the where filter:

    image
    image968×282 7.7 KB

  2. Paste it at the end of the existing where filter:

    image
    image1304×152 4.76 KB

  3. Then by clicking the formater button:

    image
    image1855×950 77.4 KB

    Now, you can access and bind any value you want via the UI on any where filter you have.

2 Likes
#6

It is possible to do via the UI. Right-click on the first Where and select Where from the drop down.