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
Passing Date Expression in SSRS using fetchXML for CRMDynamics 2016
Quite new to this area so apologies if at all I sound vague. I am trying to create date parameters in SSRS for CRM Dynamics2016.
Objective: To create a drop down containing: Last Year, Last Month, Fiscal Year, Year to Date and use them to filter…
Salman.Syed
- 3
- 2
0
votes
1 answer
fetchXml from CRM - is it possible to fetch just the "last" record for a linked entity?
I tried using top="1" and an order descending in the linked-entity element, and I still get back multiple records joined.
Den
- 146
- 1
- 4
0
votes
1 answer
How do I pass lookup object values into a FetchXml query?
I am trying to filter a lookup field products with another lookup field editorial (my company sells textbooks).
I know how to retrieve values from the lookup object but I do not know how to pass them into my fetchXml query statement.
function…
Carlos Farmer
- 67
- 11
0
votes
1 answer
Dynamics CRM. Fully custom FetchXml in subgrid
I'm making a subgrid on account to show all related contacts by multiple fields.
Here's fetch xml I'm trying to set:
nazarevic
- 120
- 1
- 10
0
votes
1 answer
How can I populate fields with information related to single lookup field?
I'm working on a form 'Enrollment Adoptions' in CRM 2015, specifically with three fields; Product, Component, and Editorial. 'Product' is a lookup field referencing the Product Entity. 'Component' and 'Editorial' are simple text fields to be filled…
Carlos Farmer
- 67
- 11
0
votes
2 answers
Correct expression with IIF does not work
I work with CRM online. This is why I use fetchXML. This is my fetch:
`
Jakobinec
- 63
- 13
0
votes
3 answers
calculate the time difference between two dates in HH:MM format using ssrs
I need to generate the time difference between tow dates in SSRS in HH:MM format. How can i achieve this? My data source is MS CRM FetchXML.
Eg : Date1 : 01/01/2016 04:05 AM
Date2 : 01/03/2016 02:15 PM
Time Differece Should be : 58:10…
Sandeep T
- 421
- 8
- 22
0
votes
0 answers
Subgrid containing Activities returned by FetchXML query - not always refreshing
I have created a subgrid on a Form for the Contact Entity in Dynamics CRM 2015 which returns all Email, Task, Appointment and Phone Call Activities where either the Activity is Regarding the Contact for which the Form has been loaded, or where that…
3N1GM4
- 3,372
- 3
- 19
- 40
0
votes
1 answer
convert my sql query to queryexpression or fetchxml in crm
I have this SQL query where I am trying to fetch the opportunityId from opportunity entity for whom approvaldocument has not been created (approval document is the name of the other entity) .I dont think fetchxml supports such kind of query. I am…
Debleena De
- 1
- 3
0
votes
1 answer
Activity records in Dynamics CRM 2015 returned in subgrid by FetchXML query - Subject hyperlink opens new Activity
I am trying to create a subgrid on a Form for the Contact Entity in Dynamics CRM 2015 which returns all Email, Task, Appointment and Phone Call Activities where either the Activity is Regarding the Contact for which the Form has been loaded, or…
3N1GM4
- 3,372
- 3
- 19
- 40
0
votes
1 answer
Timestamp in SSRS date parameter
I am working on an ssrs report with fetchxml as the data source. I have two date parameters in the report. When we provide different dates in from and to parameter , the report works without any issue. But if we provide the same date for both the…
Sandeep T
- 421
- 8
- 22
0
votes
1 answer
Conditional rollup fields for report
I have a report requirement to calculate campaign revenue (sum of associated Opportunity's actual revenue) on the basis of 30 days old, 60 days old and 90 days old opportunity. We are working on Dynamics crm online 2015.
Something like the…
Mahmood
- 177
- 2
- 10
0
votes
2 answers
If-else clause in fetchXml CRM
I want to get data from two tables deal and details. I could make join and fetch data but I couldn't figure out how to link-entity on a condition. In simple terms, I want
if deal.sell is yes:
fetch details
else:
fetch deal
The xml below…
user2714823
- 607
- 5
- 15
- 29
0
votes
1 answer
FetchXML to filter by name of E-mail's RegardingObjectId
I have a query that starts at the QueueItem and, if the entity that Queue Item references is an E-mail, adds some additional filter conditions. One of those conditions is the primary field value of whatever that e-mail, in turn, is "Regarding". I…
KeithS
- 70,210
- 21
- 112
- 164
0
votes
2 answers
Dynamics CRM FetchXML equivalent of SQL with sub query aggregate column values
I have a requirement to generate a CRM Report (online, so have to use FetchXML) that shows Customers plus the number of products they ordered, with a column for each (pre-defined) category.
The entities are effectively: Customers, Orders, Orderlines…
David Carle
- 31
- 4