Rule for complex table tree in syclo

[neha_mahanty]

Hi All,

I am working on a rule on complex table tree in Service Manager - Reference object.

At present the complex  table tree in the screen is displaying the complete list of ibase.

My requirement is to display only the ibase which is selected along with the Service Order. Since its a complex table tree hence the cascade parent field in not present so do I need to create an update rule for this?

Can anyone please suggest me the approach I should follow in the rule to achieve this functionality.

Thanks

Neha

[bill_froelich · Accepted solution]

Neha,

Try setting the Parent Root to be the iBase you want rather than letting the tree start at the Tree Root (the default).

--Bill

[Former Member · Accepted solution]

There was also an issue before (most likely still is) the mapping of the internal Index numbers of Complex Table Trees can be miss aliened to correct internal complex table index if the complex table has indexes that have a parent.  You can tell if the mapping is wrong if you click in the hyperlink for the index on the field and it goes to the complex table to a different index.

To get around this issue,

1) Remove all indexes from the complex table that have a parent (and remove them from the trash bin).

2) Delete the screen field ct Tree (and remove it from the trash bin)

3) Recreate the field and map it to the indexes

4) Create the indexes that have a parent again.

[neha_mahanty · Accepted solution]

Hi Bill, Stephen

Thank you for guiding .I did the above suggested approach but I could not succeed.

However in the screen I did the following things so far

Complex table : CTIBase

ParentIndex: ParentID

Child index: ID

Return field : ID

In the Parent Root : I removed the --Tree Root -- and did the below changes

1. Created a rule to pick the Service Order - InstallBaseID

2. Created a rule

    complex table

          CTIBase

          Service Order - InstallBaseID

          IBase

          ID

tried the above rule in Parent Root and also in in update rule , none worked

Please suggest what must be the right way to do this.

Thanks

[neha_mahanty · Accepted solution]

Hi Bill,

I have modified the structure of the rule.

Complex Table : CTIBase

Parent Index : IBase

Child Index : ID

Parent Root : Rule

                      ComplexTable

                                 CTIBase

                                 SOInstalled Ibase

                                  IBase

                                  IBase

Display Field : Auto

Return Field : ID

This did not gave me any result

However I tried the same in Complex Table drop down and its giving me the correct result and I am getting only those values whose parent is IBase.

Complex Table : CTIBase

Table Index : ID FromIBase

Cascade parent  : Rule

                                ComplexTable

                                 CTIBase

                                 SOInstalled Ibase

                                  IBase

                                  IBase

Display Field : Auto

Return Field : ID

Please let me know how should I structure the complex table tree to get the desired result.

Thanks

Neha

[Former Member · Accepted solution]

First the data need something like:

Child index    | Parent root

Node 1             

Node 2               Node 1

Node 3               Node 2

Node 4               Node 1

Node 5               Node 4

This will make a tree that looks like:

Node 1

- Node 2

- - Node 3

- Node 4

- - Node 5

The value in the Parent root index needs to make a value in the child index column so the tree knows where to put the row.

[neha_mahanty · Accepted solution]

Hi Stephen,

The tree is appearing in the same way. I tried the same cascade in complex table drop down and complex table list , It works fine.

The similar does not work in complex table tree.

It would be nice if you can share any rule or structure to achieve this functionality.

Thanks

Neha