Topic
  • 3 replies
  • Latest Post - ‏2010-03-22T17:42:37Z by SystemAdmin
burtondav
burtondav
2 Posts

Pinned topic How do I find table and field names?

‏2010-03-16T20:55:30Z |
Sorry for the newbie question.

How do I find the Maximo table and field names.
I'm creating a BIRT report.

Thanks
Updated on 2010-03-22T17:42:37Z at 2010-03-22T17:42:37Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5842 Posts

    Re: How do I find table and field names?

    ‏2010-03-17T05:29:21Z  
    Hi,

    You can find the information of Table and Column of a particular field by placing your cursor in the field and then use Alt+F1.

    This action will display field's help, which also incluse your required info.

    Tell me if you need any more help...

    Regards,
    Farhan
  • mhzubair
    mhzubair
    4 Posts

    Re: How do I find table and field names?

    ‏2010-03-22T08:35:04Z  
    Hi,

    You can find the information of Table and Column of a particular field by placing your cursor in the field and then use Alt+F1.

    This action will display field's help, which also incluse your required info.

    Tell me if you need any more help...

    Regards,
    Farhan
    On Some fields the Alt+F1 will not work, if it is a non-persistent field. In such cases if you want to know the field name press Alt+i.
  • SystemAdmin
    SystemAdmin
    5842 Posts

    Re: How do I find table and field names?

    ‏2010-03-22T17:42:37Z  
    • mhzubair
    • ‏2010-03-22T08:35:04Z
    On Some fields the Alt+F1 will not work, if it is a non-persistent field. In such cases if you want to know the field name press Alt+i.
    Hi,

    Another way to find table and field names is to use the Database Configuration feature in Maximo. In Maximo V7.1 you would navigate to:
    Go To-->System Configuration-->Platform Configuration-->Database Configuration

    Enter the "Object" (database table) of interest and view the Attributes. There is also a report that can be run to give a listing of table and field names.

    Regards,
    Norma