Hi, I am running a SQL query in my process but its not working. I am

nitas811 over 11 years ago

Hi,

I am running a SQL query in my process but its not working. I am doing a simple query, select <columnnames> from tablename where fieldname = "", however its even returning records that do not have the column set to blank. In mysql the same query is working. Seems like a bug in appian what is the workaround for this? ...

Discussion posts and replies are publicly visible

0 larson.thune
Appian Employee
over 11 years ago

If you are doing a simple select statement, why not just use a query rule?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nitas811 over 11 years ago

I need to parse the data and store in CDT hence am using the SQL service
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 akhilan over 11 years ago

I tested out a similar query on Appian 7.1 which uses MySQL as the DB from a Query DB node and it worked perfectly fine. The column I used in my where clause was a varchar field in the DB. What type of field are you checking for?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel