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
1894 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
mahipalc
over 9 years ago
Hi simons,
The problem lies in your test query construction.
1) Square brackets are missing in 'IFM Action' part of the query.
2) Square brackets are missing in 'WHERE' clause part of the query.
THe correct query should be:
UPDATE 278 PV areaCode_text = [pv!newArea] WHERE [pv!areaCode_text = pv!oldArea]
If you observe, the IFM manager documentation(IFM query syntax), " [ ] "are compulsory else throws IFMQueryParserException.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mahipalc
over 9 years ago
Hi simons,
The problem lies in your test query construction.
1) Square brackets are missing in 'IFM Action' part of the query.
2) Square brackets are missing in 'WHERE' clause part of the query.
THe correct query should be:
UPDATE 278 PV areaCode_text = [pv!newArea] WHERE [pv!areaCode_text = pv!oldArea]
If you observe, the IFM manager documentation(IFM query syntax), " [ ] "are compulsory else throws IFMQueryParserException.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data