Does Endevor LIST Element support using 'and' condition
search cancel

Does Endevor LIST Element support using 'and' condition

book

Article ID: 97167

calendar_today

Updated On:

Products

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

Issue/Introduction

I can search for 'MQSeries MVS COBOL Wrappers' in Endevor but I need to search by using "And: condition...
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: )

Can I do this?

Environment

Release:
Component: ENDBAS

Cause

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

Resolution

The error is caused by the WHERE clause had 1 too many close parens ')'

Need to add an open paren like this --
WHERE TEXT ((EQ 'MQSERIES' COLUMN 1 72) AND
            (EQ 'WRAPPER' COLUMN 1 72))

Or remove extra close parens.
WHERE TEXT (EQ 'MQSERIES' COLUMN 1 72  AND EQ 'WRAPPER' COLUMN 1 72)

Need to make the number of open and close parens equal.