Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
When I click on the column header the grid refreshes but worker names don't get sorted properly. I tried to use personnel number but it didn't work either. How to fix this?
The form field which you are selected should be Display method.
Please check the property of the field.
Hi Michael Vitenzon,
For personnel number field table you write the refresh,reread in table_DS in your form.
To me it is not clear which form you refer to exactly, from where you opened the form and what you added modified to get things sorted the way you require. Could you possibly post the navigation path and some screenprints that illustrate the issue? Many thanks and best regards,
Where do I find it? I've attached screenshot.
I think it does it for other fields but for the worker.
I have attached the screenshot above.
Try the following
Step 1: Open the AOT and identify the following table for which you create a new index based on the worker field (just drag & drop the field from the field section)
Step 2: Open the data sources of your form and adjust the sort index as follows (In my case I replaced the SortIdx with my newly created index1)
Please note that you should do this only for testing purposes. To apply it in a live environment, get some help from a developer.
Thank you so much for your quick response. I followed your steps but the worker name field still doesn't get sorted properly when I click on the column header. The table is linked by worker but users obviously want to sort by name. Maybe be that's the problem. Seems like the original developer was trying to accomplish this with foreign key : Do I need to remove it first before applying your new index?Thanks again,Michael
What I showed you above sorts the form only the first time you open it. Once you click on the header above the worker field, it rearranges the sort order once again. I think that you might be right with the FK relationship but as I mentioned I believe that it requires some more advanced development skills than the ones I have.
Tipp: Probably try to modify and extend the categories that you used to classify your question and add the "SDK" tag so that the development experts in the community can easily identify your issue and help.
All the best,
I thought it will be an easy fix for a such a basic functionality.
Good morning Michael,
Well, it might be easy for the right person but I am not the one as I am working in the functional area.
Please note that I modified the tags and classification of your thread so that other more professional people with development experience might be able to identify this thread and hopefully help you fixing your requirement.
Business Applications communities