I am running a simple query where I want to get multiple values from db. s

nitas811 over 9 years ago

I am running a simple query where I want to get multiple values from db.
select x from pushgrouptable where jiraId in ('PPCQV1','PPCQV2')

The query works from sql however from appian I do not get any data. Is there anyway to get this info from table? ...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 9 years ago

That is because instr is a function in MySQL. You need to use the equivalent in SQL Server msdn.microsoft.com/.../ms186323.aspx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

That is because instr is a function in MySQL. You need to use the equivalent in SQL Server msdn.microsoft.com/.../ms186323.aspx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data