#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!

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 8 years ago

What expression are you using when using process_status? process_status is actually an integer but displayed as text.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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