"No valid criteria specified for procedure parameter" error when using OR in the MetaMatrix query criteria
Issue
-
When I query my Virtual Procedure using an OR in the WHERE clause:
select partition_name from PartionMap where partition_name = 'TEST' and item_id = 'TEST' OR partition_name = 'TEST2'
- I receive the following error:
Error: No valid criteria specified for procedure parameter PartitionMap.PartitionName
Environment
- MetaMatrix Enterprise Server 5.5.x
- MetaMatrix Virtual Procedure with 2 input parameters
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.