I have a table domain in Maximo 7 which I only want to return a distinct value. The LISTWHERECLAUSE only allows for the where clause of the select statement. Is it possible to get the domain to return a distinct value? Any examples greatly appreciated. Thanks.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic Return a distinct value from Table Domain
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-01-04T08:10:18Z at 2011-01-04T08:10:18Z by Bunty28
badrimax 270001R4547 Posts
Re: Return a distinct value from Table Domain2010-04-14T02:14:13ZThis is the accepted answer. This is the accepted answer.Hi,
Add condition to your where clause like mentioned below
I have taken ALNDOMAIN example
alndomainid = (select max(alndomainid) from alndomain a where a.domainid = alndomain.domainid)
ALNDOMAINID is the uniqueid in the table
let me know if it works
Bunty28 270003KYBQ9 Posts
Re: Return a distinct value from Table Domain2011-01-04T08:10:18ZThis is the accepted answer. This is the accepted answer.I am also getting the same issue. I want Distinct Values in valuelist.
did you get the solution....Please let me if possible.
Thanks in advance..