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
0
votes
1 answer
FetchXML next page results
I want to populate a grid with data from Dynamics CRM. I use fetchXML, to get for each page 10 records. I want to get to the next page, to retrieve the next 10 records. But this isn't happening, I'm using XRMToolbox to simulate the fetch query but…
gdyrrahitis
- 5,598
- 3
- 23
- 37
0
votes
2 answers
FetchXml group by different values
I want to count Status Reason on Case entity. But I don't know how to group by as shown bellow. I was looking around but couldn't find anything useful.
------------------------------------
ALIAS | STATUS…
Matjaž
- 2,096
- 3
- 35
- 55
0
votes
0 answers
CRM 2011 FetchXML returning invalid XML
I am trying to retrieve an account but the fetchXML is returning invalid XML:
function SelectLoadOutTransactionCurrency(id)
{
debugger;
var _oService = new FetchUtil(_sOrgName, _sServerUrl);
var sFetch = "" +
"
Dan Tromp
- 189
- 12
0
votes
1 answer
How to get the tracing logs for Dynamics CRM 2015 online reports
I'm working on migrating Dynamics CRM 2013 on prem to Dynamics CRM 2015 online update 1 and have prepared a report that has a child report as well. After successfully uploading the reports and setting up parent/child report relationship. I get "The…
A.K
- 505
- 1
- 12
- 30
0
votes
1 answer
Attribute type "Virtual" is not supported. Remove attribute "XYZ" from the query, and try again
I'm converting SQL to FetchXml for migrating existing reports in Dynamics CRM 2013 to Dynamics CRM 2015 online. There is an optionset and ran into this issue that
The attribute type "Virtual" is not supported. Remove attribute "s_expensetypename"…
A.K
- 505
- 1
- 12
- 30
0
votes
0 answers
Aggregate "Max" function in Fetchxml for NVARCHAR
I am facing error in converting this SQL Query to fetchxml.
Please Help.
SELECT max(territoryidname) from systemuser
I tried putting this in fetchxml- aggregate="max".
It is throwing an error :
MIN or MAX aggregate can not be applied on NVARCHAR.
0
votes
1 answer
Dynamics CRM 2015 Applying custom subgrid with FetchXML (getElementById(“selectedGrid”) returns null)
I am using Microsoft Dynamics CRM 2015 on-premise version.
I am applying a custom FetchXml to a subgrid using JavaScript.
The issue here is document.getElementById(“selectedGrid”) returns null.
I read articles says that this method is not supported…
Mouhie
- 59
- 2
- 3
- 16
0
votes
1 answer
MS CRM: How can I query for phone calls without Recipient ("Call To")
Wie imported a bunch of phoneCalls via Excel in our MS CRM 2013 system but for some of them the recipient (Call To) field were not set. Now we want to query for those records via FetchXml. How can we do this?
I tried the following, but it I received…
Jer
- 383
- 3
- 17
0
votes
2 answers
FetchXML - Today - minus 30 days
I am attempting to create a FetchXML script that retrieves records with a date of today minus 30 days.
Below is the SQL that works. Could somebody help me with the FetchXML, please?
SELECT *
FROM [students]
WHERE start_date =…
Richard Butterwood
- 735
- 1
- 12
- 29
0
votes
1 answer
FetchXml: filter by today is within the last x days of a date/today is exactly x days from a date
1.
dalawh
- 886
- 8
- 15
- 37
0
votes
1 answer
How to Join table with Itself to produce 2 duplicate rows using FetchXML
I'm trying to create duplicate records in my result set in order for me to show row more than once in a report. Some rows need to show up in multiple groups. My answer to this is to have FetchXML return dupes and then ill just create group filters…
Pavel P
- 241
- 1
- 7
- 16
0
votes
1 answer
CInt(Count("") Counting rows in current group in FetchXML report
I've converted an SSRS report from SQL to FETCHXML that was used by on-premises CRM 2011.
Now the report is using CRM 2013 as the data source.
In the old version of this report we had this expression:
=String.Format(New…
Alex Gordon
- 57,446
- 287
- 670
- 1,062
0
votes
2 answers
Report showing NO DATA when uploaded to crm online
When building a report in SSRS and viewing it in PREVIEW mode, my report is showing lots of data; however, when deploying it to CRM online 2013, this is what I am getting:
This is CRM DYNAMICS ONLINE 2013
The data source is FetchXML and does not…
Alex Gordon
- 57,446
- 287
- 670
- 1,062
0
votes
1 answer
CRM 2013 refresh subgrid with fetchxml
In my scenario, i have a new entity called "new_relations" with 2 fields (account1 and account2) that are both lookups to accounts.
In my accounts form i want to display a grid containing any record with the current account, in any of the 2 lookups,…
Ricardo Maia
- 3
- 1
0
votes
1 answer
Join/Filter syntax for activity pointers using fetchxml
I have a requirement to pass in a fetch statement for a subgrid to use in CRM 2013. It needs to get the following:
All Activities regarding contacts who are connected to a contact through a connection. (This statement gets those)
Dave Hoyt
- 37
- 7