advanced filter
- thewebsurfer
- OFFLINE
-
Elite Member
- Posts: 293
- Thanks: 13
- Karma: 1
10 years 5 months ago #237437
by thewebsurfer
advanced filter was created by thewebsurfer
hi i have a db column cb_works with an imploded array in it (multichoice select):
shop|*|office|*|laboratory|*| ecc...
i want to set a list filter on this column:
i tried advanced filter:
`cb_works` LIKE '%[Office]%'
doesnt work
shop|*|office|*|laboratory|*| ecc...
i want to set a list filter on this column:
i tried advanced filter:
`cb_works` LIKE '%[Office]%'
doesnt work
Please Log in to join the conversation.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
10 years 5 months ago #237448
by nant
of course it doesn't.
why are you using [ ]?
and why are you using Office instead of office ?
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic advanced filter
thewebsurfer wrote: hi i have a db column cb_works with an imploded array in it (multichoice select):
shop|*|office|*|laboratory|*| ecc...
i want to set a list filter on this column:
i tried advanced filter:
`cb_works` LIKE '%[Office]%'
doesnt work
of course it doesn't.
why are you using [ ]?
and why are you using Office instead of office ?
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- thewebsurfer
- OFFLINE
-
Elite Member
- Posts: 293
- Thanks: 13
- Karma: 1
10 years 5 months ago #237455
by thewebsurfer
Replied by thewebsurfer on topic advanced filter
i found [] method somewhere online, i tried {} and doesnt work too.
i use "Office" cause i can't change the CB dropdown option value, so i have the capitalization:
<option value="Office">Office</option>
i use "Office" cause i can't change the CB dropdown option value, so i have the capitalization:
<option value="Office">Office</option>
Please Log in to join the conversation.
- thewebsurfer
- OFFLINE
-
Elite Member
- Posts: 293
- Thanks: 13
- Karma: 1
10 years 5 months ago #237456
by thewebsurfer
Replied by thewebsurfer on topic advanced filter
i solved with
`cb_works` LIKE '%Office%'
`cb_works` LIKE '%Office%'
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.189 seconds
-
You are here:
- Home
- Forums
- Community Discussions
- Community Builder
- advanced filter