Log In
Register
Home
Topic RSS
9:27 am
December 8, 2009
Offline
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,
Derek
11:36 am
September 29, 2009
Offline
Try with
where reportedby = :USER
Edwin
1:14 pm
July 30, 2009
Offline
&USERNAME& is only use in DB Configuration. Try with :user
Most Users Ever Online: 42
Currently Online:
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
David: 29
mandreas: 26
vkumar: 26
cagola: 24
maximo21: 22
jayaganesh: 19
Member Stats:
Guest Posters: 0
Members: 4951
Moderators: 0
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 458
Posts: 1373
Newest Members: sbristol21, koppv0, kellergw, Murat, mfabra, jmoore
Moderators:
Administrators: Chon (446)
