Where Clause Query Parameters - Current User | General MAXIMO 7 Support | MAXIMO Forum

Featured

 
guestdefault MAXIMO Forum
You must be logged in to post user permissions MAXIMO Forum
Search Forums:


searchicon MAXIMO Forum 






Minimum search word length is 3 characters - Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

topic MAXIMO Forum

Where Clause Query Parameters - Current User

small tag MAXIMO Forumrelated MAXIMO Forum
UserPost

9:27 am
August 31, 2010


dkitzelman

userdefault MAXIMO Forum
Member

posts 4

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
August 31, 2010


ecadillo

Lima, Perú

userdefault MAXIMO Forum
New Member

posts 1

Try with

where reportedby = :USER

 

Edwin

1:14 pm
September 6, 2010


nofear

userdefault MAXIMO Forum
New Member

posts 1

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

small tag MAXIMO Forumrelated MAXIMO Forum

About the Maximo Times Forum

Forum Timezone: UTC -5

Most Users Ever Online: 23

Currently Online:
12 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 1
Forums: 8
Topics: 399
Posts: 1195

Membership:

There are 4691 Members

There is 1 Admin

Top Posters:

vkumar - 26
cagola - 24
maximo21 - 22
mandreas - 19
David - 18
jayaganesh - 17

Recent New Members: c_tipa, dnegrotti, leenux_tux, orozcom1, praveen.jakkali, nfridl

Administrators: Chon Neth (398 Posts)