We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.
  • State Not Answered
  • Replies 3 replies
  • Subscribers 5 subscribers
  • Views 1894 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Hi All, I am using IFM plug-in to update the CDT type variable which

bharathc
Hi All,

I am using IFM plug-in to update the CDT type variable which is of type nested CDT. please find the attached CDT structure for your reference. since I want to pass query dynamically, My question is how would be the syntax of query when we are updating nested cdt type variables?

Below are the test queries which I am trying,

"UPDATE_PMI 536871922 SET PV test3 = [1,{2,3,{4,5}}]",
"UPDATE_PMI 536871922 SET PV test3 = ["&"""[five=1,test2=[three=2,four=3,test1=[one=4,two=5]]]"""&"]",
"UPDATE_PMI 536871922 SET PV test3 = [[five=1, test2=[three=2, four=3, test1=[one=4, two=5]]]]",
"UPDATE_PMI 536871922 SET PV test3 = [{five=1,{three=2,four=3,{one=4,two=5}}}]",
"UPDATE_PMI 536871922 SET PV test3.test2.test1.one = [5]"

Any suggestions?


OriginalPostID-159439

OriginalPostID-159439

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi James, I have used the query as follows,
    UPDATE_PMI 144 SET PV test = [{five:1,test2: {three:2,four:3,test1: {one:4,two:5}}}]
    It is updating the PV 'test' with null. And, I have also tried with many possible ways to update a nested CDT variable like
    ={"UPDATE_PMI 144 SET PV test.test2.test1.one = [10001234]"}
    ={"UPDATE_PMI 268435724 SET PV test.test2.test1[1].one = [10001234]"}

    ={"UPDATE_PMI 144 SET PV test.rndTest2.rndTest1 = [{id=10001234}]"}
    In all these cases, it's throwing "class java.lang.ArrayIndexOutOfBoundsException" and "Expression evaluation error : Variable '!id' not found." execeptions.

    Is there any possible way to update a variable 'one' in the nested CDT 'test1' in above example? or Can I assume that we can't update a nested CDT PV's using IFM?
Reply
  • 0
    Certified Lead Developer
    Hi James, I have used the query as follows,
    UPDATE_PMI 144 SET PV test = [{five:1,test2: {three:2,four:3,test1: {one:4,two:5}}}]
    It is updating the PV 'test' with null. And, I have also tried with many possible ways to update a nested CDT variable like
    ={"UPDATE_PMI 144 SET PV test.test2.test1.one = [10001234]"}
    ={"UPDATE_PMI 268435724 SET PV test.test2.test1[1].one = [10001234]"}

    ={"UPDATE_PMI 144 SET PV test.rndTest2.rndTest1 = [{id=10001234}]"}
    In all these cases, it's throwing "class java.lang.ArrayIndexOutOfBoundsException" and "Expression evaluation error : Variable '!id' not found." execeptions.

    Is there any possible way to update a variable 'one' in the nested CDT 'test1' in above example? or Can I assume that we can't update a nested CDT PV's using IFM?
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.