using xtk.queryDef to get fields from a subquery?

[RaulOcana]

Hi team,

It is possible to get the fields from a sub-query?

I have created a query so it joins two schemas, but I need to bring ALL fields from main and sub schemas, is that possible?

Regards,

Raúl

[Jonathon_wodnicki · Accepted solution]

Hi,

It's not possible to select fields out of where clause subqueries, no.

You can join the subquery's tables instead though.

Thanks,

-Jon