AnsweredAssumed Answered

How to use a field on a layout in a query

Question asked by MorkAfur on Dec 18, 2012
Latest reply on Dec 19, 2012 by MorkAfur

Title

How to use a field on a layout in a query

Post

     I have a query where I'd like to display the (one or more) roles a particular user has. But, to narrow down the query, I need to use the current user value from one of the form fields.

     I've tried adding an additional where clause that references the table field, but that doesn't work since I'm basically saying where user = user.

     What's the trick to reference a form field and say something like:

     <where clause>

     and

     u.user_name = <user value on form>

     Hope this question is clear.

     Look forward to suggestions.

     - m

      

      

Outcomes