I'm trying to filter a Radzen Generated Table that has an Active-Inactive column (Foreign key column )from a Dropdown, I've followed all the tutorials, and isn't working. is there any other resources.
Thanks
Dropdown Filter
What property is used for this column FilterProperrty? Here is how it looks usually:
To display also related data you will need $expand parameter
I'm trying to filter the table to the active Status, hide the status column, then toggle from active to inactive from the dropdown.
What's the Status column definition?
The first screenshot is the column definition/properties. I'm not sure about the second screenshot - where is the DropDown?
Instead Data Source Method Invoke on DropDown Change event you can just set a Page property (for example Status) with the changed value and execute load() method for the DataGrid. You can use the DataGrid LoadData event to retrieve the data and include Status page property in $filter using Query Builder:
DropDown Change will set Page property
DataGrid bound to Orders with related entities included
Create query for DataGrid LoadData
Add CustomerID Page property to $filter
Reload DataGrid on DropDown Change
Now you can remove Customer column and filter Employee column by LastName
Got it Working though the datagrid doesn't load data until the dropdown is toggled
Thanks
If you have Placeholder for the DropDown there will be no item selected initially and when you choose something the DataGrid will be reloaded.
Still not getting the Data to load. I think it is the filter, as everything else seems to work but this. also, I removed the '-' brackets off from your example, it wouldn't work otherwise.
According to the URL ActiveStatusID is not defined - you need to define it before executing load() for the grid. Not sure about the brackets, in my example I’ve used single quotes since in my case the type of the property is was string. I’ve noticed also that you removed the grid filter part from the query builder and the column filtering will not work. Please check my example - both filters are combined with AND.
I started over
I set the property ActiveStatusId (FK in Facility Table int) and Value ${event.Id} (PK in ActiveStatus Table int). Ive also tried using ${ActiveStatusId} for the value
then set the Filter to ActiveStatusId equals ${ActiveStatusId}
I aslo tried ActiveStatus.Status for the Property or the Status Column
Still wont load data into the table. Still getting ActiveStatusId undefined, how do you define it.
Thanks