Maximo Open Forum

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

The "object structure" listed below the application can be opened in the Object Structures app. Make a copy and add the related MBOs, and they should appear in the Object List in a tree.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

I thought that might be the case, but our object structure already has the relationships we're looking for.

The "object structure" listed below the application can be opened in the Object Structures app. Make a copy and add the related MBOs, and they should appear in the Object List in a tree.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

Jason,

In Report Administration, does the User's Security Group have access to the "Inventory Details" Report Object Structure?  You might want to check there as well.

I thought that might be the case, but our object structure already has the relationships we're looking for.

The "object structure" listed below the application can be opened in the Object Structures app. Make a copy and add the related MBOs, and they should appear in the Object List in a tree.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

The 1:many tables like INVBALANCES are not supported in result sets. You can get them to display by enabling the webclient.allowMultipleCardinality system property, but it will only ever display 1 row for the main object. More specifically, you could have 10 bins for a part in inventory. You will see data from only 1 bin.

Item is 1:1 but I assume the correct cardinality wasn't set when you added that object to the object structure. In the object structures application, make sure you define it as SINGLE cardinality. Multiple, undefined, or null will be treated as one to many relationships

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

Hello @Steven Shull, I am wanting to test adding PR to this application choice.  Do I need to do the above for that? 

The 1:many tables like INVBALANCES are not supported in result sets. You can get them to display by enabling the webclient.allowMultipleCardinality system property, but it will only ever display 1 row for the main object. More specifically, you could have 10 bins for a part in inventory. You will see data from only 1 bin.

Item is 1:1 but I assume the correct cardinality wasn't set when you added that object to the object structure. In the object structures application, make sure you define it as SINGLE cardinality. Multiple, undefined, or null will be treated as one to many relationships

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.