Active Query Builder support area

Stack overflow with circular virtual object expression

Avatar
  • updated
  • Completed

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

Any ideas?