411 questions
0
votes
1
answer
16
views
crm 2016 Query Builder Error salesorderdetail customView
We are using M$-CRM 2016 onPremise 9.1 and having the following issue:
I have a lookup on the entity salesorderdetail and use addCustomView for a special filter. But I always getting the error ...
- 303
0
votes
0
answers
47
views
Pass variable into FetchXML via Javascript for Dynamics 365
I'll keep this concise as I find I ramble on too much if I don't.
I've come up with the code below, but I believe I need to add it as an OnClick event for the Add Existing contact button. Can someone ...
- 11
0
votes
0
answers
87
views
Power Automate Paging with FetchXML
We have a case where we need to fetch more than 5,000 records from a D365 entity. We cannot use OData filtering due to complexity of the query, so we have to use FetchXML.
In the screenshot below, all ...
- 149
0
votes
1
answer
54
views
I need to create a fetchxml retrieving cases where department is opening user's (user profile->) department
On D365 I have to create a view "Created By Users Department". On User and Case we have Department lookup.
<fetch>
<entity name="incident">
<attribute name=&...
- 11
0
votes
0
answers
28
views
Prefiltering Fetchxml SSRS
I am trying to get the guid in the dataset and use that value in multiple datasets using fetchxml in SSRS. I would like to display the related records from each entity in a table within the report. ...
0
votes
1
answer
138
views
SSRS - Rows are repeating in table
I am creating a report in SSRS and i am having an issue that the table is repeating. In the table 6 records should be presented but insted are shown 12.
Repeating rows on the left and only one row on ...
0
votes
1
answer
50
views
How can I use Alexa CRM to display an aggregated result in WordPress
I'm currently using the Alexa CRM plugin for WordPress to connect to my Dynamics CRM. I'm trying to get the results of the following aggregation
[msdyncrm_twig]
{% fetchxml collection="simpleagg&...
- 105
1
vote
1
answer
372
views
Dynamics 365 FetchXML nested link-entity, not-in
It's a long shot, but in FetchXML I have an entity with a many-to-many relationship with another table. In short, the Contact entity is linked with the ConnectionRole entity through an intermediary ...
- 13
0
votes
1
answer
429
views
Filtering FetchXML request by number of records in related entity
In Microsoft Dynamics/Dataverse, I'm trying to write out a FetchXML request on an entity which is related to another entity in an 1:M relationsship. I want it to retrieve parent records which are ...
0
votes
1
answer
132
views
get the active fetchXML value of view from javascript
I am doing ribbon button for a view, the button should run an operation on each record the user sees.
e.g. If the user applies the filters to show only records with condition fieldX = valueX so the ...
- 178
0
votes
1
answer
41
views
Distincts rows in a FetchXml query
In this FetchXml Query, I want to get distinct row but I get many time the same cic_disponibilitesid value. It's because more than one row in cic_engagements are related to the cic_disponibilites row.
...
- 1
0
votes
1
answer
673
views
Filter lookup with fetchXML and special character '&' does not work
I am currently trying to filter a lookup field in Dynamics 365 CRM using a fetchXML in a javascript. I have to view all the products with a custom text field ('my_variantstatus') not equal to 'R&D ...
- 1
0
votes
1
answer
414
views
Use nested fetchXML with IN operator
I'm trying to get all Model-Driven Apps in a Power Platform environment, which are not part of any solution.
I want use the result of a fetchXML statement as the input condition for another statement, ...
- 249
0
votes
1
answer
644
views
Extracting Dynamics 365 data using Azure Data Factory pipeline with FetchXML query
I want to use FetchXML query to extract data from Dynamics 365 in Azure Data Factory.
I used this initial setup for the entity 'campaignactivity' (without any FetchXML query):
And in preview data I ...
- 73
0
votes
2
answers
79
views
Reformat list items with Liquid
I have a Dynamics 365 API which is FetchXML & Liquid.
Nothing wrong with API, that all works well.
Most of the fields the API pulls from in Dataverse are text fields. So when staff do (stupid) ...
- 418
0
votes
1
answer
452
views
Capture Row Number in SSRS Report
I am new to SSRS. This is for a Dynamics CRM report. I have a tablix where I am displaying the row numbers using the RowNumber() function. My question is-Is there a way I can display a particular row ...
0
votes
2
answers
494
views
How to convert this SQL query to Fetch XML?
Is it possible to write this SQL query as a Fetch XML query? http://www.sql2fetchxml.com fails to convert this query.
select a.ownerid, b.call_count
from opportunity a
join (
select vsg_loan, count(*) ...
1
vote
0
answers
92
views
FetchXml on Dynamics doesnt work on a specific user?
I've been struggling with a basic fetch and an inner join.
I've tried the following:
In the XRMtool FetchXML tester: the fetch works perfectly fine with some non-admin users, but not with others who ...
- 11
0
votes
2
answers
729
views
Combining 2 FetchXML With Same Dataset but different filters in Linked Entities
Is it possible to combine 2 FetchXMLs, which are fetching same data, but different filters in linked entities?
Below are 2 FetchXMLs that I am trying to merge to optimize performance. I marked each ...
- 4,603
0
votes
1
answer
72
views
Unable to add a condition using a column from a secondary table on Kingswaysoft
I'm trying to retrieve data using KingswaySoft, and I need to use columns from both the primary and secondary tables in my conditions. However, KingswaySoft does not support this functionality. I also ...
- 311
1
vote
1
answer
83
views
How to update the quick find field in a SaveQuery entity of type SavedQueryQueryType.QuickFindSearch using C# code?
I want to update the quick find field <new_prim1> in the default quick find view of a table using FetchXML. The original FetchXML looks like this:
<fetch version="1.0" mapping="...
- 11
0
votes
1
answer
2k
views
How to write fetchXml to get distinct data in dataverse connector
I am creating flow where I am using Data verse Connector and written fetchXml to get data from checklistquestionresponse, annotation and checklistasset entities, but in annotation holds multiple ...
- 69
0
votes
1
answer
33
views
FetchXML table issue
I have a table A named PWD_WARE and Table named PWD_Company.
I can display with left join the table PWD_WARE and table PWD_Company as following
Joined PWD_Company and PWD_WARE
PWD_Company
PWD_WARE
A
...
0
votes
0
answers
43
views
Power BI how to pass a null as a text in a function in FetchXml
I have a FetchXml query for returning dynamics crm data that I have generated using XrmToolbox with Power Query (M) Builder.
The data is more than 5000 records and creates an invoked function to set ...
- 1
0
votes
0
answers
80
views
SSRS FetchXML number of days between 2 dates excluding weekends
I have 2 fields of DateTime from CRM 365 Online and want to create a custom report with a textbox that calculates the number of days between 2 dates excluding weekends in FetchXML (Bonus to also ...
- 19
0
votes
1
answer
436
views
Use date parameter in Azure Pipeline FetchXML query
in my Azure Data Factory pipeline, I have a parameter, let's call it 'pDate', and it has a default value of 2023-01-01.
But every time I run the pipeline (copy data), I want to be able to change it.
I ...
- 53
0
votes
0
answers
76
views
Is there any way to display null values (as string) in a multi-value parameter using FetchXml query in SSRS reports?
I'm learning SSRS and stuck in a scenario where I want to display some records (containing null values) in a multi-value parameter. I'm using Dynamics 365 Fetch query. For a simple drop-down allow ...
0
votes
0
answers
360
views
How to fix Http request failure when trying to query the Microsoft Dataverse Web API from Power Automate?
I'm trying to retrieve all the users and their roles across some environments in my Office 365 tenant using a Power Automate flow, but when I'm trying to query the Dataverse Web API either with OData ...
- 43
3
votes
1
answer
520
views
Dynamics FetchXML condition checking text field beginning with pattern "xxABC"
In Microsoft Dynamics 365 FetchXML, is there a way to check a text field with the condition that it begins with "xxABC", where "xx" can be anything?
- 4,603
0
votes
1
answer
523
views
fetchxml does not reuturn column in dynamics
I am using Python to send a http GET request to extract the contacts associated with a segment. The segment for example called "Test Segment" which has a unique identifier "a1-b2-c3&...
1
vote
1
answer
709
views
Attributes in Linked Entities in FetchXML Kingswaysoft SSIS returning NULL
I am trying to migrate quote details using the Kingswaysoft SSIS CRM migration package from CRM2016 on premise to D365.
To read the data I am using Fetch XML, on the quotedetails entity and want to ...
- 11
0
votes
0
answers
702
views
"Object reference not set to an instance of an object" retrieving multiple records with IOrganizationService
I am creating a plugin for Dynamics 365 in C#. I am trying to make request using fetchXML, however I am getting the following error: Object reference not set to an instance of an object.
Here is my ...
- 69
0
votes
2
answers
1k
views
SSRS - The report parameter has a defaultValue or a ValidValue that depends on the report parameter
In an SSRS report, I have a fetchXML query that is dependent on the parameters that the users will choose from the UI that are defined in the report:
<fetch xmlns:generator="MarkMpn....
- 125
-1
votes
1
answer
1k
views
How to exclude some attribute from fetch xml but Retrieve all other attributes
I want to retrieve all attributes of entity but exclude some of them.
Like if entity have 42 attributes I want to exclude Name, Date and retrieve all others. Below is what i have tried.
<fetch ...
- 41
0
votes
0
answers
76
views
How to show data for current (using dataset1) and last quarter(using dataset 2) in SSRS?
I need to show total number of cases open during current quarter(selected from parameter) and open cases in last quarter. I'm using different datasets with different conditions for my report. One ...
0
votes
1
answer
196
views
How to create Quarter parameter for SSRS Fetch xml when there is no Year or Quarter field
I'm new to SSRS and building an SSRS Quarterly Report using FetchXML for Dynamics365.
I need to create a parameter for Year and Quarter (Jan-Mar, Apr-Jun, Jul-Sep and Oct-Dec).There is no Year and ...
0
votes
1
answer
68
views
Concatenation and count SSRS report
I have this dataset :
Product
Account
Product X
Account 1
Product X
Account 1
Product Y
Account 1
Product Y
Account 1
Product Y
Account 1
And in my Table matrix i want this output
Product
...
0
votes
1
answer
594
views
Dynamic 365, get owner of a record with FetchXML / C#
How do I retrieve owner of a record (for example a task) with FetchXML or C#?
I can connect the two tables task and owner with FetchXML :
<fetch>
<entity name="task">
<...
- 11
0
votes
1
answer
475
views
fetchXML simple account retrieve
I'm trying to do a fetchXML query against my account list using the simple query provided here
Normally, I would expect this to respond with a json responses alongside the account I'm running a query ...
- 461
1
vote
0
answers
313
views
How to convert this SQL Query to FetchXML Query for Power Automate Flow?
I'm looking for help in converting the SQL query below into a FetchXML Query.
Background/Purpose: As part of building a PowerApps' Flow, I need to List Rows in Microsoft Dataverse (Dynamics 365 in ...
- 11
0
votes
2
answers
258
views
SSRS Get number of filtered groups
Working with dynamics 365 reports has brought me to the next issue.
Because FetchXML doesn't support NOT EXISTS condition, i have to filter data inside report.
The case is that I have like 7000 rows ...
- 43
0
votes
1
answer
742
views
How to fetch users not in a specific queue/team?
I have a task to create a custom grid view of users not in a specific team.
I created the fetch according to team (entity) not equal to my specific team but I didn't get the wanted results after ...
- 1,476
0
votes
1
answer
268
views
Switch expression in SSRS + CRM : Argument 'VarExpr' is not a valid value"
I'm using SSRS with Microsoft Dynamics 365 Fetch where my FetchXML contains the attribute having Option Set datatype - where as option set values are like below:
Value =====> Label
1 =====...
- 6,858
0
votes
0
answers
573
views
Dynamics (FetchXML) - Error: Aggregates are not supported
I'm fairly new to the FetchXML / Dynamics scene so please excuse my ignorance.
Up until now I've been executing a PowerShell Script that runs a FetchXML query to obtain user most recent login dates ...
- 33
0
votes
1
answer
78
views
Moving from Office365 Auth to OAuth
So there's a piece of software using the deprecated Office365 Auth type and I am working to change it. However I cannot seem to get my head around how to edit the following:
String ...
- 111
1
vote
1
answer
1k
views
Difference between odata and fetchxml
I would like understand the difference between odata and fetchxml, this has to do with pagination in MS Dynamics, I am very new to the stack and would like to understand why there are two object ...
- 21
0
votes
1
answer
169
views
how to embed ssrs fetchxml dynamics 365 report in Web Page?
We have a requirement where we have to embed our Dynamics 365 fetch XML SSRS report in the web portal? please suggest how can we achieve this scenario?
- 682
1
vote
2
answers
2k
views
How to join Audit table to Entity table using FetchXML in Dynamics 365 Customer Engagement
I would like to add a link to the Entity table in this query:
<fetch version="1.0" >
<entity name="audit" >
<all-attributes/>
</entity>
</fetch&...
- 49
0
votes
1
answer
703
views
Dynamics Portal Last Login of a Portal enabled Contact
I'm developing a MS Dynamics portal and I have my test contact authenticating (using Azure AD) into the portal but I can't find how to get the last (or any) date time the contact logged into the ...
1
vote
2
answers
425
views
Why does the fetchXML Web API url require an entity name?
In order to formulate a FetchXML web request, I have to use the entity name twice, once (in plural form) in the URL and once (in the singular form) in the fetchXML query document:
https://abcdef.ghi/...
- 40.4k