โ11-10-2020 11:57 AM
Hi,
Iโm trying to put 2 parameters in Where Clause in Oracle Select with โandโ
Below is my pipeline parameters. I put some values between โ โ (I donโt have to put it)
Below is my pipeline and Mapper settings
Below is my Oracle Select settings
I created trigger task, but when I put BEC_NAME and Prodcut_segment with Bearer_token, I donโt see data
I think this is caused by my where clause in the Oracle Select. Can you please help me?
FYI, I was successful to pull only 1 parameter (BEC_NAME)
Thank you
โ11-11-2020 12:36 PM
Hi @yes1819
Now, I see you have two single quotes for $BEC_NAME and $PRODUCT_SEGMENT. If those variables already have single quotes, then you shouldnโt add single quotes in the where clause expression
"BEC_NAME = "+$BEC_NAME+" AND PRODUCT_SEGMENT = "+$PRODUCT_SEGMENT+" "
or try this with the expression toggle (= sign) of the where clause turned off:
BEC_NAME = $BEC_NAME AND PRODUCT_SEGMENT = $PRODUCT_SEGMENT
If you still have issues, then try using the โOracle - Executeโ snap. Give it an input/output View and write your own SELECT statement combined with the variables (dynamic expression - SQL statement)
/Igor