Problem with column with foreign key value

Radzen.Blazor Components
1

Hi everyone
I'm using RadzenDataGrid control and i have a column that handles an Int64 value but that value has a foreign key to another table and I want to show the description of that value and also be able to filter by that description in the filters. I tried using FilterTemplate but no good results. Is there any type of special column that allows specifying values ​​and their foreign key?

image
image1129×392 25.2 KB

                    <RadzenDataGridColumn TItem="DepositarioAdminWeb.Entities.Tables.Banca.Banco" Title=@MultilenguajeController.ObtenerTextoPorClave("PAISID",dataLenguaje) Property="PaisId" Width="100px">
                        <Template>
                            @if (Pais_PaisId_entities.FirstOrDefault(c => c.Id == @context.PaisId) != null)
                            {
                                <RadzenLabel Text="@Pais_PaisId_entities.FirstOrDefault( c => c.Id == @context.PaisId).Nombre" Component="PaisId" style="width: 100%">
                                </RadzenLabel>
                            }
                            else
                            {
                                <RadzenLabel Text="No data available" Component="PaisId" style="width: 100%">
                                </RadzenLabel>
                            }
                        </Template>
                    </RadzenDataGridColumn>

Thanks!

2

You need to use FilterTemplate indeed. Check our online demos and other forum threads for ideas.