select_statement

Questionsselect_statement
David Gilmore asked 3 years ago

I have conditional select statements. One returns columns a, b, and c. Another returns columns c, d, e, and f. The query is dependent on a master grid selection. The selection action happens with no errors but the grid does not change. Do I need to refresh the grid so that it picks up the query change? Thanks in advance.

1 Answers
Abu Ghufran answered 3 years ago

This requirement is little difficult.

The grid is loaded with 2 server calls.
1) make structure of grid (i.e. columns headers, dialogs etc)
2) do an ajax call, to load data of grid.

Now if you are changing columns of grid, that means ajax call will not map it as returned data have different field names and count.
One option is to do a complete refresh, which will re-create new grid structure.

Another option is to use nested subgrid. When we click (+) on row, nested subgrid always load structure and data both.

Your Answer

15 + 4 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?