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
14 replies
Subscribers
8 subscribers
Views
3976 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi Forum I am trying to use the IFM plug in, and it is unfortunately
lincolnf454
over 9 years ago
Hi Forum
I am trying to use the IFM plug in, and it is unfortunately not working for me
Please see the example below. I have a variable vTextOld in the destination process (this is the variable to be changed). This variable will be replaced by vTextNew in the process I am running with the IFM smart service.
="UPDATE 4623 SET PV vTextOld = [pv!vTextNew]"
Is my syntax incorrect here? I tried to make the input as simple as possible but I would also like to use a where clause, how would I add a where clause to an example like this?
I have also tried to use the query generator provided in the example application, also to no effect. If someone could give me an example of the parameters required for that expression rule, that would be of great help. Can that expression rule even be reused in my application?
OriginalPostID-151314
OriginalPostID-151314
Discussion posts and replies are publicly visible
0
Eduardo Fuentes
Appian Employee
over 9 years ago
I suggest you use the "Get and Set External Process Variables" plug-in for updating variables
forum.appian.com/.../summary
it's easier to use since it doesn't require any knowledge about any specific syntax. In that link you'll also find the documentation of the plug-in at the bottom of the page.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lincolnf454
over 9 years ago
Hi Eduardo
Unfortunately I don't think that plug in will work for my case, since the process ID's will not be known. I need a component similar to the IFM manager to query and change all process instances based on a where clause.
I don't understand where I'm going wrong here - I'm following the documentation pertaining to the syntax provided.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lincolnf454
over 9 years ago
After some extensive testing, I have been able to use the IFM manager to update single cdt values successfully, like so
="UPDATE 4623 SET PV cdtTextOld.id = [" & pv!cdtTextNew.id & ""]"
Unfortunately I am still unable to update the entire CDT since I always receive the following error "Expression evaluation error : Cannot internalize type TEXTTYPE
" when using the externalize(internalize(cdt)) syntax.
Is this syntax provided in the documentation correct? Has anyone else had success when updating entire cdts through the IFM manager?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
What about simply using a non-CDT variable of the same type as the ID field. For example if ID is of type "Text" then create a variable of that type and run
="UPDATE 4623 SET PV cdtTextOld.id = [" & pv!newIdOfTypeText & ""]"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<