Please consider registering

Log In Register

Register | Lost password?
Advanced Search

— Forum Scope —


— Match —


— Forum Options —


Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 3 characters - maximum search word length is 84 characters

Topic RSS Related Topics
Where Clause Query Parameters - Current User
August 31, 2010
9:27 am
Forum Posts: 4
Member Since:
August 7, 2013

I would like to pass in a parameter for current logged in user in a where clause for a work order search, so that the results in a result set only brings back records for the user currently logged in.  I tried "where reportedby = &USERNAME&" but the UI does not recognize this parameter.


Any ideas?


Thanks in advance,


August 31, 2010
11:36 am
Lima, Perú
New Member
Forum Posts: 1
Member Since:
August 7, 2013

Try with

where reportedby = :USER



September 6, 2010
1:14 pm
New Member
Forum Posts: 1
Member Since:
August 7, 2013

&USERNAME& is only use in DB Configuration. Try with :user

Forum Timezone: America/New_York

Most Users Ever Online: 45

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

madd0g17: 39

vkumar: 30

mandreas: 29

david.stetson: 29

zeezoe: 24

cagola: 24

Member Stats:

Guest Posters: 0

Members: 7439

Moderators: 0

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 885

Posts: 2558

Newest Members: Abhijeet Tiwari, Nadean King, Kaarl Harster, Kuldeep Mummidisetty, Tahar BELAID, Harsh Garg

Administrators: Chon (767)