Url Search for blank

7 posts by 3 authors in: Forums > CMS Builder
Last Post: February 12, 2015   (RSS)

By markr - February 10, 2015

Is it possible to have multiple field URL search for an empty value, e.g. decision_value = ""

I am trying to write something like... page.php/status-Open/decision_value- ?

By claire - February 11, 2015

Hi there - I'm not sure I understand what you're trying to do here. Can you give us any more information?

--------------------

Claire Ryan
interactivetools.com

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

By claire - February 11, 2015

The CMSB docs includes a feature called 'use SEO URLs' - see this entry here, it's about half way down the page: http://www.interactivetools.com/docs/cmsbuilder/viewer_options.html

I think this does exactly what you're looking for. It's a custom option, not supported by all servers, that allows multiple variables to be passed in the path info in the manner you describe.

The usage is by adding "'useSeoUrls' => true" to the getRecords function.

--------------------

Claire Ryan
interactivetools.com

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

By markr - February 11, 2015

Yes, I know. Url search works fine. That's not my question.

My question is is it possible to search for an empty or null value, e.g. color = '', as one of the multiple variables?

By claire - February 12, 2015

Okay, how should the logic work for the search? Should the null value return all records regardless, or only records where that value has not been set?

--------------------

Claire Ryan
interactivetools.com

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

By Dave - February 12, 2015

Hi Markr, 

I think you may be looking for the _empty search suffix option: 
http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

Let me know if that does what you need.  Thanks!

Dave Edis - Senior Developer
interactivetools.com