hi guys,
i have figured out how to query the DB for linked tables, thanks again for all your help
i have this working for one datagrid on this page, however the below DG which bs formed and populated in the same way is not rendering with content...i have included the data payload delivered, so i know the query and query results are correct
this is the DG which is rendering correctly, again, it's the same setup as the one above
i'm currently thinking it is related to the data bind, you can see in this screenshot, the Task Databind property is visible in the list
however the incident one is not....
both are created in exactly the same way on page load
and both follow the same pattern for pupulation
The plot thickens....
i removed the first datagrid to see if it was some sort of memory thing....
no luck the 2nd datagrid still didn't bind correctly.
I then put the first grid back and then copied it
I removed the 2nd faulty datagrid and i placed the copy of the 1st datagrid where the 2nd one was
I then changed the data source of the 2nd data grid to the "linkedIncidents" property
it rendered.....
there was no underlying code change
now to make matters more interesting, i added a 3rd datagrid from scratch, same code replication, same approach and found that with the new datagrid, the render failed
this datagrid was added from the toolbox and manually configured.
the one thing i notice however is in the data property of the datagrids, i can now see the Incidents array which i could not see before
i am missing the Risk Discovery array which should be visible
i can see the linkedRiskDiscoveries in the expression however
i suspect there is an issue between the pageload set value not appearing in the Data bind list which is failing the subsequent bind and rendering of the datagrid
until that set property shows up in the data bind list, the UI will fail.
that therefore raises the question, why isn't the page load - set value creating the data bindable property ?
i'm assuming this Dynamic reference is due to the lack of mapping the datagrid to a set property from the page load
interestingly, after i closed Radzen down and re- opned it and launched the project, i could see the missing page load property in the data bind
and we are now rendering....
okay, i think i have found a bug....
this may not be limited to HTTP request style properties, but worth investigating....
when adding a new HTTP to serverMethodsController
and then writing the code to call that on the page.radzen
that function is callable via the page load invoke method
however the subsequent SET PROPERTY
is not available to databind until you reset / reload the Radzen project,
hence it was missing earlier and was not allowing the datagrids to bind / render correctly.
it might be worth looking into to see what's not getting called post setting these properties on page load
sorry for the long post, but it's taken a bit of diagnosis work
