Unable to add a condition using a column from a secondary table on Kingswaysoft

Question

I'm trying to retrieve data using KingswaySoft, and I need to use columns from both the primary and secondary tables in my conditions. However, KingswaySoft does not support this functionality. I also attempted to use a nested query, but it did not work.

Answer 1

You have to tweak the query little bit. This blog will give you idea for that.

Basically, build the advanced find query, then download the fetchxml and tweak/test the downloaded fetchxml query in XrmToolBox - FetchXml builder.

This way you will get a working query to use in Kingswaysoft.