Overview:

A user is running a Vault Query Language (VQL) statement to pull a list of workflows containing a particular document.  It returns an error: Invalid filter operator: "CONTAINS".

Query:  SELECT workflow_status__v,workflow_name__v,workflow_document_id__v,workflow_id__v,workflow_document_major_version_number__v,workflow_document_minor_version_number__v FROM workflows WHERE workflow_status__v = 'Active' and workflow_document_id__v CONTAINS ('12345','23456') 

Error:

Root Cause:

The workflow object does not support the CONTAINS operator.

Solution: