Bypass or Override vvIn_virtual

[gwilburn]

Just curious if there is a way to bypass or omit the vvIn_virtual() portion of a data source... I noticed the "vvIn_virtual Overrides" option but that appears to only work with true/false values. I'm looking to override it completely.

[robert.swanson]

Not really. But you can wrap your vvIn_Virtual inside a clause that effectively ignores it when necessary.

For example:
select x, y, z
from myFile
where ( q = vvIn_virtual('filterQ',' ','char',10)
or vvIn_virtual('ignoreVirtual','false','char',5) = 'true' )

So in this case, setting app variable ignoreVirtual to 'true' would cause the accompanying vvIn_virtual clause to be ignored.