View Designer failing to retrieve column data

[lfinman]

I am working with D365 Customer Engagement, intend to alter an existing view using XrmToolBox/View Designer. View contains three fields from Order Lines entity: Existing Product, Unit, Quantity. View Designer in XrmToolBox does not display data for the Quantity column, it is just blank. If I select 'Edit Query' and view the query results FetchXML Builder, the Quantity column contains data. View also displays correctly in D365. Any idea why it is not displaying in View Designer? (I am hoping to modify the view to aggregate/sum quantity, so dead in the water without quantity data). Other views that include the Quantity column also fail to retrieve data into View Designer.

I am using View Designer Version 1.2016.8.7, XrmToolBox version 1.2019.2.32

[shytikov]

Hi,

Thank you for reporting this. Can you please also provide information on the type of quantity column? Maybe window screen shot on its definition in CRM?

Could it be that it's calculated field or something that requires additional handling before displaying.

[lfinman]

Thanks for looking into this. Seems to me that there is corruption somewhere – before submitting the error I uninstalled/reinstalled the View Designer in XrmToolBox to see if the problem went away but it persists. I do believe at one point I was able to see the numerical values in View Designer but no longer. Please let me know if I should completely uninstall/reinstall XrmToolBox. Quantity is a simple field. Precision was originally set to 5. I changed it to 0 (we only deal in whole numbers) after this problem started occurring to see if publishing a change would change anything. Published and reopened XrmToolBox/View Designer – the Quantity column is still empty. [cid:[email protected]] To test display of other numbers, I created a view on the Order Line entity that contains all numerical types (currency, whole number, decimal). The data is missing in View Designer but available in FetchXML Builder. [cid:[email protected]] [cid:[email protected]] I also created a different view on the Order entity, to see if the problem was limited to the Order Line entity. Same result – numerical values not displayed in View Designer: [cid:[email protected]] [cid:[email protected]] From: Alexey Shytikov <[email protected]> Sent: Tuesday, April 30, 2019 10:32 AM To: Innofactor/XrmToolBox.Plugins <[email protected]> Cc: Finman, Lyn <[email protected]>; Author <[email protected]> Subject: Re: [Innofactor/XrmToolBox.Plugins] View Designer failing to retrieve column data (#39) Hi, Thank you for reporting this. Can you please also provide information on the type of quantity column? Maybe window screen shot on its definition in CRM? Could it be that it's calculated field or something that requires additional handling before displaying. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#39 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AJ6RKSMZV6FVBGTGOCRCSH3PTBJ5VANCNFSM4HJL33YA>.

[shytikov]

Ok, I got it. Will try to find something similar on my system to test.

You should get notification when something will change on this task. When I'm done you would also need to install newest version of the tool....

[jwwimer]

I have a similar issue - please let me know if I should report as separate issue.

I am a first-time user of the FetchXML Builder and View Designer, so not sure if I am doing something wrong.

I modified a personal view in FetchXML Builder for the purpose of displaying columns for 2 fields from a related entity's related record (source lead), 1 relationship deeper than Advanced Find allows for adding columns. These 2 fields' data return when executing in FetchXML Builder, but do not return when selecting "Live Preview" in View Designer once returning the FetchXML.

All other columns/fields selected as column options in View Designer from the main 2 relationships (main entity, then related opportunity) return in both FetchXML Builder and View Designer.

Additional Issue Detail
When publishing the view and attempting to run in Advanced Find or from the record menu, an error displays "To use this saved view, you must remove criteria and columns that refer to deleted or non-searchable items"

Viewing the column properties along with this error would lean to the Source Lead ID field not having the searchable flag set in field properties, but it is Yes for searchable. I have retried and tested this several times.

System Info

• On Premises 8.25 (prod) and 8.28 (dev and test), tested making the updates in both)
• Field type - custom: single line text, 100. Has never been altered; date; out of box createdon.
• Updated XRM toolbox to v1.2019.633 this morning to see if the issue resolved itself, but still occurring. Not sure what version I had yesterday when I originally attempted updating this view

I don't understand why the desired data is displaying in FetchXML Builder but not View Designer or Advanced find once Published. Thanks for your help!

[Joren97]

Hi

Im having the same issue as described by @lfinman. Is there any update on this?

Thank you for you help.

[interfacemirror]

Is there any update on this thread? I have the same problem.