Maximo Open Forum

 View Only

 How to setup a table domain for an asset spec?

  • Assets
Benoit Jacques's profile image
Benoit Jacques posted 05-08-2024 11:25

Hello all,

I'm trying to setup a table domain to use with an asset spec for the first time. So far, I get an empty list when I click on the lookup icon in the alnvalue column. Can anyone help?

Here waht I did:

  • Created a new table domain. I left the Validation and List where clause empty for testing so I could get avalue in the lookup list.
  • Created the new attribute in CLASSSPEC (see image below)
  • Modified LOOKUP.XML to add the new lookup. (see below)

</table>
        <table id="GLCOMPONENTS" inputmode="readonly" selectmode="single">
        <tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="GLCOMPONENTS_tablebody">
            <tablecol dataattribute="compvalue" id="GLCOMPONENTS_tablebody_col_1" mxevent="selectrecord" mxevent_desc="Aller à %1" sortable="true" type="link"/>
            <tablecol dataattribute="comptext" id="GLCOMPONENTS_tablebody_col_2" mxevent="selectrecord" mxevent_desc="Aller à %1" sortable="true" type="link"/>
        </tablebody>
    </table>

Updates:

@Stevie Holloway: thx for your answer. 

@Brad Delong: One of our GL Account component contain the list of administrative codes of all our faculties. Seeing that this list is automaticlly updated, I want to use it as a value list for an asset spec. I'm able to achieve that using scripting outside Maximo, but I want to try to use a more "built-in" way.   

Stevie Holloway's profile image
Stevie Holloway

Hi,

I hope I'm not misunderstanding your question but it seems like you're trying to create a table domain but attempting to access the data in the ALN Value column. This will not work. If you're trying to access the ALN Value column, you must create an ALN domain, not a Table domain.

Please let me know if I've misunderstood your question.

Brad Delong's profile image
Brad Delong

GLComponents is a special table with the parts for your GL Account.  We would need to know more about what you are trying to do and some examples of your data and what you might be expecting.