IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2013-10-28T09:37:33Z by sac1987
jn-taic
jn-taic
4 Posts

Pinned topic Return a distinct value from Table Domain

‏2010-04-13T12:48:00Z |
Hi,

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.
Updated on 2011-01-04T08:10:18Z at 2011-01-04T08:10:18Z by Bunty28
  • badrimax
    badrimax
    7 Posts

    Re: Return a distinct value from Table Domain

    ‏2010-04-14T02:14:13Z  
    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

    Regards
    Badri
  • Bunty28
    Bunty28
    9 Posts

    Re: Return a distinct value from Table Domain

    ‏2011-01-04T08:10:18Z  
    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..
  • sac1987
    sac1987
    8 Posts

    Re: Return a distinct value from Table Domain

    ‏2013-10-28T09:37:33Z  

    I am also getting the same issue. Please suggest any solution.

    Thanks