Membership 'where' filtering

9 posts by 2 authors in: Forums > CMS Builder
Last Post: June 15, 2012   (RSS)

By s2smedia - June 13, 2012

Hi.. I have a list on my site showing projects of current signed in user:

'where' => 'project_manager= "'. $CURRENT_USER['id'] .'"' ,

works great.. but I want to change the "project_manager" field to be a multi check box.. so I can assign multiple users to 1 project.

When I change it to a checkbox.. the 'where' does not work.

is there another way to program this?

Re: [s2smedia] Membership 'where' filtering

By Jason - June 14, 2012

Hi,

Try this:

'where' => "project_manager LIKE '%\t". $CURRENT_USER['id'] ."\t%'" ,

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Membership 'where' filtering

By s2smedia - June 14, 2012

I tried that code.. but nothing shows up..

I switched it back to radio button (single select) using the older 'where' code and it shows up fine..

when I use the code you just sent.. and then switch to mutliple checkboxes.. the list is blank

any ideas?

I attached the file..
Attachments:

index_045.php 9K

Re: [Jason] Membership 'where' filtering

By s2smedia - June 14, 2012

I did do that.. but not working.. not showing any results.

i attached the file with your Where code

I have the list in CMS as a checkbox multi list

Re: [s2smedia] Membership 'where' filtering

By Jason - June 14, 2012

Hi,

the file didn't come through. If you could re-attach the file and the send in a [url http://www.interactivetools.com/support]2nd Level Support[/url] request, we can take a look.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Membership 'where' filtering

By s2smedia - June 14, 2012

sorry.. attached
Attachments:

index_046.php 9K

Re: [s2smedia] Membership 'where' filtering

By s2smedia - June 15, 2012

im so sorry.. diregard.. its working.

I had to go though and reselect the multiple list values.

Re: [s2smedia] Membership 'where' filtering

By Jason - June 15, 2012

No problem. Glad to hear everything is working now.

Let us know if you have any other questions
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/