Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Search Criteria Operators

1 reply [Last post]
Tue, 05/12/2009 - 2:11am
iammanku's picture
iammanku
User offline. Last seen 11 years 2 weeks ago. Offline
Joined: 03/24/2009
Posts: 10

Hi All,

I have a component Search page. In this search page,
1) How can I identify the operator I select in the criteria. Or how can we limit the set of operators to '=' alone? [I used SetSearchEdit but it reduces the set of operators to '=' and IN.]

2) 'IN' operator is behaving in an indifferent way such that a comma separated list when read in SearchSave gives the last entry in the comma separated list.
Suppose, for SITE_ID i entered comma separated list as, 1000,2000,3000 and the operator selected is IN. But when I use a WinMessage in the SearchSave to see the values of this SITE_ID , I am getting only the last entry -- 3000.

This is urgent. So Pls be kind enough to tell me how can I extract each of these values.

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 2602 reads
Fri, 05/15/2009 - 8:57am
#1
jullman's picture
jullman
User offline. Last seen 10 years 13 weeks ago. Offline
Joined: 05/14/2009
Posts: 3
Re: Search Criteria Operators

I do not know Peoplecode, but if it works like some other languages, the list of values is treated as a sort of array, and you have to get each one out. In VB, for example, you can use the "split" function to put the values into string, which you can then look at easily. So SPLIT(SITE_ID) would be "1000,2000,3000".

Top