Hi
I have a VQL query as follows:
SELECT * FROM bv_getlistdata
WHERE sessionhandle = '123456' and
token = (SELECT requesttoken FROM bv_request)
The view bv_getlistdata has 2 parameters sessionhandle and token and the bv_request view has a single output column 'requesttoken' which represents the input of the token parameter. The value of the sub query returned is: '{12345,23456,34577}'
When I run the query i get an error - it looks like it does not recognize the input for the token parameter:
*Finished with error: No search methods ready to be run. The following fields are obligatory: bvgetlistdata.token
*
However if I run the subquery manually and then input the result directly into the query it works fine:
SELECT * FROM bv_getlistdata
WHERE sessionhandle = '123456' and
token = '{12345,23456,34577}'
I have also tried with different settings on the token attribute (OPT, MAN) but same result
Is there some way of ensuring that the subquery is executed first to ensure that the subquery result is passed correctly to main query?
Thanks in advance