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
2
votes
2 answers

Select a percentage of records using CRM 2011 Dynamic Entity

I'm developing service which consumes CRM 2011 data via dynamic entities (as in, Microsoft.Xrm.Sdk.Entity, the late-binding method). I'm deliberately not using Xrm.cs method (early binding) in an attempt to keep my solution generic. Also, I want to…
Alec
  • 946
  • 1
  • 11
  • 22
2
votes
0 answers

Link entity causing exception, not sure why?

I have the below FetchXML link-entity, to execute on a Dynamics portal. However i'm getting the liquid error Liquid error: Exception has been thrown by the target of an invocation. any ideas why? How do I go about fixing this? I believe its this…
user12403387
  • 174
  • 9
2
votes
1 answer

MS CRM 2011 FetchXml - Report Parameters don't get picked up when the report is deployed in CRM

I am facing a problem when trying to pass dynamic parameters to a report created using fetchxml. When I see a preview of the report in BIDS I can enter the parameter values and the report works just fine, but the problem occurs when I try to run the…
2
votes
1 answer

Invalid Uri: The Uri scheme is too long. UriFormatException" In dynamics-CRM FetchXML

I'm trying to query a Dynamic-CRM system using FetchXML get request. The error: "Invalid Uri: The Uri scheme is too long. UriFormatException" occurs when I'm using specific attributtes\filters. For example: When trying to use filter condition…
Guy E
  • 1,775
  • 2
  • 27
  • 55
2
votes
1 answer

Use condition to get only records with non-numbers values in a fetchXml Dynamics CRM query

I'm querying Dynamics CRM using fetchXML. I have an entity that have attribute (placeName) where its value is either string or value of a number. I would like to have condition that only the records with a non-number value should be selected. I…
Guy E
  • 1,775
  • 2
  • 27
  • 55
2
votes
1 answer

Dynamics 365 CRM - Remove Outer Join Duplicates from SSRS Report

I am facing an issue with SSRS reports in Dynamics 365. I have a custom entity named entity1, which has a 1:N relationship with the connections entity. Each record in entity1 can have more than one connection to it and some records may have no…
2
votes
1 answer

Can I use FetchXML to retrieve a list of Entities and a list of Attributes?

I want a fetchxml that will return a list of Entities, hopefully with Display name and schema name. Similarly I would like a fetchxml that will return the attributes for an Entity. Also with Display name and Schema name. I assume there is a way…
2
votes
1 answer

System.InvalidCastException ("Specified cast is not valid.") in a FetchXML query for an OptionSet Attribute

I am trying to retrieve the numeric value of each OptionSet returned by a FetchXML Query. The value retrieved is aliased and I want to cast the aliased value into an integer and store each value into a list. The system gives me an…
2
votes
1 answer

CRM Api FetchXml replaces characters when using like

I'm trying to call CRM Api to fetch contacts. The requirement says I can search by name using the LIKE operator. I'm using the fetchxml below to query CRM:
EFX
  • 41
  • 5
2
votes
1 answer

Is there a way how to get total count of entities of given type in CRM without paging

Suppose I have query like var countAlias = "entity_count"; var query = FormattableString.Invariant($@"
Ondrej Svejdar
  • 21,349
  • 5
  • 54
  • 89
2
votes
2 answers

How to use 'in' operator in 'or' filter in Fetchxml based report?

I am using following xml in an Fetch based report in SSRS for Dynamics 365. I've allowed @transaction parameter to null but rest of the both parameters must have values. So, I put an or condition so that if @transaction is null or 0 then on the base…
2
votes
1 answer

How can I get Microsoft Dynamics 365 to appear in the list of data sources when creating a report in Visual Studio 2017?

vs studio data source list I have VS 15 installed but it started crashing after I installed BIDS. I know VS 17 may not be compatible with BIDS but is there a workaround because I am unable to find download links for VS 13 or older. I have the…
Luke
  • 103
  • 7
2
votes
1 answer

How to convert operator = "eq-userid" statement from FetchXML into SQL code

I am trying to convert the company FetchXML files into SQL code. when I came across this statement in FectchXML: Actually, I know it means to get the current user. Also, I have read…
Akira
  • 273
  • 5
  • 15
2
votes
1 answer

Execution of Fetch XML using Web API Dynamics 365

I am using this approach for paging using Fetch XML within Web API. Web API works perfect when we use simple fetch and it returns pagging cookie along with results if there are more records but when we use complex(where we have link entities) Fetch…
2
votes
1 answer

Access second level linked entity from FetchXML

Here is the fetchXML:
DynamicsNinja
  • 177
  • 1
  • 3
  • 17