MxLoader

Hi all

Is it possible, is there a way to query date from a table that is NOT associated to an object structure?

Thankyou

Rob

query data* NOT date, thankyou.

I don't think so. In MxLoader, you have to select the Object Structure. The Object structure has a hierarchy of Object Orders. For MXWO, you might see WORKORDER, ROUTES, PM (Routes), PM (Workorder). Each object order (except the first main object) needs a relationship selected so MxLoader know how the data is joined. You can try inserting as an objectname.attributename in MxLoader, but it won't display any data even if it exists. 

This would defeat the security aspect of Object Structures so you don't allow unwanted data to be leaked. And the more practical reason is that the relationship that you want to query that data with is unknown. So, Maximo would not know how the parent object relates to the child object. 

Maximo calls the tabular data objects because they are not always tables, but could be views as well (like you see with wpmaterial)