Welcome to WebmasterWorld Guest from 54.167.86.211

Forum Moderators: open

Message Too Old, No Replies

Help getting one return from multiple rows

     
1:10 pm on Jul 30, 2010 (gmt 0)

New User

5+ Year Member

joined:Apr 25, 2008
posts: 13
votes: 0


I'm trying to get one row returned for a display of a public phone extension and I'm just not seeing something clearly. I want to check directly in my query that if someone has multiple extensions to only get one based on rules:

A person can have up to 3 types

7000 range is for voicemail
3000 range is for direct
5000 is a boss group (rings multiple phones, ie secretary)

A few administrators that have been promoted through the years started with just voicemail, then got a direct extension, then got a boss group, so I have a "worse case" with them that could look like this:

Name|Ext
------|-------
User | 7140
User | 5620
User | 3259

The rules follow:

If someone has a 5000 range, get that one as 'Public Extension' else If they have a 3000, get that one as 'Public Extension' else get 7000 as 'Public Extension'. Is this possible to do directly in the query?
3:38 pm on July 30, 2010 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5550
votes: 24


If they have all 3 (or 2 of the 3), which one has priority?
4:16 pm on July 30, 2010 (gmt 0)

New User

5+ Year Member

joined:Apr 25, 2008
posts: 13
votes: 0


The 5000 range number