I have a LawsnQuery node to query Lawson table POVAGRMTHD. The problem is that there are many contract names with &s in them. When querying any of these, it returns nothing. I understand how it's confusing the query, so I've tried placing quotes, both single and double around the value but it doesn't work. Does anyone know how I can query these? Thanks.
Example below:
VEN-AGRMT-REF=S&N EFLEX ABLATION
Activity name:LwsnQuery4850 id:1 started @ 08/29/2023 11:43:50.515 AM
S3 Query LwsnQuery4850: Executing S3 query: PROD=LSAPPS&FILE=POVAGRMTHD&INDEX=PVHSET1&KEY=CHS&FIELD=EFFECTIVE-DT;EXPIRE-DT;VEN-AGRMT-REF;PROCURE-GROUP&SELECT=VEN-AGRMT-REF=S&N%20EFLEX%20ABLATION&OUT=CSV&DELIM=~
LwsnQuery4850_errorCode = 0
LwsnQuery4850_informationCode = 0
LwsnQuery4850_returnMessage = S3 Query LwsnQuery4850: No of records returned 0
LwsnQuery4850_outputData =
LwsnQuery4850_currentPage = 1
LwsnQuery4850_complete = true
LwsnQuery4850_recordCount = 0
LwsnQuery4850_hasNext = false
Activity name:LwsnQuery4850 id:1 completed @ 08/29/2023 11:43:50.536 AM
LwsnQuery4850_RECORD_COUNT = 0
Activity name:LwsnQuery4850 id:1 completed @ 08/29/2023 11:43:50.536 AM
Activity name:LwsnQuery4850 id:1 started @ 08/29/2023 11:46:51.872 AM
S3 Query LwsnQuery4850: Executing S3 query: PROD=LSAPPS&FILE=POVAGRMTHD&INDEX=PVHSET1&KEY=CHS=S&N%20EFLEX%20ABLATION&FIELD=EFFECTIVE-DT;EXPIRE-DT;VEN-AGRMT-REF;PROCURE-GROUP&OUT=CSV&DELIM=~
LwsnQuery4850_errorCode = 0
LwsnQuery4850_informationCode = 0
LwsnQuery4850_returnMessage = S3 Query LwsnQuery4850: No of records returned 0
LwsnQuery4850_outputData =
LwsnQuery4850_currentPage = 1
LwsnQuery4850_complete = true
LwsnQuery4850_recordCount = 0
LwsnQuery4850_hasNext = false
Activity name:LwsnQuery4850 id:1 completed @ 08/29/2023 11:46:51.909 AM
LwsnQuery4850_RECORD_COUNT = 0
