I've done something along those lines relating to CTIs, and groups, all with a direct SQL menu.
The CTIs menu lists the CTIs in the users current call stack (ie. they could have hundreds of tickets outstanding, but want to list those relating to Order entry, invoicing, purchasing, etc).
select distinct
Case_Category___Type___Item
from
hpd_helpdesk
where
Assigned_To_Group_ = '$536871136$'
and
Status < 4
order by
1
Case_Category___Type___Item
from
hpd_helpdesk
where
Assigned_To_Group_ = '$536871136$'
and
Status < 4
order by
1
Which seems to work quite well for us. The menu is also dynamically changed between two versions (the one above is used for other custom views I've setup).
Regards
Dave
On 20/04/06, Dwayne Martin <[EMAIL PROTECTED]> wrote:
Hi Everyone!
How can I create a menu that will select users from the User
form who belong to a particular permission group?
Excuse me if this question has already been asked, but the
ARSList archive web page seems to be unavailable just now.
(ARS 6.3, HPUX-11 server, Oracle 9.2 db)
Dwayne Martin
Computing Support
James Madison University
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
