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
2
votes
1 answer
Dynamics CRM 2011 - fetch xml sum returns NULL instead of 0
I have a fetchXMl which does a simple 'sum' query.
…
Demian Kasier
- 2,475
- 6
- 30
- 40
2
votes
1 answer
FetchXml System.OutOfMemory Exception
As I've learnt from my google searches, MSCRM 2011 retrieves maximum 5000 entities but I want all my entities from a marketing list. As written on the web creating "TurnOffFetchThrottling" field on HKLM\Software\Microsoft\MSCRM and set a value as 1…
zato
- 133
- 1
- 10
2
votes
1 answer
Get option set and lookup field values from FetchXml in CRM 2011
I'm attempting to use fetchxml to obtain values from another record to create a new one. I have managed to get it all working apart from getting any values from option set or lookup fields. The option set ones dont give any error but just dont set…
jimminybob
- 1,392
- 2
- 24
- 60
2
votes
1 answer
CRM 2011 Chart - How to Show All Values in Legend?
Using the default CRM 2011 Opportunities by Sales Stage Funnel Chart, how can you get it to show all of the stages in the legend even if there isn't data for each stage? This seems like a simple problem but I'm stumped.
The Chart only presents data…
user1488803
- 173
- 1
- 10
2
votes
1 answer
Server-side Fetchxml returns different results
One of our procedures lets users bulk-insert related records by picking a view and then hitting a ribbon button. The form is saved, a flag is set, and a plugin then does its job.
We are using a subgrid with a view selector to let users pick or…
raine
- 817
- 1
- 15
- 26
2
votes
3 answers
Writing Native SQL for CRM 2011
I wonder about that can I write native SQL to add or delete operations instead of using Query Expression or FetchXML etc. I know Query Expression is very useful but my real concern is performance and I've thought writing SQL can be faster than the…
zato
- 133
- 1
- 10
2
votes
2 answers
Tool to convert a SQL query into Dynamics CRM FetchXML query
We need a tool that can convert a given well-defined SQL query into it's constituent xml form. Can anyone suggest anything of this sort, a free tool would do great help. Also, can you advise whether FetchXML by MS can be used to achieve this?
We can…
leonidas
- 21
- 1
- 3
2
votes
1 answer
Define date parameters
I'm very new to creating custom reports. I need to prompt a begin date and an end date to the user in the crm, so that the result would be datas only created between those two dates.
I have three parameters to prefilter my datas (account, incident,…
MademoiselleLenore
- 569
- 1
- 10
- 25
2
votes
2 answers
createdon field date-time format
Compiling the following coe always get the same frustrating mistake. I'm trying to compare a "createdon" field to a the present date. I've tried several date format but stil not working...
Error detail : "The date-time format for 23/05/2012 14:01:55…
MademoiselleLenore
- 569
- 1
- 10
- 25
1
vote
2 answers
How to write QueryExpression for following query?
I am trying to write a plugin in dynamics crm 4.0. following is my fetch query which working fine. I tested on fetchxml Builder. but when I am trying to convert into QueryExpression it is not returing any result.
…
jk.
- 83
- 4
- 12
1
vote
1 answer
CRM 2011 Get Required and Optional Contact Names from ActivityPartySet
I am trying to create a report in SSRS for CRM 2011 and I am trying to get information from the AppointmentSet. I am able to get everything expect the Required and Optional Attendees. I'm pretty sure the AppointmentSet links to the ActivityPartySet…
user482375
1
vote
0 answers
FetchXml on Dynamics doesnt work on a specific user?
I've been struggling with a basic fetch and an inner join.
I've tried the following:
In the XRMtool FetchXML tester: the fetch works perfectly fine with some non-admin users, but not with others who have the same role as those that work.
I usually…
K M
- 11
- 1
1
vote
1 answer
How to update the quick find field in a SaveQuery entity of type SavedQueryQueryType.QuickFindSearch using C# code?
I want to update the quick find field in the default quick find view of a table using FetchXML. The original FetchXML looks like this:
Marc Polmans
- 11
- 1
1
vote
1 answer
Attributes in Linked Entities in FetchXML Kingswaysoft SSIS returning NULL
I am trying to migrate quote details using the Kingswaysoft SSIS CRM migration package from CRM2016 on premise to D365.
To read the data I am using Fetch XML, on the quotedetails entity and want to link to the quote entity to retreive quotenumber…
Dave Ichiban
- 11
- 2
1
vote
0 answers
How to convert this SQL Query to FetchXML Query for Power Automate Flow?
I'm looking for help in converting the SQL query below into a FetchXML Query.
Background/Purpose: As part of building a PowerApps' Flow, I need to List Rows in Microsoft Dataverse (Dynamics 365 in particular) so that I can get a daily email…
larsonist
- 11
- 1