142
I have an Advance Find that returns 31 records. If I download the FetchXML from that Advanced Find and then either run it in VB using the SDK or using XRMToolKit FetchXML Tester it only returns 17 records. Anyone know why this is?
*This post is locked for comments
Just to add a bit more to this:
Hey Jon,
Is there any Date/Time type of field in your Fetch XML conditions?
When working with dates, always remember to convert to UTC since that is how CRM stores them in the database.
The native CRM Advanced find is going to look at whatever the current user's time zone is, and convert that whatever time they enter into the advanced find to UTC before performing a SQL query.
Your custom code/plugins will need to do the same thing.
Hope it helps.
If my answer helped to resolve your issue, kindly verify it by clicking 'Yes'. It would be helpful to the other community members seeking to resolve a similar issue.
Cheers
Arpit
https://arpitmscrmhunt.blogspot.in
Found the problem
If I use
DateTime today = DateTime.Now;
string fetchXMLDate = today.Year.ToString() + "-" + today.Month.ToString() + "-" + today.Day.ToString();
I get the different results
If I use the today operator in the FetchXML I get the same results. No idea why that is.
I am using the same server, same organisation and same credentials confirmed. I have tried a different browser with the cache cleared and still I get different results between the browser and XRMToolbox
It is not possible, please check for any saved credentials which browser might be using for login. One other option would be that you are connecting to different environment in XRM toolbox.
If you are connecting to same organization, same credentials, you will get same result in any way or retrieval.
I am copying the FetchXML directly from the Advanced Find and pasting it into the XRMToolBox FetchXMLTester using the same username and password and I get the different results.
Hello Jon ,
Its not possible , seems something is difference in your code , could you please check in XRMToolBox fetchXML tester once .
Could you please share your code and fetchXML once.
There are two possiblities which could cause this issue.
1. Different user names being used between browser and toolbox.
2. Fetch Xml have additional filters which filters some more record.
I am using the same username and password for both the application and the code.
It must be the different user credentials being used with different access levels. Please check the user account used to connect to Dynamics 365.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (