[rt-users] Re: SQL Question

[Stephen Hancock]

Sorry about the post. I was brain dead from being up too long and my
sql statements were just wrong. I was sending a query for:

EmailAddress = '".$session{'CurrentUser'}->EmailAddress."' AND (
Status = 'new' OR Status = 'open' OR Status ='stalled')

insead of Requestor.EmailAddress = .....

The queries now pick up the logged in users requests from the multiple
requestors. I switched from RealName to EmailAddress to insure that
there would be no duplicate user names.

Stephen Hancock

On Wed, 16 Mar 2005 18:12:19 -0500, Stephen Hancock
<sh.hancock at gmail.com> wrote:
> I am trying to create a standard query for the RT at a Glance Page
> that finds all tickets with the users RealName to replace the 'My
> Requests' which searches on the Creator ID. This query will not pick
> up tickets where there are more than 1 requestor.
> 
> I know I can search on specific tickets but we need a relative search
> based on $session('CurrentUser->Id') that will look up the RealName of
> the Requestor and display all the tickets belonging to that person.
> 
> Is this possible from either the Query Builder or within the
> Elements/Standard_Search_List?
> 
> The closest thing I could find to this is the
> GetRequestorInfoByTicketId which does not work for us in this case.
> 
> Stephen Hancock
>