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:

Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.