search

Innofactor / XrmToolBox.Plugins

Version Verifier, Steps Manipulator, Auto Deployer (formerly known as Cinteros Tools)
https://www.nuget.org/packages/Cinteros.XrmToolBox.Plugins/
10 stars 5 forks source link

View Designer failing to retrieve column data #39

Open lfinman opened 5 years ago

lfinman commented 5 years ago

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

Data in FetchXML Data in View Designer

shytikov commented 5 years ago

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 commented 5 years ago

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:image003.png@01D4FF46.7F0F74E0]

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:image001.png@01D4FF47.1648AED0]

[cid:image002.png@01D4FF47.1648AED0]

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:image004.png@01D4FF47.DF376F20] [cid:image005.png@01D4FF48.3471D2F0]

From: Alexey Shytikov notifications@github.com Sent: Tuesday, April 30, 2019 10:32 AM To: Innofactor/XrmToolBox.Plugins XrmToolBox.Plugins@noreply.github.com Cc: Finman, Lyn LFinman@TorrentialData.com; Author author@noreply.github.com 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 GitHubhttps://github.com/Innofactor/XrmToolBox.Plugins/issues/39#issuecomment-487975663, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AJ6RKSMZV6FVBGTGOCRCSH3PTBJ5VANCNFSM4HJL33YA.

shytikov commented 5 years ago

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 commented 5 years ago

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.

image

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.

image

System Info

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 commented 3 years ago

Hi

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

Thank you for you help.

interfacemirror commented 2 years ago

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