MAXIMO Forum

Please consider registering
guest

Log In Register

Register | Lost password?
Advanced Search

— Forum Scope —

  

— Match —

   

— Forum Options —

    

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
dkitzelman
Member
Forum Posts: 4
Member Since:
August 7, 2013
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

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

Try with

where reportedby = :USER

 

Edwin

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

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

Forum Timezone: America/New_York

Most Users Ever Online: 45

Currently Online:
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

madd0g17: 42

vkumar: 30

mandreas: 29

david.stetson: 29

zeezoe: 24

cagola: 24

Member Stats:

Guest Posters: 0

Members: 7821

Moderators: 0

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 949

Posts: 2748

Newest Members: V S Rama Raju Kalidindi, Tushar Pandit, Jose Torres, Mark Fresa, Michael Liu, sudheer nrsn

Administrators: Chon: 801