A proprietary query language used in Dynamics CRM. It can be used in Javascript, SSRS, and web services.
For more information please refer to Docs.
Questions tagged [fetchxml]
400 questions
3
votes
1 answer
Not able to fetch "Name" of lookup fields of Link-Entity (Web API + FetchXml)
I have some fetchXml that I am executing through the Dynamics CRM Web API. THe fetchXml query is constructed like so:
…
jmsims2
- 43
- 1
- 5
3
votes
2 answers
FetchXML filter - compare attributes of two different entities?
I am trying to build a FetchXML query that does the same as the following SQL query. Basically, output the opportunity names and the linked appointments' subjects if custom attribute "dev_ownercommunityid" on the appointment equals to the…
Miracle Zhou
- 31
- 1
- 2
3
votes
1 answer
Question mark appears in currency fields returned from FetchXml
In Dynamics CRM 2015 I am using an ExecuteFetch request to query data. I need the resultset XML as response.
In the resultset the formatted value in every currency field shows a question mark between the currency symbol and the amount:
Henk van Boeijen
- 7,357
- 6
- 32
- 42
3
votes
2 answers
case statement inside of fetchxml script
Please note that although this question is an entirely different question, it relates directly to this question.
The following is the script that returns the dataset for my SSRS chart:
Alex Gordon
- 57,446
- 287
- 670
- 1,062
3
votes
2 answers
CRM 2013: Add record to related section
I have an issue with crm 2013. I use fetchXML for filtered (for example) Billing Account.
When our team work with CRM 2011 all working fine, but we migrate to CRM 2013 and have a problem with add related Project.
retrieveRecord(
…
Viktor Ischenko
- 199
- 1
- 8
3
votes
1 answer
FetchXml Query Returns Trimmed DocumentBody?
We have a FetchXml query with a couple of link entities, one of which is to the annotation entity in order to retrieve an attached image's base64 encoded content. This is so we can display an image inline on a page using data uris.
The problem is…
GotDibbs
- 3,068
- 1
- 23
- 29
3
votes
3 answers
Crm 2011 Fetch XMl - Invalid XML issue, how to fix?
I am using fetch xml to retieve values from ms crm 2011 entities.
it throws INVALID XML error, the sample xml is given below:
Yaqub Ahmad
- 27,569
- 23
- 102
- 149
3
votes
1 answer
fetch xml CRM report on SQL Reporting Server
Is this possible upload a fetch XML rdl report to use with SQL Reporting server
The report would display fine in BIDs but when i upload it to the SQL reporting server.
I get the following error
An error occurred during client rendering. An error…
nobe123
- 73
- 2
- 7
3
votes
1 answer
Aggregate Query limit exceeded?
I've got a 2 part question:
First question: I know that there is a query limit of 5,000 records when querying records, for performance reasons, but is there a limit when doing an aggregate query? If so, what is it? I need only to query the number of…
lhan
- 4,585
- 11
- 60
- 105
2
votes
1 answer
Convert fetchXML to sql temp table
We are about to convert or CRM report to CRM online report using fetchXML
The report is based on CRM database and my custom database
Is it possible convert fetchXML result into a temp table so i can join the temp table with other queries.
thanks…
nobe123
- 73
- 2
- 7
2
votes
1 answer
CRM2011 FetchXML Reports for CRM with Office 365 Authentication
Ladies and gentlemen,
Has anyone done that? I have a FetchXML report that works fine in a regular on-line CRM2011, but it doesn’t work in CRM2011 with Office 365 authentication..
I'm pretty sure it is because of authentication.. Same thing that…
Kirill
- 19
- 3
2
votes
1 answer
CRM Custom Contextual report
I apologize in advance for posting this type of question again, I know others have asked but when I try those solutions, it doesn't fix my problem.
This is what I'm trying to accomplish: I have custom report(several really) that I want to run…
gswanson
- 372
- 2
- 3
- 13
2
votes
1 answer
FetchXML OR Condition
I have a FetchXML query and I have it so if participationtypemask equals 5 than it puts the users with a participationtypemask of 5 in the Required Column. But I also want to add it so if a user has a participationtypemask of 6 then it puts those…
user482375
2
votes
1 answer
Date Parameters in FetchXML
I am using FetchXML in SSRS 2008 to create a report from CRM 2011. I want to have parameters in the report so you can show the records between From Date - To Date. This is the Query I have so far.
…
user482375