variables in jrCore_list search
Using Jamroom
If I leave off search2 I get a list of all the unapproved files. Which is good. But additionally, I want a list of unapproved files pertaining to each salesperson. (Incidentally if search1="file_approved = off" doesn't give me the same list as search1="file_approved != on").
The profile_salesperson is not the same as the profile the item belongs to. Basically, I have profiles for clients. jrFile items are added for each job we are doing for those clients. The clients are given a url to go download a pdf and proof their job. They can make changes or approve jobs via jrComments. Each client profile has a profile_salesperson (not each jrFile item or proof). I have a page built where I pass in the salesperson's name via $rep and I want it to pull all of the unapproved proofs for a particular salesperson so they can track their jobs.