Most of the time Joel is very helpful but sometimes he’s just plain grumpy:
I’m finding that the lookup field quick preview list does not honor sort order. In this example I have a “sequence” field that sorts the list in the desired order:
If you go to the lookup dialog, it honors the sort order in the lookup view:
Is there any way to make the quick lookup preview honor the sort order?
And I kind of appreciate his grumpiness on this one because the reply from authoritative sources came thick and fast:
This is not possible today, quick preview list sorts it based on the “primary attribute” of the entity. But if this is something which blocks your scenario, I will be happy to add it into the backlog for lookup enhancements. Can you please open a connect bug for this and send me the ID.
Relentless man that he is, Joel indeed used Microsoft Connect to press on with the issue (and under the similar circumstances you, our readers, should do the same!):
Here is an existing Connect item with 15 votes. I would say this is high priority. The only way to make it work is currently to append numbers to the lookup list to make it sort correctly in preview.
I get a “page not found” error when I try to go to the existing Connect item.
The link is correct. Verify that you can login and access https://connect.microsoft.com/dynamicssuggestions/Feedback in the first place. Then try copying and pasting the link to the item.
Thank you George. That resolved my issue.
Up to 43 votes and counting…
Was there ever a resolution for this?
Did MS ever fix this issue?
function sortDescending(a,b){
return $(a).find(‘.ms-crm-IL-MenuItem-MoreInfoItem[colname=”yyy”]’).text() <= $(b).find('.ms-crm-IL-MenuItem-MoreInfoItem[colname="yyy"]').text() ? 1 : -1;
}
parent.$('#zzz_IMenu .ms-crm-IL-MenuItem:not(.ms-crm-IL-MenuItem-Lookupmore-Rest)').sort(sortDescending).prependTo('#zzz_IMenu');
This is the unsupported way of resorting the results window.
Non-developer here: where do i put this code for it to work?
That code would go into form onLoad event. Be very careful though – this code is totally unsupported and, as far as I can see, may break in v9.
Current link to the Dynamics Ideas (new Connect):
https://ideas.dynamics.com/ideas/dynamics-crm/812355
Now, 70 votes-up, status Planned Mid Term for 4 years.
this link is not working anymore (point somewhere else) https://experience.dynamics.com/ideas/idea/?idea=812355.
Please can someone paste the latest link here?
Thanks,
rt