Microsoft Dynamics CRM (Archived)

CRM 2013 Inconsistency between Layout XML and Grid Data (Add Custom Lookup Feature)

(0) Share

Report

Posted on by Aileen Gusni

44,524

Hi,

I tried to use the code:

Xrm.Page.getControl(fieldname).addCustomView(viewId, entityname, viewDisplayName, fetchXml, layoutXml, true);

To set the custom lookup as default view in lookup field, so user will always see this filtered view.

I have to use that, I cannot use the addPreSearch and addCustomFilter because I want to filter the field in the Quote Product, which is not using the refreshed UI, I read that those method are only applicable for the refreshed entities only.

At the very first time, I try to filter the Product field, yes, it is filtered, SO, I assume that Existing Product field is actually can be customized as well.

However, when I take look the columns and data, I found that the layout and the data are different, it seems that I can have filtered data, the column layout as well, they are correct, but the data is still using the former default view. SO, the columns of the data is not match with the column that I set in the layoutxml.

2364.custom-view-crm-2013-product-not-consistent4.png

But, the weird thing is, after I click the refresh button, it worked.

5444.custom-view-crm-2013-product-not-consistent-crm-2011-can.png

So, it made me starting to think whether the Product field is quite flexible to be customized or not. I thought that Product field is maybe unable to be customized (since the lookup field cannot be changed in the field properties), so I try another testing to another lookup field, to filter Account, and yes, I got the same result:

* CRM 2013 (the data vs column in defined layoutXML)

Then, I tried another research, I tried to test in CRM 2011, and, yes it is fine in CRM 2011 as per my expectation.

* CRM 2011 ( worked properly)

You can see, the column in the layout and the column data are match and consistent.

Is there anyone did experience it before?

Any other new parameters I should add?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (6)

Verified answer

Arpita Saini on at

Like (0)

Report

Hi Aileen,

I see there are two things here:-

1) After you do refresh it fixes the issue but if you observe the column header and the data is not align. Please use following to fix it :-

The reason for this is that we omit icon for entity in CRM 2013 like we used to do before. Before we had "icon='1' " +"preview='1'>" when we used to display icons along with name , please modify the Layout xml to "icon='0' " +"preview='0'

e.g:

var layoutXml = "<grid name='resultset' " +

"object='" + focusAddressTypeCode + "' " +

"jump='seera_state' " +

"select='1' " +

"icon='0' " +

"preview='0'>" +

2) Now coming on to next issue which is incorrect data that you see, yes you are right it is reported issue and I have worked with the customer on the same exact requirement.

Product team is working on it and it will be fixed in SP1 UR1.

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Hi Arpita,

Thank you for your reply.

Yes, I did notice, but not too care, as long as the data okay.

Okay, I will try to align the Column header and the data position.

But, I think the users will not too care about this, they are caring more about the data.

But, very nice info from you, I just know from you, thank you.

Anyway, from this forum, how do I submit a bug? Thank you.

Was this reply helpful? Yes No
Verified answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

you can open a feedback request inside Connect.

www.crmanswers.net/.../how-to-use-microsoft-connect-site.html

After you open it share the link so other people can upvote as well

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Hi Guido,

Thank you.

It is very helpful.

So, conclusion, this is a bug that I've submitted, this is the link, hopefully it can be fixed.

connect.microsoft.com/.../crm-2013-inconsistency-between-layout-xml-column-header-and-grid-data-add-custom-lookup-feature

Thank you.

Was this reply helpful? Yes No
Arpita Saini on at

Like (0)

Report

Hi Aileen,

Don't worry the bug is already submitted as another customer has reported the same but I would advice you Aileen to open a case with Microsoft and mention to add your case to the bug so that the priority can be increased and we can get the count of how many customers are affected by this issue.

The case that you will open be given as no-charge by us as it is a bug.

It is going to get fixed in CRM 2013 SP1UR1.

Thanks!

Arpita

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report

Thanks Alieen!

Microsoft team are u waiting for something to fix this?

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Hi Jorge,

They said in the CRM 2013 SP1 UR1...

Just wait it :)

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, I am experiencing the same problem that the data is not aligned until we do a refresh of the grid.

Did you find a solution for this?

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Hi Simon.

Not yet, it will be fixed in CRM 2013 SP1 Rollup 1 according to Microsoft.

Thank you.

Was this reply helpful? Yes No
StaceyKCRM 80 on at

Like (2)

Report

Hi Arpita: This issue seems to have crept back up again in Dynamics 365. The suggestion you provided previously does not seem to apply in this latest version. Columns are misaligned for Order Product subgrid I created. Thank you for your assistance.

Was this reply helpful? Yes No