0

I have a requirement where I want to hide a duplicate value from the domain(lookup of the field). For Example there is a synonym domain called status with 2 same values as Active, I want hide one of them to avoid confusion. How do I achieve this?

preethi
  • 1

2 Answers2

0

You may refer to this technote from IBM: https://www.ibm.com/support/pages/node/229865

James
  • 55
  • 1
  • 9
  • Hello, Thanks for the recommendation. I did tried it before but it didn't give expected result. Could you please suggest any other way – preethi Jul 26 '21 at 18:33
0

You can make a lookup like this:

<table id=mylookup mboname="SYNONYMDOMAIN" 
       inputmode="readonly" selectmode="single"
       whereclause="domainid='MYDOMAIN' and SYNONYMDOMAINID in (select max(synonymdomainid) from maximo.synonymdomain where domainid='MYDOMAIN' group by maxvalue)">
...
</table>
John C
  • 4,276
  • 2
  • 17
  • 28