...........thanks Conny - works a treat !



________________________________
From: Conny Martin <conny.mar...@t-systems.com>
To: arslist@ARSLIST.ORG
Sent: Monday, 31 August, 2009 11:19:38
Subject: AW: Menu problem....Group List id issue ?

** 
Sean,
 
you can make use of a SQL-Menu with the following statement
 
SELECT login_name FROM user_x WHERE
group_list LIKE (SELECT group_id FROM group_x WHERE group_name = 
'$536870925$')||';%' OR
group_list LIKE '%; '||(SELECT group_id FROM group_x WHERE group_name = 
'$536870925$')||';%' OR
group_list LIKE '%;'||(SELECT group_id FROM group_x WHERE group_name = 
'$536870925$')||';%'

HTH
 
Kind Regards Conny


________________________________
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Sean Harrodine
Gesendet: Montag, 31. August 2009 12:09
An: arslist@ARSLIST.ORG
Betreff: Re: Menu problem....Group List id issue ?

** 
Hi Frank,

To your knowledge, is there no way around it other than storing the id and 
having to use that ?

Sean




________________________________
From: Frank Caruso <caruso.fr...@gmail.com>
To: arslist@ARSLIST.ORG
Sent: Monday, 31 August, 2009 10:48:48
Subject: Re: Menu problem....Group List id issue ?

Store the GROUPID value (number) in a temp field when the user selects
the assigned group. Then use the temp value in your menu.


On Mon, Aug 31, 2009 at 12:43 PM, Sean Harrodine<sean_rem...@yahoo.co.uk> wrote:
> **
> Hi everyone,
>
> Can anyone help me with the following menu / query issue please on a bespoke
> app.....
>
>
> I have a field name on a form called AssignedToGroup (id = 536870925). An
> example of its contents would be "TECH_PLAN"
>
> On the same form i have a field called Assignee (id = 536870926)
>
> The group TECH_PLAN exists in the group form and there are 3 users in the
> User form that have TECH_PLAN in their Group List
>
>
> I have created and attached a menu to the Assignee field, with the following
> query against the User form........
>
>  'Group List' LIKE ( "%"  + ($536870925$ +  "%" ))
>
> .....in the hope that the menu will display a list of the users with
> TECH_PLAN in their group list but it doesn't
>
>
> I suspect this is something to do with that the User form actually stores
> the ID for the Group in the User Form..
>
> Is there anyway of being able to present a menu based on using the actual
> Group Name, rather than the group ID ?
>
>
> TIA
>
> Sean
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_




_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Reply via email to