Stack overflow with circular virtual object expression
I want to use the virtual object feature to substitute a table name with a query but need help with the syntax of the expression for the MetadataObject.
Say I have a table named TABLE1, and want to have it replaced with:
(SELECT * FROM TABLE1 WHERE COLUMN1 = 'Value')
When it replaces the original TABLE1 with my expression, it seems to then replace the TABLE1 in my expression with my expression again, over and over until it fails.
If I define my table as "TABLE1_AQB" then it works, but I'd rather not have users seeing that _AQB in the ObjectTreeView