FetchXML not retrieving data, column Position

(0) Share

Report

Posted on by Guy Parisi

I'm running a FetchXML query using SSRS and the FetchXML connector for CRM Online. This is what I'm running:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="systemuser">
    <attribute name="fullname" />
    <attribute name="positionid" />
    <attribute name="systemuserid" />
    <order attribute="fullname" descending="false" />
    <filter type="and">
      <condition attribute="isdisabled" operator="eq" value="0" />
    </filter>
  </entity>
</fetch>

When I run this as an advanced find in CRM, it shows the Name and the Position of the active users. When I run this using the query designer in SSRS it yields the name, but the position column is blank down the line.

Has anybody run into something like this before? Am I doing something wrong?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

BharatPremji 2,485 on at

Like (0)

Report

Guy,

The first thing to check is if the right field in CRM is populated, The position field on the User record in CRM is:

When you put your Fetch statement into SSRS, you should see something like this:

The positionid field should contain the Text Value of the field you need and the positionidValue field will contain the GUID.

If you add the fields to a table in the SSRS report:

and run, this is what you should see:

Hope that helps

Bharat

Was this reply helpful? Yes No
Guy Parisi on at

Like (0)

Report
Bharat,

Thanks for the reply! I'm positive the field is filled in. I'm using XrmToolBox to do a fetch query against the server. Here is my updated fetch:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" > <entity name="systemuser" > <attribute name="systemuserid" /> <attribute name="positionid" /> <attribute name="positionidname" /> <attribute name="fullname" /> <order attribute="fullname" descending="false" /> <filter type="and" > <condition attribute="isdisabled" operator="eq" value="0" /> </filter> </entity> </fetch>

Here are the two different result sets:

Position is clearly showing up with the XrmToolKit, but not with Visual Studio. The fetch XML is exactly the same. Does VS function differently?

Was this reply helpful? Yes No
Guy Parisi on at

Like (0)

Report

Ok, I think I figured out WHY the problem is occurring, but not how to fix it.

It looks like my visual studio is only connecting to my test environment. I've even changed my connection string to "https://2.crm.dynamics.com" and it STILL connects to my test environment. At least this gives me something to look at.

Was this reply helpful? Yes No
Verified answer

Guy Parisi on at

Like (0)

Report

Alright! I'm in. Looks like I was just being a noob about the whole thing. changing my connection string to:

https://<server>.crm.dynamics.com;<OrgID>

That worked perfectly.

Was this reply helpful? Yes No