Using views for table domain and custom lookup
Sivspp 270000GJJV Visits (9685)
You may need to use a custom view for a special requirement and setup a lookup for the field.
Create a View for an Example I have created a custom view PERSON_MAINT
Create a database view with the following definition
Create or replace view person_maint as select personid RISK_OWNER, displayname name, 'PERSON' owner_type from person where status = 'ACTIVE' union select value RISK_OWNER, description name, 'PERSON_MAINT' owner_type From synonymdomain where domainid = 'PERSON_MAINT' order by owner_type ;
Create a custom object/view in Maximo with the same name, and Maximo will import the database view
status = 'ACTIVE' union select value RISK_OWNER, description name, 'PERSON_MAINT ' owner_type From synonymdomain where domainid = 'PERSON_MAINT ' order by owner_type
select personid RISK_OWNER, displayname name, 'PERSON' owner_type
Create a Table Domainon PERSON_MAINT Object PERSON_MAINT
Add a new entry to LOOKUPNAMES ALNDomain
Go to Classification
Add Use With Object SR
Add the attribute
Go to Application Designer
Import the lookups.xml
Edit the file to include the below
<table id="PERSON_MAINT" inpu
Save and Import lookups.xml
1. Go to SR create a new SR
2. Click Specifications Tab
3. For the field Classification Go to Classifications and select OIL return with value
4. Under attribute table expand the RISKOWNE attribute select detail menu for Table Value field.
The filter is NOT available in the lookup list. The reason is the attribute should have a search type. Even though the lookups.xml file set to f
In order to have a search type perform the followings.
update maxattribute set sear
After the successful update stop the server and restart the application server.
Now perform the steps as above mentioned the lookup will have the field filterable.