Forum Discussion
raiqee
Occasional Contributor
Here's the query
Select ${#Project#GP_DBName_1}.MARKETS.ID From ${#Project#GP_DBName_1}.MARKETS where ${#Project#GP_DBName_1}.MARKETS.EVENTID = ${#TestCase#eventId} And (RTRIM(UPPER(${#Project#GP_DBName_1}.MARKETS.DESCRIPTION)) = RTRIM(UPPER('${#TestCase#marketType}')) OR ${#Project#GP_DBName_1}.MARKETS.MARKETTYPEID = ${#TestCase#marketTypeId})
Already tried the solution provided by Nastya but we still encountering the error
nmrao
7 years agoChampion Level 3
Please see if the below helps:
def queryTemplate = """Select ${#Project#GP_DBName_1}.MARKETS.ID From ${#Project#GP_DBName_1}.MARKETS where ${#Project#GP_DBName_1}.MARKETS.EVENTID = ${#TestCase#eventId} And (RTRIM(UPPER(${#Project#GP_DBName_1}.MARKETS.DESCRIPTION)) = RTRIM(UPPER(\'${#TestCase#marketType}\')) OR ${#Project#GP_DBName_1}.MARKETS.MARKETTYPEID = ${#TestCase#marketTypeId})""" def query = context.expand(queryTemplate) log.info "Final query is :\n $query" //Now pass the above "query" object to sql to execute
- raiqee7 years agoOccasional Contributor
Hi Rao,
We tried the solution you provided but we encountered a new error, tried running it on soapui
Thu May 04 15:45:21 CST 2017:ERROR:An error occurred [ORA-00942: table or view does not exist
], see error log for details- nmrao7 years agoChampion Level 3From log statement you can validate if the query is correct or not. Isn't it? Have you looked at it?
Related Content
- 6 years agodrwohlers
- 3 years agoFederated_Mutua