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

bharathc over 9 years ago

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?

Discussion posts and replies are publicly visible

Parents

0 Vinod Bongoni
Certified Lead Developer
over 9 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Vinod Bongoni
Certified Lead Developer
over 9 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data