rappen / FetchXMLBuilder

FetchXML Builder for XrmToolBox and Microsoft Dynamics 365 / CRM
https://fetchxmlbuilder.com/
GNU General Public License v3.0
135 stars 55 forks source link

Last Name won't display? #1048

Closed daryllabar closed 1 month ago

daryllabar commented 3 months ago

Weird behavior with names and some sort of caching.

Run this query first:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="contact">
    <attribute name="fullname" />
    <filter>
      <condition attribute="lastname" operator="eq" value="Smith" />
    </filter>
  </entity>
</fetch>

Looks good: image

Then update fullname to lastname and run again ( I hand typed it in the xml window, not sure if it matters):

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="contact">
    <attribute name="lastname" />
    <filter>
      <condition attribute="lastname" operator="eq" value="Smith" />
    </filter>
  </entity>
</fetch>

I get this result with no last name or full name: image

But if I add in the full name, it returns correctly, but then if I remove the fullname, the full name is still shown in the grid, but empty...

rappen commented 3 months ago

Most likely it happens when you change attributes to return. In the second, you ask for the lastname, but it shows fullname. Which is a bug, too well known. If you go to the low-menu, select Columns and Show All. Now you see lastname, I hope.