This is a migrated thread and some comments may be shown as answers.

ForeignKey column?

6 Answers 455 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Randy Hompesch
Top achievements
Rank 1
Randy Hompesch asked on 26 Oct 2019, 12:49 PM

Does anybody have an example of how to do this in the blazor grid?

If not,  does anybody have an example of a dropdownlist column template that show the text in the grid but stores the id in the list of items for the grid?

Thanks … Ed

 

6 Answers, 1 is accepted

Sort by
0
Accepted
Marin Bratanov
Telerik team
answered on 28 Oct 2019, 08:44 AM

Hi Ed,

At the moment, a built-in feature for foreign keys does not exist. I am not completely sure it makes sense for Blazor because templates here are super powerful, and this can easily be solved through a template: https://docs.telerik.com/blazor-ui/components/grid/templates.

For example, the editor template example is pretty close to what you described. You can also define a method that returns the desired item from the secondary collection based on the ID coming in from the main one and use that to display data. Or, you could define a view model that contains that data in the first place so you don't need foreign keys at all.

Nevertheless, if you would like to see some built-in feature about this, I'd encourage you to post it in the feedback portal together with some more details on why template are not sufficient and how would a built-in feature make things easier (and perhaps how you would expect it to be exposed).

 

Regards,
Marin Bratanov
Progress Telerik

 UI for Blazor
0
Randy Hompesch
Top achievements
Rank 1
answered on 28 Oct 2019, 10:50 AM

Yeah, after posting that I later figured out how to use the templates and was on my way. I didn't have a way of going back and deleting the posting. Hopefully, it'll help someone else.

Once again… thanks!

0
Rajesh
Top achievements
Rank 1
answered on 05 Dec 2020, 06:12 PM

Hi Marin,

I used Template for foreign key-column into Telerik Blazor grid. But while doing group by and filter its showing Id, instead of name. Can you suggest how can show name instead of id in group by and filter.

Here is coloum code:-

    <GridColumn Field=@nameof(ItemSubCategoryMaster.Category_Id) Editable="true" Title="Category"   Width="100%">
                    <EditorTemplate >
                        @{

                            currentItem = context as ItemSubCategoryMaster;
                            <TelerikComboBox AllowCustom="false" @bind-Value="@currentItem.Category_Id" Data="@ItemCategoryMasterList" Placeholder="Select Category"
                                             TextField="@nameof(ItemCategoryMaster.Category_Description)" ValueField="@nameof(ItemCategoryMaster.Category_Id)" Filterable="true"
                                             Id="Category_Id" Width="100%" />

                        }

                    </EditorTemplate>
                    <Template>
                        @{
                           
                            int CategoryId = (context as ItemSubCategoryMaster).Category_Id;
                            string Category = ItemCategoryMasterList.Where(x => x.Category_Id == CategoryId).Select(x => x.Category_Description).FirstOrDefault();
                            <text>@Category</text>
                        }
                    </Template>
                
                </GridColumn>

 

0
Marin Bratanov
Telerik team
answered on 07 Dec 2020, 08:59 AM

Hello Rajesh,

The approach is the same - you should use the grid templates to alter what the grid will render.

You can find more examples and information in the following KnowledgeBase article: https://docs.telerik.com/blazor-ui/knowledge-base/grids-foreign-key.

 

Regards,
Marin Bratanov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Rajesh
Top achievements
Rank 1
answered on 07 Dec 2020, 06:25 PM

hi Marin ,

 

Thanks for feedback.

But it's increase too much work for developer. Is it possible to get built-in option for foreign key-column?.

It will really help us.

0
Marin Bratanov
Telerik team
answered on 08 Dec 2020, 10:19 AM

Hello Rajesh,

You do not have to implement all the templates, you should implement only the ones you need per your use case.

Using the templates will provide full flexibility as opposed to a built-in feature that will still require that you provide the foreign key data and synchronous access to it, but it will be complex to configure, while rather limited in what it could do. How would you expect to expose all those capabilities I've showcased in the KB through some built-in feature?

 

Regards,
Marin Bratanov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Grid
Asked by
Randy Hompesch
Top achievements
Rank 1
Answers by
Marin Bratanov
Telerik team
Randy Hompesch
Top achievements
Rank 1
Rajesh
Top achievements
Rank 1
Share this question
or