Wednesday, 21 May 2014

CRM 2013 Manage Column Order in Query Result of Dialog

In My Previous Post, I was explaining about Dialog that I have to use for my customer requirement.

Now, I have this Dialog

Unordered Response Values Result


But, that is not in good Column Ordering.

If you take a look, the column sequence from that Options are :

Name | Amount (Net Selling Price) | Quote Type | Quote ID
In this case I want more structure :
Quote ID | Name | Quote Type | Amount (Net Selling Price)

Then, I back to my Process and then I found that I use this :
image

But in this area, I only can select or de-select the column, I cannot manage the column order.

Then, I back to my Query Data :

image

Then I try to Edit Columns :

image

And yes, it is actually already ordered.

But, I still cannot have the order that I want, then I go to another tab, Modify Query Variables.

image

Well, here is actually unordered and it seems like my current order in the result.

The XML is different from the Design Column, even though I use my existing View that already clearly ordered.

Well, this XML will determine the Order.

I tried to re-order this by editing line by line, but it is disable to be edited.
Well, I thought it was impossible.
Then, finally, I can achieve this.

What I did:

1. I remove all of the columns

image

2. Then I add the column one by one while I was ensuring in the XML I can have same order of attribute.

image

3. I see the XML

image

The XML attributes order is exactly same with what I want.

Then here is the result in Process Responses Page Setting :

image

Ya, this is exactly what I want.

Let’s test it!

image

Yes, the Column Order is : Quote ID | Name | Quote Type | Amount (Net Selling Price)

Finally, I can achieve this.
This is little bit annoying why the XML cannot follow the Design View, then I have to remove and re-add again to get the correct XML Attribute Order.

2 comments:

  1. What if I have a linked entity in Query CRM Data? I want a field from my linked entity first and then a field from priamry entity. Looks like you can't do with workaround mentioned here. Could you please confirm if this is possible? Thanks in advance.

    ReplyDelete
  2. It is perfectly working. Many thanks.

    ReplyDelete

My Name is..