Sort grid on different linked entity fields

[Géraud Brugière]

Hi !

We are trying to have sort grid on different columns related to a child. We want to be able to edit the child.

I've created a stackblitz example to give an example of what we need. I've used Northwind services from https://services.odata.org/V4/Northwind/Northwind.svc

Here is a liste of orders with 2 columns from the customer (as the column 'CustomerID" comes from order).

Here comes 3 problems

Sort problem

Now, I would like to sort the table by customer name or by customer title. But I'm unable to send the sort column for the linked customer. How could this be possible ? And if this is possible, how can we sort by title THEN ny name ?

Edit problem 1

Now, I have enable edition on this table. If I double-click on the first line (having no linked customer), I have a full list of customers

If I cancel the dialog an double-click on any line, I have only one record. If it's a line with a linked customer, then there is no linked customer on dialog.

And if I cancel again a redo a double-clic on any line, this time, the combo is empty !

Am I missing something here ?

Edit problem 2

Well, of course, if I modify a customer, I want the retrieve newly selected person title (in the form and then in the list). 

As a simple solution, I would be OK if the combo in the form was displaying something like " - " (i.e. : "Yang Wang - Owner"). In this case, of course, the fields "name" & "title" would be hidden (?) or, better, not present (only on form right ! ;) ).

How would it be possible to to this ? 

Thanks for any help !

[Vignesh Sivagnanam]

Hi Géraud 

Thanks for contacting Syncfusion support. 

Based on your query that you are facing issue while perform sorting and editing in the Grid. We checked the attached screenshot and also you have mentioned that you need to send the sort for the linked customer. 

 

From the attached information we are unable to understand the exact issue that you are facing at your end. So, please share the below details, 

1. Share the complete Grid rendering code with the column definition.  

  

2. Have you used complex data in the Grid? 

3. Share more information regarding the linked customer. 

4. If possible, please share the issue reproducible sample. 

5. Video demonstration of an issue. 

 

Regards 

Vignesh Sivagnanam 

[Géraud Brugière]

Hello,

So sorry, I didn't provide the link. 

Here it is : https://stackblitz.com/edit/angular-sf-grid-test1

Hopefuly, you should be able to reproduce the problems.

[Vignesh Sivagnanam]

Hi Géraud,

We have validated your issue at our end and we have consider this as Bug in grid component. We have logged defect report for the same as – “ForeignKey column datas are not populated in the dropdown while editing”. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and will include the defect fix in our upcoming weekly patch release scheduled on May 5^th 2021. We appreciate your patience until then. 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. 

Feedback Link:  https://www.syncfusion.com/feedback/24527/foreignkey-column-datas-are-not-populated-in-the-dropdown-while-editing 

Regards, 

Vignesh Sivagnanam 

[Vignesh Sivagnanam]

Hi Géraud 

Thanks for your patience 

We are glad to announce that our Essential Javascript2 patch release (v19.1.59) has been rolled out successfully. In this release we have added the fix for “No data is displayed in dropdown popup while editing the ForeignKey column in the grid” issue. So please update your package to this version to include the fix. 

Release Notes: https://ej2.syncfusion.com/documentation/release-notes/19.1.59/?type=all#grid 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards, 

Vignesh Sivagnanam