Need help creating Virtual Join table on array field
I need help or if there is an example of this that someone can point me to.
In Change Module there is an array field Affected CIs (assets) that links to logical.name. I need to create a Virtual Join that also brings other related values in a table format like Subtype, Status etc.
I created a VJ and placed the fields in the link cm3r line assets, but it only puts data in the first line of the VJ table, I guess because of arrays involved.
I am also getting this error "unable to convert key to datum in searchCondition() (display,show.rio)"
Can someone please guide me on the best approach to get this done. The use of popup has been rejected by customer.
As you asked, the solution in the other case should work fine on this also. Just change the fields that are linked from device.
I looked but cant get the right approach. Can you help me write the code for lets say subtype field, where the assets entry will add a subtype and if removed then will remove that subtype also