Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Show top 10 query
May 20, 2016
3:42 am
Avatar
Dave4444
Member
Members
Forum Posts: 11
Member Since:
October 20, 2014
sp_UserOfflineSmall Offline

Hi all,

I’m trying to build a query in the wotrack application to display the top 10 locations with the most work orders assigned to that location. Can this be achieved? Any guidance would be appreaciated.

Thanks

May 20, 2016
10:43 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

May 23, 2016
10:06 pm
Avatar
pmorrow8
Member
Members
Forum Posts: 17
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

location in
(select location from
(select location, count(location)  from workorder
group by location
order by count(location) desc)
where rownum < 11)
/

June 10, 2016
4:11 pm
Avatar
shayalynn
Member
Members
Forum Posts: 6
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I am trying to accomplish something similar in returning a result set (and creating a report) of the top 20 costliest assets per GLACCOUNT by YTDCOST.  Any assitance is greatly appreciated.

July 31, 2017
5:49 am
Avatar
Lena01
Member
Members
Forum Posts: 3
Member Since:
July 31, 2017
sp_UserOfflineSmall Offline

hey guys ,, thanks for your posts .. i need help , connected to the maximo .. who can help me ? Surprised

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

cgregory: 45

Maximofresher: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14366

Moderators: 0

Admins: 4

Forum Stats:

Groups: 1

Forums: 8

Topics: 1580

Posts: 4295

Newest Members:

Megan Morgan, Devendra Verma, stephen stephens, maxexpertise Hilal, Jeroen van Proosdij, Neeraja N

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0, bpaik: 0