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
0 answers

creating a simple pie chart

I need to create something like this in SSRS: My source dataset is fetchxml. I have actually two datasets. One dataset is just the datapoint "347" whereas the other datapoint is "1000" Dataset_Active returns 347 Dataset_InActive returns 1000 I…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
0
votes
1 answer

How to get 2 aggregate functions in one FetchXML script?

Let's say I have a dataset: +--------+-------+----------+ | Animal | Price | FoodCost | +--------+-------+----------+ | 1 | 23 | 22 | | 1 | 32 | 33 | | 1 | 7 | 69 | | 2 | 45 | 55 | | 2 | …
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
0
votes
1 answer

DynamicsCrm - Retrieve Multiple is not supported

I´m developing a data-extraction tool that gets data out of DynamicsCrm. I have a few tables tough where i get the following exception: Additional information: The 'RetrieveMultiple' method does not support entities of type…
kamahl
  • 931
  • 1
  • 8
  • 20
0
votes
1 answer

FetchXML issues with aggregate groupby on an option field

I am having issues with a FetchXML query running against Dynamics CRM 2013 (online). When running this simple query …
PAB
  • 51
  • 1
  • 3
0
votes
1 answer

Converting an entity attribute to string for condition clause in FetchXML

I need to write a query that returns all entries that have a certain decimal attribute that begins with a certain number string. Something like ... WHERE TO_STRING(numerical_attribute) LIKE '%' || my_substring ... So, for instance, if query the…
Heathcliff
  • 3,048
  • 4
  • 25
  • 44
0
votes
1 answer

CRM 2013 - What to do with FetchXML Query In Javascript

I currently need to retrieve a attribute that is present in a Sub-Grid, how I've done this previously is a C# Plugin with a FetchXML Query within to retrieve the attribute. However, I want to retrieve the attribute and put its context into a field…
Sjharrison
  • 729
  • 3
  • 16
  • 39
0
votes
1 answer

Fetch XML Query Issue

Within the company I'm working for I've created a new entity in Microsoft Dynamics CRM 2013 called Issue, within the entity Issue there is a sub grid where users can add records from the entity Cost To Business. The purpose is that users add the…
Sjharrison
  • 729
  • 3
  • 16
  • 39
0
votes
1 answer

New Left Outer Join feature in FetchXML

I understand that Left Outer Join basically means that whether or not the condition is satisfied in the target table, get all the rows in the first table. "Microsoft Dynamics CRM 2013 Unleashed" book, explains that CRM 2013 introduces a new feature…
user3340627
  • 3,023
  • 6
  • 35
  • 80
0
votes
1 answer

FetchXML query issue

I have a custom entity called Issue which has a grid linked to a entity Cost To Business, users can add records from Cost To Business to the issue record. I want a overall cost to business field to be auto populated from the items in the grid. I've…
Sjharrison
  • 729
  • 3
  • 16
  • 39
0
votes
2 answers

Grouping in SSRS

I have a fetchxml report setup to pull data from our CRM instance. Inside Visual Studio it is laid out as such when it pulls the information job number new lot rough start date city builder 30774-00c custom …
user3324859
  • 57
  • 1
  • 5
0
votes
1 answer

How to filter a date that is before a certain date using FetchXml?

I am currently using the Advanced Find in CRM 2011, and I can't seem to find a way to filter a Date field that is before a certain date. The closest operator that I could find was "on-or-before", but I need it to be before that date and not on it.
dalawh
  • 886
  • 8
  • 15
  • 37
0
votes
1 answer

Will FetcXml always search the first 5000 records?

I have a FetchXml report running on CRM Online 2013 with some 12,000 records. The data is shifted from CRM Online to SQL database through a script. I want the record that was currently modified to be shifted to SQL only. Here is my query string…
hkhan
  • 843
  • 2
  • 19
  • 45
0
votes
1 answer

C# Plugin For CRM2013 - Not receiving Product Name + Quantity in fetch xml query

I'm trying to retrieve data from a Grid in my Entity Orders. I've used advance find and selected the entity order products to get the product name and quantity that has been selected by the user in the grid My code is as follows 'Guid orderID =…
Sjharrison
  • 729
  • 3
  • 16
  • 39
0
votes
2 answers

CRM 2013 C# PlugIn - Fetch XML Query

I have a Grid on my entity page Orders, users can add products to the entity grid For my plugin I need to know what products have been inserted into the grid so that I can then produce a CSV file I've tried using a FetchXML query to retrieve the…
Sjharrison
  • 729
  • 3
  • 16
  • 39
0
votes
1 answer

need help for sql query to Fetch XML query in CRM2011?

I have this query select d.ope_supervisorName,d.ope_categoriaName ,d.ope_categoria,d.ope_cuota,d.ope_cuotaventadetId ,f.Ope_name,c.ope_name from ope_cuotaventadet d join ope_figura f on d.Ope_supervisor=f.ope_figuraid join…
angel
  • 4,474
  • 12
  • 57
  • 89
1 2 3
…
26 27