Our max query is set to 0, so everything should come back and be listed in my opinion correct?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of vaibhav wadekar Sent: Monday, August 10, 2015 11:00 PM To: arslist@ARSLIST.ORG Subject: Re: SRM 8.1 SP2 On Behalf Of Issues ** What is the max query set to? Did you tried setting it to 0 and has same result? Just wanted to understand the returning SQL not return result based on max query parameter set. Regards, Vaibhav On Mon, Aug 10, 2015 at 9:42 AM Kemes, Lisa A DLA CTR INFORMATION OPERATIONS <lisa.kemes....@dla.mil> wrote: 8.1 SP2 AR System and Oracle Database. I created a On Behalf Of setting that uses Global for Requested by and Requested For, so I should see all users when I search on a last name correct? I don't, I only see a fraction of the amount of users I should see when searching on the last name (Miller for example). I should see more than 100 Millers, but I only see 5. I compared all of them and I can't fine any rhyme or reason why I should be able to see them all. Seems like a really easy setting to set, but it's not giving me the results that I think I should see. Even though we are set for Multi-Tenancy, we only have 1 company set up. I even tried adding the On Behalf Of Setting for our company (In addition to Global) and I'm still not able to view all the users with a last name of Miller when I do my search. Plus, even though we have FTS enabled, the search box does not bring up ANYTHING when searching for miller. Only Miller will bring back data. Anyone have any ideas? Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"