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.
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
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
>
>
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
>
>
I've only been able to accomplish this with views, as you said you did.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
Of wwilliams.rm
Sent: Friday, August 16, 2013 9:10 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Table domain and lookups.xml
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
What DB version? Have you looked at using CTE's (common table expressions ) to provide the grouping and potentially the ordering.
R/
Will
On Aug 16, 2013, at 8:10, "wwilliams.rm" <wwilliams@rocketmail.com<mailto: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
Wes, is this for reporting or UI? For reporting, I usually do all that in the report. If you want different results based on parameters, and I'm are not using a scripted dataset, I do it in the beforeOpen of the dataset.
if (params["xyz"].value == "<value>")
{ this.queryText=this.queryText+ " AND stuff = 'somestuff'";}
else { this.queryText=this.queryText+ " AND stuff = 'otherstuff'";}
You can also group based on parameter selection. Michael Williams (related?) has a good example here:
http://www.eclipse.org/forums/index.php/t/452359/
Brian
Thanks Brian, this is so the Maximo user has look-ups, So for the UI with scripted datasets and it is a process.
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: bgbaird <brian.baird@northstarbluescope.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, August 22, 2013 1:04 PM
Subject: Re: [MAXIMO List] Table domain and lookups.xml
Wes, is this for reporting or UI? For reporting, I usually do all that in the report. If you want different results based on parameters, and I'm are not using a scripted dataset, I do it in the beforeOpen of the dataset.
if (params["xyz"].value == "<value>")
{ this.queryText=this.queryText+ " AND stuff = 'somestuff'";}
else { this.queryText=this.queryText+ " AND stuff = 'otherstuff'";}
You can also group based on parameter selection. Michael Williams (related?) has a good example here:
http://www.eclipse.org/forums/index.php/t/452359/
Brian