104
Views
8
Comments
[OutSystems Data Grid] Datagrid in webblock is not refreshed
outsystems-data-grid
Reactive icon
Forge asset by OutSystems
Application Type
Reactive

Hi 

i am using datagrid in webblock and input of webblock is JSON which i am generating based on the database.column and row value can be add or can be remove and after that when i am generating the custom and trying to pass the json value as input in the webblock then based on the input parameter change it is not refresing the datagrid.i am attacging the OML.can any one plz check what i am doing wrong.

SKAN-Playground.oml
2019-11-08 14-27-49
Miguel Riso Almeida

hi Arkyadeep, 

The source of your table is being refresh on your on parameters change action?


Could you please upload de oml ? 

2023-06-14 08-52-52
Arkyadeep Bharadwaj

OML file uploaded there.u can check

2022-11-12 11-28-30
Gonçalo Martins
Staff

Hi @Arkyadeep Bharadwaj 

Can you please share the steps to reproduce and a video showing what you're mentioning? 
I'm not getting what you're reporting nor want to achieve.

2023-06-14 08-52-52
Arkyadeep Bharadwaj

i am uploading OAP file.you can check the OAP file.webscreen name is "RunForm".i am generating json like below 

"[{"FirstName":"sourav","LastName":"pasari","Address":"","Email ID":"s@gmail.com","Gender":""},{"FirstName":"Arkyadeep","LastName":"Bharadwaj","Address":"Kolkata","Email ID":"arkadeep2007@gmail.com","Gender":""}]"

but it is coming like below

Null value fields are not coming. I cant use structure to deserialize.

Dynamic Forms Reactive -Demo.oap
2023-06-14 08-52-52
Arkyadeep Bharadwaj
Dynamic Forms Reactive.oap
2021-03-18 21-03-15
Benjith Sam
 
MVP

Hi Arkyadeep,

  • If you are referring to the additional blank row created as highlighted in the picture, it's because the ShowAggregateValues property value is set to True.

  • If you want to refresh the Grid on source data value change, then refer to the below-mentioned post link for a possible solution.

https://www.outsystems.com/forums/discussion/82816/datagrid-does-not-respond-to-schema-change/#Post346075

I hope this helps you!


Kind regards,

Benjith Sam

2023-06-14 08-52-52
Arkyadeep Bharadwaj

Data refresh code is already there but it's not working and I am not talking about blank row.in json data address data for 1 record I have value and other record I don't have any value but both are not coming in datagrid

2022-11-12 11-28-30
Gonçalo Martins
Staff

Using ArrangeData or in some scenarios, the JSON Deserialize is a requirement, so any custom use case out of this will need to be manually handled by you while creating a JSON "manually" which also will bring you performance issues at scale - and this is not a supported use case.
Even though, if you really want to to that approach that we clearly don't advise I would suggest creating a similar sample using ArrangeData or JSON Deserialize to compare the JSON you're creating manually with the one that is supported and, based on that fine-tune your code to be compliant with what the Data Grid expects. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.