Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Retrieve all attributes defined in a FetchXML query

Hoxito
Contributor II
Contributor II

Retrieve all attributes defined in a FetchXML query

When querying data with the Microsoft Dynamics CRM V2 connector using FetchXML, Qlik internally retrieves the first page of data. It then checks if those attributes contain data, and only those attributes containing at least one value are being made available for subsequent use within the Qlik script.

Now, in certain cases - depending on the order of the retrieved records and on how the data is populated across the records and among the attributes - not all attributes contain values in the first page. The problem: In these cases, these attributes are discarded and not made available within the Qlik script.

Thus, I would suggest to implement a feature enabling it to bypass the above-mentioned check and get every single attribute defined in the FetchXML query - regardless whether in contains data in the first page of records or not.

Tags (1)
3 Comments
AlexOmetis
Partner Ambassador
Partner Ambassador
Hoxito
Contributor II
Contributor II

Hi @AlexOmetis 

Looks like it - thank you very much for pointing it out!

Best regards

Renato

Meghann_MacDonald

Thanks all! I will close this as a duplicate and point to @johnt 's idea here:https://community.qlik.com/t5/Suggest-an-Idea/Web-Connectors-Microsoft-Dynamics-CRM-V2/idi-p/1801641 

Please add your likes and comments there to show support for this request.

Meghann

Status changed to: Closed - Duplicate