Does Endevor LIST ELEMENT WHERE TEXT support using 'AND' condition

Products

• Endevor
• Endevor Natural Integration
• Endevor - ECLIPSE Plugin
• Endevor - Enterprise Workbench

Issue/Introduction

Searching for 'MQSeries MVS COBOL Wrappers' in Endevor using AND condition is erring with E004 INVALID COMMAND

LIST ELEMENT * 
FROM ENVIRONMENT 'PROD' 
SYSTEM * 
SUBSYSTEM * 
TYPE 'COBOLMVS' 
STAGE 2 
OPTIONS SHOWING TEXT NOSEARCH 
WHERE TEXT ((EQ 'MQSeries' COLUMN 1 72) AND EQ 'Wrapper' COLUMN 1 72)) 
BUILD ACTION &&ACTION 
. 
BSTPPARS: E004 INVALID COMMAND WORDING, FOUND: )

 

Environment

Release:
Component: ENDBAS

Resolution

The number of open parentheses did not match the number of close parentheses.

To correct the syntax:

Add an additional parenthesis

WHERE TEXT ((EQ 'MQSeries' COLUMN 1 72) AND
            (EQ 'Wrapper' COLUMN 1 72))

or remove all the extra parentheses

WHERE TEXT (EQ 'MQSeries' COLUMN 1 72 AND EQ 'Wrapper' COLUMN 1 72)

 

How does this LIST ELEMENT * WHERE TEXT work?

WHERE TEXT limits the generated list to ELEMENTS that contain (or do not contain) one or more specified character text strings.

Meaning the command would return all ELEMENTS WHERE

1)  At least one line in the ELEMENT contains MQSeries between columns 1 and 72

2)  AND, also in this ELEMENT, at least one line contains Wrapper between columns 1 and 72