Can you use a SQLDataGrid to mockup a table. I do not see a way to have a table in a graphic without the SQLDataGrid object. I know there is a widget, but since I am using OMI it doesn't work within a graphic. I eventually want to have it pull data from a sql table but for demonstration purposes would like to create a mockup table without a database.
Agreed with Ernst, I've tested out with version 2023R2 and found some satisfactory results in rapidly mocking up a data on our DataGrid widget within an industrial graphic. You can easily paste a JSON payload in the data source field but make sure you remove all whitespace data or else it will fail to load, has a neat little repair function as well. A tool that I found useful is the following online link:
Note: Provided a sample of what could be used
[{"id":1,"name":"cerulean","year":2000,"color":"#98B2D1","pantone_value":"15-4020"},{"id":2,"name":"fuchsia rose","year":2001,"color":"#C74375","pantone_value":"17-2031"},{"id":3,"name":"true red","year":2002,"color":"#BF1932","pantone_value":"19-1664"},{"id":4,"name":"aqua sky","year":2003,"color":"#7BC4C4","pantone_value":"14-4811"},{"id":5,"year":2004,"color":"#E2583E","pantone_value":"17-1456"},{"id":6,"name":"blue turquoise","year":2005,"color":"#53B0AE","pantone_value":"15-5217"}]
Agreed with Ernst, I've tested out with version 2023R2 and found some satisfactory results in rapidly mocking up a data on our DataGrid widget within an industrial graphic. You can easily paste a JSON payload in the data source field but make sure you remove all whitespace data or else it will fail to load, has a neat little repair function as well. A tool that I found useful is the following online link:
Note: Provided a sample of what could be used
[{"id":1,"name":"cerulean","year":2000,"color":"#98B2D1","pantone_value":"15-4020"},{"id":2,"name":"fuchsia rose","year":2001,"color":"#C74375","pantone_value":"17-2031"},{"id":3,"name":"true red","year":2002,"color":"#BF1932","pantone_value":"19-1664"},{"id":4,"name":"aqua sky","year":2003,"color":"#7BC4C4","pantone_value":"14-4811"},{"id":5,"year":2004,"color":"#E2583E","pantone_value":"17-1456"},{"id":6,"name":"blue turquoise","year":2005,"color":"#53B0AE","pantone_value":"15-5217"}]
