Is there a table object that I can query my database to fill in?

I want to display data in a normal grid table. The data isn't associated with a layer in the plant. I have a database table that I want to query to insert it into a table object in OMI. I cannot find any table object. Would I need to manually create a table with grid lines? 

Parents
  • Hi Caroline, 

    You could query the data in your Layout script or Industrial Graphics symbol and put the data in a grid Client Control.

    There are some options for the use of DataGrid depending on your choice, (.Net Winforms, WPF, Webwidget) but if you want to use native components and OMI there is the DataGrid Webwidget that based on a json string or csv format that can display the contents of your resulting dataset.

    This component is also described in the help resources installed on your environment.

    https ://localhost:28808/AVEVA%20OMI/#/home/910955/10/11

    To create a symbol containing of text elements and line elements, that can display an dynamic number of rows, and use this to display a dataset is not impossible, but extremely complex and time-consuming if you want the behavior that you would expect of a datagrid.

Reply
  • Hi Caroline, 

    You could query the data in your Layout script or Industrial Graphics symbol and put the data in a grid Client Control.

    There are some options for the use of DataGrid depending on your choice, (.Net Winforms, WPF, Webwidget) but if you want to use native components and OMI there is the DataGrid Webwidget that based on a json string or csv format that can display the contents of your resulting dataset.

    This component is also described in the help resources installed on your environment.

    https ://localhost:28808/AVEVA%20OMI/#/home/910955/10/11

    To create a symbol containing of text elements and line elements, that can display an dynamic number of rows, and use this to display a dataset is not impossible, but extremely complex and time-consuming if you want the behavior that you would expect of a datagrid.

Children
No Data