Hello everyone, I have a little problem that I didn't yet found a solution for it.
I have a table that has data fetched by an aggregate, the table also has 2 columns, that has one block in each collumn. The blocks have a list that has data fetched by an aggregate, and the data depends on the input parameter id that is sent from the table. The problem is that when the table renders, the info of the table is fetched first, and then it shows the info of the blocks, but I want to show all the info at the same time.
I can give an example to be more clear:
Table show info about categories in a supermarket, like: fruits, toys etc
Then, one column has a block that show the products depending on the category Id, so, for fruits it shows: apple, mango etc
The thing is that in the table, the info about the categories show first, and then, 1 sec later it shows the info in the block.
How could I show all the info at the same time without using an advanced sql query?
Thanks in advance.
Hello,
You could fetch all the data at once by creating a single data action in the screen with the aggregates you need to get everything. Then pass the data directly as input parameters to the blocks instead of only passing the IDs.
However, it might very well be the case that you're reusing those blocks in multiple places, so refactoring everything as described above might not be feasible. In that case, you still have a few alternatives:
Thank you very much Aurelio. The data action solved my problem. Thanks!
You could create a Boolean Variable 'IsLoading'
The default value of this variable should be True. Using the OnAfterFetch actions and triggers in your block, you can assign the value of 'IsLoading' to False once all the data is fetched.
Use the variable with 'NOT' int front of it as the 'visible parameter' of the container that holds your table
Regards
Thibaut
I think that's not possible, because the block will only inizialite if it is shown in the screen. If I hide it, it would not inizialite and then the aggregate inside the block will not start to.
You are correct, i didn't think about it.
In our company, we solve this by implementing a loading spinner inside the webblock that is visible whilst the data is loading.This way, The table will be shown, but the content of the weblock will be a loading icon untill the data is fetched.
Hi Mauro,
Although not a direct answer to your question, try avoiding a call to the database inside a webblock in a table. There will be many little calls that amount to a longer loading time.
See if you can move the aggregate that retrieves the data of the webblock to the screen, so you have 1 large aggregate that loads the data for your webblocks. So your webblocks will have input parameters 'the full list of the aggregate' and 'the Id of things to show'.
- you have 2 aggregates on the screen. 1 retrieves the info for the table, and 1 retrieves all the details that the webblocks will use to show their data.
- your webblock will receive the entire list of data (this is by-reference so be mindful of this) and also the ID that it will use to identify which data to show. so for example in the OnInitialize of your webblock, you filter out the data that you want to show based on the ID.
- you can then use the IsDataFetched of the aggregate that retrieves the entire data set for the webblocks to show the table in 1 go.
Apart from going advanced query, this would be an alternative solution.