Page History

...

For this to happen, there are many ways to do it but we will focus on the dataset data loaded from its binderdata store. First, we can inspect how data is constructed.

...

The grid is using a pair of identical load and store binder data store (which makes sense most of the time so that data is stored and loaded from the same source). We can opt to use JDBC Binder Database SQL Query data store as the load binder data store so that we can gain full control on how dataset is returned and constructed.

...

...

However, it does not actually play out well with the JDBC Binder Database SQL Query data store as it is only expecting one parameter in the query. Our union query has 2 parameters.

...

...

With the stored procedure to return the appropriate dataset that we need, we will just need to call it from the JDBC BinderDatabase SQL Query data store.

This is the outcome.

...