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

Get distinct rows before applying aggregate count in FetchXML

I'm trying to get the count of contacts who have activities. I'm retrieving only one attribute in my FetchXML "fullname" with the aggregate function "count" applied on it. I also have a link-entity with ActivityParty to ensure that this contact has…
user3340627
  • 3,023
  • 6
  • 35
  • 80
0
votes
3 answers

Aggregate function with FetchXML

I need to fetch the entity who has the max date in a certain field. I tried the code below with Stunnware but it gives me an error that the MAX function is invalid.
user3340627
  • 3,023
  • 6
  • 35
  • 80
0
votes
2 answers

Dynamics CRM subgrid with all related instances of same type

For accounts in Dynamics CRM I have a custom related entity X (one account can have zero or more Xs related to it). On the form of X I want to show a subgrid with all active instances of the same type related to the same account. Is there a…
krembanan
  • 1,408
  • 12
  • 28
0
votes
1 answer

How to create Team base Report in CRM 2011

I want to create case report in Dynamics CRM 2011. That show all cases of a Team. How can I filter this filter in fetch-XML Query.
riaz.usmani
  • 271
  • 1
  • 4
  • 13
0
votes
1 answer

How to get those Record whose Activity Created or Change in last 24 hours in CRM

I am creating CRM 2011 Fetch-xml Report and want to get those contact whose activity has been change or created in last 24 hours. how can I do that.
riaz.usmani
  • 271
  • 1
  • 4
  • 13
0
votes
1 answer

CRM Fetch Statement Filter Condition where 2 lookups equel 2 linked entities

I Have a fetch and I want to link an entity where 2 lookups contain to other linked entity ID's Code: …
Richard Dewhirst
  • 229
  • 7
  • 20
0
votes
1 answer

Convert Query into Fetch-XMLQury

I want to change select query into FetchXML Query. My query is SELECT * FROM new_periodtotal JOIN product ON product.pruductid = new_periodtotal.product JOIN new_program ON new_program.product = new_periodtotal.product Problem is there is no…
riaz.usmani
  • 271
  • 1
  • 4
  • 13
0
votes
1 answer

CRM 2011 Chart: count of grouped dates for other field

I have an entity expressing employee absences split per half day (AM and PM). the entity has 4 relevant fields: the employee name (another custom entity), a reason for absence (holiday, overtime reimbursement, paid vacation, allowed leave,... 11 in…
Nzall
  • 3,439
  • 5
  • 29
  • 59
0
votes
1 answer

MS CRM 2011, Views filtered by teams throw error when user is not a member of any team

We have created some views that show activities assigned either to the current user OR any of the user's teams. The filtering was fairly simple: Related Activity Parties - Party equals current user OR - Party equals current user's teams This…
Egor
  • 1,622
  • 12
  • 26
0
votes
1 answer

CRM 2011 - How to set data in records from subgrid in Entity using C# code

I am making a plugin in CRM 2011. The plugin is taking data from the Entity's subgrid by using fetchXML, making some calculate with the data and at the end of the plugin I want to set the new calculated data back in the subgrid, but I can't ... I…
user2968949
  • 1
  • 1
0
votes
0 answers

SSRS BIDS bind two tables together OR multiple datasets per table

I have a report matrix with several columns, where each column shows the same kind of data but with different filters. Specifically, I'm showing some aggregate numbers, but each column shows it for a different time period (one may be daily, another…
Egor
  • 1,622
  • 12
  • 26
0
votes
1 answer

CRM2011 FetchXml Error - System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse

I have change server and now i'm having a problem with fechxml, all other SOAP services are working 100%, like updade, create, delete, expect fetch, and i don`t have idea or the reason for this to be happening. Mesagem error: @"Server was unable to…
Hugo Silva
  • 155
  • 1
  • 3
  • 16
0
votes
1 answer

SSRS Report in 1:N relation

Please guide me about this. I am working on CRM online. I need report(custom SSRS) which will be invoked from Campaign and it will print all the Leads belongs to that Campaign. How should i achieve this. I created a master report based on Campaign,…
Anish
  • 588
  • 6
  • 21
0
votes
2 answers

Search all records created before 1-2 weeks ago?

I'm trying to create a report based on opportunities. One stat I'd like to see is opportunities that were modified but were not created this/last week, so I can see how many old opportonities have been worked on. However on setting the filter…
kinza tahir
  • 13
  • 3
0
votes
1 answer

Dynamics CRM Online - Modifing an existing report

I am trying to modify an existing report (Orders) and I must be doing something wrong because when I export the report and I open it in Visual Studio I don't see the actual report. As you can see the actual report is not being displayed. I go to…
Gary
  • 1,784
  • 4
  • 18
  • 38
1 2 3
…
26 27