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?

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