AGV Max Allocations through code

[sudheer_r]

[ FlexSim 20.1.2 ]

In global table I have control points, Max allocations and Deallocation type, I am trying using this global table how to update this in the model through code.

AGVCP.fsm

[bo_wang · Accepted solution]

agvcp_added script in PF.fsm

[sudheer_r]

@Bob.Wang

Thanks for your code. Could you please give feedback on understanding the code of yours for following questions

I'm trying to understand In Table.query command what is Gt1.ROW_Number. What this does actually.

And if(res.numRows<=0) continue; What is this code for ?

res.cloneTo(Table("GlobalTable2")); why are you cloning to Global Table2?

Object agvnetwork = Model.find("AGVNetwork");
treenode an_cPs= agvnetwork.find(">?controlPoints");
treenode an_daT= agvnetwork.find(">?deallocationTypes");
Table gt1 = Table("GlobalTable1");
for(int i = 1; i <= an_cPs.subnodes.length; i++)
{
    Object cpi_obj = ownerobject(tonode(an_cPs.subnodes.value));
    Table res = Table.query("select *,Gt1.ROW_NUMBER as RN from $1 as Gt1 WHERE [Col 1] = $2 ", gt1, cpi_obj.name);
    if(res.numRows <= 0)
        continue;
    res.cloneTo(Table("GlobalTable2"));
    treenode maxAllocations = cpi_obj.find(">?maxAllocations");
    treenode deallocationTypeRank = cpi_obj.find(">?deallocationTypeRank");
    int gt1Row = res[1]["RN"];
    cpi_obj.find(">?maxAllocations").value = gt1[gt1Row][2].as(string).toNum();
    cpi_obj.find(">?deallocationTypeRank").value = an_daT.subnodes[gt1[gt1Row][3]].rank;
}

[bo_wang]

I'm trying to understand In Table.query command what is Gt1.ROW_Number. What this does actually.

Q1:Get the original row of global table 1

And if(res.numRows<=0) continue; What is this code for ?

Q2：Prevent you from filling in an incorrect CP name

res.cloneTo(Table("GlobalTable2")); why are you cloning to Global Table2?

Q3：It‘s for test，You can comment on the code

[sudheer_r]

@Bob.Wang

You defined gt1 as variable but in Table Query you are using it as Gt1 so got confused. Is both are different or same

Table gt1 = Table("GlobalTable1");

 Table res = Table.query("select *,Gt1.ROW_NUMBER as RN from $1 as Gt1 WHERE [Col 1] = $2 ", gt1, cpi_obj.name);

[bo_wang]

gt1-defined for FlexScript and Gt1 for SQL,you can also use $1，like $1.ROW_NUMBER.

They both quote GlobalTable1.

[sudheer_r]

@Bob.Wang thanks I understood.

In below code why are we using these symbols >? in agvnetwork.find(">?controlPoints);

can't we directly write the code as agvnetwork.find("controlPoints");

does it makes any difference or adding these >? will add any advantage

treenode an_cPs= agvnetwork.find(">?controlPoints");

[bo_wang]

agvnetwork.find("controlPoints) 

is find agvnetwork's child-node that named controlPoints

agvnetwork.find(">?controlPoints")

is find agvnetwork's attribute-node that named controlPoints;

"?" means not limited to the first level.

[sudheer_r]

@Bob.Wang

In AGVNetwork tree I am looking attribute node controlPoints. But it is not available in AGVNetwork.

[joerg_vogel_HsH]

Please open the variables branch as stated in comment

"?" means not limited to the first level.

and please expand the attribute tree of AGVNetwork and not of object Path1.

[sudheer_r]

@Bob.Wang Thanks it helped me. Please convert this into answer

@Jörg Vogel thanks for your feedback. I found