Multiple relationship filtering on a single call

Hi everyone,

i am new to DF, trying to get around some standard sql queries like:

select id from table1 where id IN (select anotherid from table2 where somerules) and id NOT IN (select someotherid from table3 where someotherurles)

is there anyway to have this converted to df url filters ? If not what do you think is the best way to achieve the same result through DF rest api ?

I did try some virtual relationship and virtual fields but no luck so far.

Any help is appreciated.
Thank you

The best way to achieve this is by using the Data Mesh feature as you already mentioned. You can refer to this guide - https://blog.dreamfactory.com/easier-data-marts-with-dreamfactory-data-mesh/

Also, you could also add certain conditions in the API call itself. Look at the documentation here - https://guide.dreamfactory.com/docs/chapter03.html#generating-a-mysql-backed-api.

Doing the above will result in only call one API endpoint to achieve the desired results. Let me know if it helps