Stack Overflow
Stack Overflow

Questions tagged [fetchxml]

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.

400 questions
0
votes
1 answer

Fetch XML Using a Field Value

Can Fetch-XML for a sub-grid view be written to include a field value on the record? I have a custom entity with a lookup to Account. I would like to have a sub-grid of Cases related to that Account; the grid would show Cases related to the Account…
Bvrce
  • 2,170
  • 2
  • 27
  • 45
0
votes
1 answer

MS Dynamics-CRM How can I find GUID of the existing view by "Display Name" using JS?

I have category 1, category 2, and category 3. Cat1 is parent of cat2. Cat2 is parent of cat3. View for every category filtered by parent. Problem: category 3 doesn't get filtered if cat2 is not specified when cat1 selected. Need: in addition to…
Alexey
  • 47
  • 1
  • 11
0
votes
1 answer

FetchXML based SSRS report deployment error

I am submitting a little problem I am unable to solve. Maybe it will help somebody in the future. I am working with BIDS 2008 and Dynamics CRM 2011. I just developed a FetchXML-based report (client requirement). Also, I used expressions as my…
Edouarddp
  • 1
  • 3
0
votes
3 answers

CRM 2011: Fetch Error

I have an error with a script that contains multiple fetch in crm 2011... the error is that the key dosent exist & is coming from: if no recordes exist with the…
Richard Dewhirst
  • 229
  • 7
  • 20
0
votes
1 answer

How to use OrganizationServiceProxy on my Plugin - CRM 2011?

I need to use fetch xml in a CRM plugin, and I found here an example on how to do that: string groupby1 = @"
Ewerton
  • 470
  • 7
  • 20
0
votes
1 answer

Set 'X' dynamically in 'next x days filter' in Advanced Find

In my custom Dashboard, I would like to show a list of data. When I am creating a custom view using Advance Find, I am using "next x days" filter. Can I set that 'X' dynamically from my custom field? Each row can have different X. I can do this…
ziffo
  • 43
  • 1
  • 5
0
votes
1 answer

How to change date format in date picker for SSRS fetchXML reports for MSCRM 2011?

How to change date format in date picker for SSRS fetchXML reports for MSCRM 2011? By default it is setting date picker format to mm/dd/yyyy. I want to change to dd/mm/yyyy format.
Jai Mallesh Babu
  • 325
  • 1
  • 3
  • 11
0
votes
1 answer

Create a FetchXML query that uses ISNULL

I want to make a FetchXML query that is using ISNULL like in SQL query. In SQL SELECT * FROM Contact WHERE ISNULL(FirstName, '') = '' Do they have any operators for it in FetchXML?
daniel
  • 320
  • 4
  • 14
0
votes
1 answer

FetchXML reports in MSCRM Online do not work for more than 250. It throws generic error message

While running the FetchXML reports from BIDS(Business Intelligence Development Studio), all of them work fine with all filters applied. But, when the same report is deployed to MSCRM Online, they throw a generic error message(message: error…
Jai Mallesh Babu
  • 325
  • 1
  • 3
  • 11
0
votes
1 answer

Creating a tricky fetch XML in CRM Dynamics

I'd like to make an advanced search that combines fields from two different entities that are in many-to-many relation to each other. In SQL it's very straight-forward but in Dynamics I get stuck. I'd like to get a general answer but if it helps,…
Konrad Viltersten
  • 36,151
  • 76
  • 250
  • 438
0
votes
1 answer

Define an expression according to the last record

I've created a custom report in Fetch XML with an expression calculating the time spent on each incident according to a date range parameter. No problem here to create the expression but this one should only concern the last contract record (I…
MademoiselleLenore
  • 569
  • 1
  • 10
  • 25
-1
votes
2 answers

Dynamics 365 default value in FetchXML

Is there anyway I can receive a default value in Fetch XML queries For example If in the entity "fullname" is not set in dynamics currently it's not returning the attribute. Is there any way I can receive blank in the…
DaemonBee
  • 41
  • 6
-1
votes
1 answer

Document Core Pack fetch

can anyone give me an Example of fetch Condition that i can used for the Document Core Pack fetchxml i use the DCP for a dynamics crm Template.
bnb
  • 101
  • 2
  • 12
-1
votes
2 answers

create Advanced and Custom Dynamics CRM online report

I know how to create the report using ADVANCED FIND but I want to create a Custom Report in CRM online using fetchxml.
akshay pattar
  • 13
  • 2
-1
votes
1 answer

'OR' condition in fetchXML

I have to achieve 'OR' condition using fetchXML in CRM 2015 between two different entities. I need to make the condition contact.region = 'region1" or firm.region = "region1". I realize I have to use tag, but I am not sure how to…
gemini
  • 1
1 2 3
…
26
27