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
1060 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
#IFM Plug-In Hello, I am using the IFM Plug-In in order to
razvani
over 8 years ago
#IFM Plug-In
Hello,
I am using the IFM Plug-In in order to update a variable in multiple process instances on Appian 7.8.
The update works fine with the UPDATE_PMI query type, but I would like to apply a "WHERE" expression in order to filter the completed instances.
Unfortunately so far I have only managed to write "WHERE" expressions based on the target instance PV's values; are there any other target instance properties available?
According to the IFM documentation "Expressions are run using the Analytics engine, so any expression that can be used in an Appian report is valid here." - but when I use "process_status" in "WHERE" it shows no errors and does not apply the filter (or it returns true every time).
Does anybody now how to use these target instance properties in the "WHERE" expression or can suggest another way to check if a specific instance is completed or not?
Thank you!
OriginalPostID-177163
OriginalPostID-177163
Discussion posts and replies are publicly visible
Parents
0
razvani
over 8 years ago
Hi,
I have tried with
[process_status()=0]
[tostring(process_status())="0"]
[tostring(process_status())="Active"]
[process_status()="Active"]
for both an active and a completed instance as target. The IFM runs in both cases and updates the pv.
The same process runs ok with "WHERE [pv!test="Test"]) condition (it updates if the target instance's pv!test equals "Test" and does not update if the pv!test has other value).
I have also tried to use the process instance properties (pp!id) but I get an error "Expression evaluation error : Variable 'pp!id' not found." - that seems to point to the fact that only process variables can be used in the filter expression.
Thank you!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
razvani
over 8 years ago
Hi,
I have tried with
[process_status()=0]
[tostring(process_status())="0"]
[tostring(process_status())="Active"]
[process_status()="Active"]
for both an active and a completed instance as target. The IFM runs in both cases and updates the pv.
The same process runs ok with "WHERE [pv!test="Test"]) condition (it updates if the target instance's pv!test equals "Test" and does not update if the pv!test has other value).
I have also tried to use the process instance properties (pp!id) but I get an error "Expression evaluation error : Variable 'pp!id' not found." - that seems to point to the fact that only process variables can be used in the filter expression.
Thank you!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data