Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Create multiple db config objects for a single db view entity

    Posted 10/06/21 08:00 PM
    MAM 7.6.1.2:

    I want to create multiple db config objects for a single db view entity.

    How can I do this?

    Thanks.
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Create multiple db config objects for a single db view entity

    Posted 10/07/21 02:28 AM
    Hi User1971,

    This question is a little confusing.  So here's what I think you're asking.

    1. You need to create a single view from multiple tables

    in order to do that:

    2. I need to create multiple objects first to contain the data I need.

    So, you can easily create ,multiple persistent objects in Maximo as these will then create the tables. Then I would advise creating the view using the DB SQL query tools, once satisfied, create the view as an object in Maxmo.  The best way to do that is to create the object using the same name as the view.  Maximo will then import the view and construct the object.

    Craig.

    ------------------------------
    ===============================
    Craig Kokay,
    Lead Senior Maximo/IoT Consultant
    ISW
    Sydney, NSW, Australia
    Ph: 0411-682-040
    =================================
    #IBMChampion2021
    ------------------------------