Forum Activity for @blindmime

blindmime
@blindmime
04/18/14 09:28:10AM
775 posts

variables in jrCore_list search


Using Jamroom

I believe it's working perfectly, Brian. Thanks again.
blindmime
@blindmime
04/18/14 09:15:28AM
775 posts

variables in jrCore_list search


Using Jamroom

Thanks, guys. What a team!
blindmime
@blindmime
04/18/14 07:59:47AM
775 posts

variables in jrCore_list search


Using Jamroom

No. profile_salesperson is "Some Name". $rep is also "Some Name". it's just brought in via the url as http://domain.net/proofs?rep=Some+Name. In the {debug} it shows as "Some Name" and outputs on the page as "Some Name".

I'm not searching for "Some+Name" (although I've tried that, as I've tried a thousand other ways).

Searching for "Some Name" produces nothing in the list. There is something not working in the search. I've hard coded the value and I've tried a thousand other ways. The only way it works is if the value is one word.
blindmime
@blindmime
04/17/14 11:36:47PM
775 posts

variables in jrCore_list search


Using Jamroom

The code Brian pasted is what I was trying but wasn't working. So I started this thread.

I think I may have found an issue with the search. After further testing, search2="profile_salesperson = `$rep`" does work, but only if the value is one word (has no spaces).

Do I need to encode the space?
blindmime
@blindmime
04/17/14 03:36:23PM
775 posts

variables in jrCore_list search


Using Jamroom

I get profile_salesperson => "Some Name" 10 times in the $_items array on that page.
blindmime
@blindmime
04/17/14 03:25:31PM
775 posts

variables in jrCore_list search


Using Jamroom

If I pull up {debug} I can see the profile_salesperson for each item in the list. (at least I think that's what I'm seeing) Are you sure I can't search this? It would make things so much better.

Maybe there's another way to achieve this without adding another field I have to enter something into with every job?

If I have to make another field, is there a way to pull a value into it on creation, based on item's profile?
blindmime
@blindmime
04/17/14 02:23:54PM
775 posts

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.
blindmime
@blindmime
04/17/14 12:33:16PM
775 posts

variables in jrCore_list search


Using Jamroom

Yes, I have it outputting in the page header OK.

Here's my code (maybe I'm typing something wrong...

{jrCore_list module="jrFile" search1="file_approved != on" search2="profile_salesperson = `$rep`" order_by="file_display_order numerical_asc" pagebreak="10" page=$_post.p pager=true}
blindmime
@blindmime
04/17/14 10:38:21AM
775 posts

variables in jrCore_list search


Using Jamroom

No results with the search2 addition as above.
  62