Greetings, and May the 4th be with you!
I have a table with a foreign key (int) value that is set to a parameter and is expected to be passed to a dialog. The int value is used to filter a grid in the dialog. For some reason the parameter returns null when the dialog is loaded, even though the the foreign key exists. The IDE shows the value type as 'Int?' which I know to be nullable int. If I manually set the parameter to the actual interger that the foreign key is instead of using the foreign key's table property, it works as expected. I will also note that if I used the parameter in one of the grid's header columns in the dialog, removing the 'parameters' portion (combinedframeworkId
), it does display the Id. What are common causes of this behavior? I have other grids and parameters configured in exactly the same way that dont seem to have this issue. I am using sqlite database, dotnet 6 and Radzen IDE 2.68.6. Could this be a bug? I have not had this issue before.
Dialog Grid with parameter value passed to header, but returning null in the filter:
IDE & variable:
Database Entry:
Dialog Parameter:
Dialog Load event 'get' filter:
If I replace ${combinedframeworkID}
with direct values from the table like '7' or '8', it functions as expected and loads the correct grid items. Otherwise, nothing loads. I have alternatively tried appending .getValueOrDefault()
, .Value
, and done a check for .HasValue
on the variable and parameter in which case all three return null.