CODEWITHSUNDEEP
ssisdynamics-crm-365fetchxmlkingswaysoft
David
David

Reputation: 321

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

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.

enter image description here

Upvotes: 0

Views: 81

Answers (1)

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22846

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.

Upvotes: 0

Related Questions