This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Wes,
when data volumes allow (for performance issues) you can use a trick
to simulate a distinct both in lookups and tabel domain, this is a
sample lookup where the particular select statement on the table itself
makes the trick, applicable on all mbo with an id and an attribute to
distinguish them:
<table id="PRJ_LISTING" inputmode="readonly" mboname="CUSTREL"
selectmode="single" whereclause=" PARENT='cost_component' and
CHILD='PRJ' and CUSTRELid = (select Max(CUSTRELid) from CUSTREL a where
a.displayvalue = CUSTREL.displayvalue) ">
<tablebody displayrowsperpage="20" filterable="true" filterexpanded="
true" id="ELENCO_PRJ_tablebody">
<tablecol dataattribute="DISPLAYVALUE" id="
PRJ_LISTING_tablebody_col1" label="PRJ" mxevent="selectrecord"
sortable="true" type="link"/>
<tablecol dataattribute="CUSTRELASPRJ.Service_Code" id="
PRJ_LISTING_tablebody_col1a" label="Code" sortable="true" type="link"
/>
<tablecol dataattribute="CUSTRELASPRJ.Service_Code_Description" id="
ELENCO_PRJ_tablebody_col1b" label="Description" sortable="true" type="
link"/>
</tablebody>
</table>
Hope this helps
Massimo Villani
----Messaggio originale----
Da: wwilliams@rocketmail.com
Data: 16/08/2013 15.33
A: "MAXIMO@yahoogroups.com"<MAXIMO@yahoogroups.com>
Ogg: Re: [MAXIMO List] Table domain and lookups.xml
Hi Chris!
Yes, that is what I was hoping to avoid since the report has 3
parameters.
The report uses a view, so how great would that have been to just
have 3 domains using that same view.
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: Chris Lawless <lawlessc@gmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, August 16, 2013 8:26 AM
Subject: Re: [MAXIMO List] Table domain and lookups.xml
Wes, did you consider creating a view of the target data then basing
the table domain on the view?
Chris.
On Aug 16, 2013, at 9:09 AM, "wwilliams.rm" <wwilliams@rocketmail.
com> wrote:
> Has anyone found a way to use group by or even distinct? I need to
restrict my results to unique values. orderby= works well, but odd
results when I use groupby= in the lookups.xml file.
> I tried using group by in the table domain, but that didn't work
either.
> So I am looking at creating 3 separate views for a report I have..
>
> Thanks
> -W
>
>
Invita i tuoi amici e Tiscali ti premia! Il consiglio di un amico vale più di uno spot in TV. Per ogni nuovo abbonato 30 € di premio per te e per lui! Un amico al mese e parli e navighi sempre gratis: http://freelosophy.tiscali.it/