Maximo Open Forum

 View Only

 Creating a Custom Lookup Field and Link it with Custom ALN Domain

  • Customizations
Anna Max's profile image
Anna Max posted 09-19-2024 03:47

Hello,

I wanted to create a custom lookup field in Work Order Tracking application. For this reason I created an ALN type Domain and added the desired values.
I went to DB configuration and linked one attribute to that newly created domain then I created a new filed in work order tracking application for that attribute.

I filled out the new field with a lookup vale and saved the work order but when I run the report, it doesn't showing the any data in that column.

Appreciate if you help me with this.

Thanks!

#domain #lookup #customfield

Steven Shull's profile image
Steven Shull

What you've described at a high-level is the proper steps. You mentioned the report isn't showing a value for the column. Do you have database level access to confirm whether it exists at the database level? What I'm looking to do is narrow down if the issue is the report or the field.

If it doesn't exist in the database, then I would check how you've defined the attribute in Application Designer. There's an input method of Query which I've seen people accidentally set which will cause the value to not get stored. Input mode of Query is a feature to indicate it's used for search purposes like the Advanced Search. 

If it exists in the database, then the report would need to be evaluated. I'm not sure if this is a QBR (Query Based Report) that was created in Maximo or some other report. We'd need more details to troubleshoot the report.