Hi in "Export sql to Excel" smart service i have written the following

sudharanid

A Score Level 3

over 10 years ago

Hi in "Export sql to Excel" smart service i have written the following sql query "="select * from ExpenseDetails where textprojectName=pv!projectName" ". It is throwing me the following error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!projectName' at line 1". When i hardcode the value in where clause of sql query its working fine but using PV or AC throwing error. Please let me know how can i access pv. ...

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 10 years ago

Try something like this:

="select * from ExpenseDetails where textprojectName=" & pv!projectName

or if you need the value to be in single quotes:

="select * from ExpenseDetails where textprojectName='" & pv!projectName & "'"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudharanid
A Score Level 3
over 10 years ago

@Edurado Thanks a lot, its working..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel