Hello dear colleagues,
I’m trying to create a versatile menu, containing few buttons (mainly for opening pop-ups). The list of buttons which are displayed is controlled by simple stored procedure and the result is dataset which is then utilized by Template canvas to display only desired buttons.
However, I can’t figure out how to make these buttons to read tags and other information for specific machines. If I use SQL Query as Property Binding, the menu displays correct buttons, but these are basically dysfunctional, since they cannot utilize data provided by UDT for a specific machine. If I use Cell Update and link the correct Property as a Value for each row, it works just fine in terms of being linked to a particular machine-apart from the fact that the dataset is static, not dynamically generated by a stored procedure. The only way is to use SQL Query option as a source of data then.
I understand that the Parameters column in the dataset needs to be provided with data in a dictionary format, so I made sure that this condition is met and set this value directly in the source table in SQL (e.g. {TagFolderName:ShiftInfoCL.tplcnv_PL.TagFolderNameParamString}). However, when provided by SQL Query, Ignition seems to be using this value as a static, not as a link to specific object property.
Is there any way how to provide dataset from SQL and simultaneously make the data in Parameters column dynamic?
Thank you very much for any guidance or inspirational ideas!