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: [s2smedia] Membership 'where' filtering

By Jason - June 14, 2012

Hi,

multi-value select fields and checkbox lists are all stored as tab (\t) separated lists of values. The code I sent you was for when you were using the checkbox list. The original code you have should be used when using a single value list. The code in the index file you sent, is set up for single value lists.

Change your field to checkbox list and then try the new WHERE clause.

Thanks
---------------------------------------------------
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 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: [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/