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
Parents
0
lincolnf454
over 9 years ago
Hi Eduardo
Apologies for bothering you once more. I'm trying to do the exact same thing with cdts. Using the variables in our previous case as cdt's, my syntax looks something like this (as per the documentation provided) -
="UPDATE 4623 SET PV cdtTextOld = [""" & externalize(internalize(pv!cdtTextNew))& """]"
Now I get an appian error stating the following - Expression evaluation error at function 'internalize': Cannot internalize data: Expression evaluation error : Cannot internalize type TEXTTYPE
Any help would be greatly appreciated
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
lincolnf454
over 9 years ago
Hi Eduardo
Apologies for bothering you once more. I'm trying to do the exact same thing with cdts. Using the variables in our previous case as cdt's, my syntax looks something like this (as per the documentation provided) -
="UPDATE 4623 SET PV cdtTextOld = [""" & externalize(internalize(pv!cdtTextNew))& """]"
Now I get an appian error stating the following - Expression evaluation error at function 'internalize': Cannot internalize data: Expression evaluation error : Cannot internalize type TEXTTYPE
Any help would be greatly appreciated
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data