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
2 answers
How could I fetch data using left outer join in Fetch XML?
How could I fetch data using left outer join in Fetch XML?
I could make columns, but couldn't display data.
I'm building SSRS reports with Visual Studio 2008, and CRM version is CRM 2016 Online.
This fetch XML query doesn't display data which is in…
esperanish
- 21
- 2
2
votes
1 answer
FetchXML Filter out Duplicate Values
I have a program that pulls Invoices from our CRM Dynamics Online system into a .csv file.
Sometimes our salespeople create multiple invoices on the same Order in CRM, and I need a way to remove any duplicate invoices on the .csv.
I would like to…
Andy Jr.
- 95
- 1
- 10
2
votes
1 answer
Fetch XML report aggregate undocumented limit
I've been struggling with this one fetchxml report for Dynamics CRM online.
The report is using aggregate to detect duplications based on certain fields. So, even though it is an aggregate report, the data set will return a lot of rows. Then I…
Nay Min
- 85
- 10
2
votes
1 answer
Changing Subgrid filter throwing error in dynamics crm 2015
Good afternoon. I am running into a REALLY wierd issue trying to change a datagrid, and google hasn't been any luck. I am using the below javascripts to set the fetch and layout of a subgrid called "Opp_Prods".
function…
Josh Alcorn
- 158
- 1
- 17
2
votes
4 answers
Can you write a single FetchXML query to get 1:many relationship?
Is it possible to write a single FetchXML query that gets a root entity and multiple children? All I've been able to do is 1:1.
paulwhit
- 8,719
- 4
- 29
- 30
2
votes
0 answers
FetchXML equivalent - Left outer join, Union and Ordering
I'd like to create a dynamics CRM 2013 report which basically joins one table to a union of two other tables, with a left outer join. I believe that the outer join is now not a problem with the latest version, however there is still no union…
Ross Buggins
- 195
- 1
- 11
2
votes
1 answer
Query all Subjects that have no children
I'm trying to write a FetchXML query that produces a result set containing all Subjects that do not have any child subjects (or equivalently, subjects not used as the parent of another). These "leaf" subjects can occur at any level in a multi-level…
KeithS
- 70,210
- 21
- 112
- 164
2
votes
1 answer
How to query privileges specific to entity (without the ID of the entity record) using CRM 2011/2013 sdk?
Creating an external MVC website using CRM 2011/2013 web services. Must hide/show parts of the application based on write access to a certain custom entity. Found solutions like…
Rohit Tidke
- 150
- 1
- 10
2
votes
2 answers
FetchXML: get count of records based on a field of a linked entity
I have a scenario where i want to get the count of people from an Entity who have multiple location address marked as current address in other linked entity.
Neodine
- 53
- 1
- 7
2
votes
1 answer
'in-year' operator in FetchXml condition
I was looking for an 'in-year' operator in FetchXML conditions, but only found the 'in-fiscal-year' operator.
Is there a workaround for this functionality?
Marvin
- 539
- 5
- 17
2
votes
3 answers
How to pass "like" or "Contains" parameters to fetchXML in ssrs report
I tried to pass parameter to fetch XML for generating report.
It works fine for "Text Equals" field. But does not works for "Contains" .
I tried this but it doest work.
Vishnu
- 1,029
- 4
- 14
- 24
2
votes
1 answer
CRM 2011 Activities
I am building a ssrs report for crm 2011 using fetchxml.
I have a table to show all open activities for a user. I want to be able to show the Account the activity is related to.
I am able to do this if the regarding field is set to the account but…
Dustin Warner
- 71
- 1
- 3
2
votes
1 answer
FetchXML Filters With Different Entities
I wish to filter my entities in CRM2011 using a fetchXML filter. However, I'm having issues with AND and OR groupings over different entities.
I am searching for clients based on their consent, where each client will have either 1 or 0 valid…
Irish Yobbo
- 403
- 1
- 6
- 21
2
votes
3 answers
CRM FetchXml, how can I dynamically add quicksearch filter that will match related entity's name?
I have a web page outside of CRM that allows users to perform CRM lookups. I need to implement filtering the lookup results using quick search like in the normal CRM UI.
I get the FetchXML for the selected entity/view, then get the FetchXML for the…
Jeff Shepler
- 2,007
- 2
- 22
- 22
2
votes
3 answers
How could I remake FetchUtil.js for CRM 2011 UR 12
I have to remake FetchUtil.js for using it in CRM 2011 UR 12. I'm not very good in javascript, so I need some help.
This is the native code
var sFetchResult = xmlhttp.responseXML.selectSingleNode("//a:Entities").xml;
var resultDoc = new…
Sergii Gorkun
- 216
- 2
- 15