Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
5 subscribers
Views
2072 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
IFM Manager Query Structure ---------------------------------------- H
Simon
over 9 years ago
IFM Manager Query Structure
----------------------------------------
Hello,
I'm having difficulty using IFM Manager to modify a process variable, below is a test query I'm trying to run
"="UPDATE 278 SET PV areaCode_text = pv!newArea WHERE pv!areaCode_text = pv!oldArea", but this fails and the log reports:
"com.appiancorp.custom.ifmm.parser.IFMQueryParserException: UPDATE 278 SET PV areaCode_text = pv!newArea WHERE pv!areaCode_text = pv!oldArea: Failed to parse required IFM Action after index 14"
Even if I try a much simpler query such as amending a process variable to a constant without a WHERE clause (once I've managed to get it pass the expression editor and been able to publish), it still fails with the same log error.
Any idea what I'm doing wrong / does anyone have an example of a query that works for them?
OriginalPostID-150659
OriginalPostID-150659
Discussion posts and replies are publicly visible
Parents
0
rodgraham
Certified Lead Developer
over 9 years ago
If you switch logging on the ifm node you can see the query being executed. This might point you to the problem. Also there is an ifm application you can down load that has many examples.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
rodgraham
Certified Lead Developer
over 9 years ago
If you switch logging on the ifm node you can see the query being executed. This might point you to the problem. Also there is an ifm application you can down load that has many examples.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data