Topic
3 replies Latest Post - ‏2013-10-28T09:37:33Z by sac1987
jn-taic
jn-taic
4 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: Return a distinct value from Table Domain

    ‏2010-04-14T02:14:13Z  in response to jn-taic
    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
    ACCEPTED ANSWER

    Re: Return a distinct value from Table Domain

    ‏2011-01-04T08:10:18Z  in response to jn-taic
    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
    ACCEPTED ANSWER

    Re: Return a distinct value from Table Domain

    ‏2013-10-28T09:37:33Z  in response to jn-taic

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

    Thanks