"Hello and Happy Holidays,
I am currently dealing with an issue related to several User-Defined Types (UDTs) that periodically write to the same table in MSSQL. Each instance of the UDT also includes its reference number.
I am in the process of creating an easy-chart template in Vision, aiming to dynamically associate some database pens. The goal is to showcase the historical data of a selected UDT, identified by the parameter 'NumberOfInstance'
In order to achieve dynamic functionality, I have utilized a custom property to construct the WHERE clause, as illustrated in the screenshots below
Despite my efforts to bind this custom property to the parameters within the DB Pens editor, the Where clause of the edit pen menu, and the Where clause of the easy chart property editor, I consistently encounter the same error.
It appears that the easy chart widget automatically generates a query with two WHERE clauses, leading to a rejection by the SQL compiler. I suspect this may be a bug in the widget.
I would greatly appreciate any suggestions or approaches to circumvent this repetition. Thank you in advance for your time; I welcome any insights to address this situation.
Best regards,
Simone