CMS Made Simple Forums

Posted: **Tue Mar 24, 2015 3:52 pm**

hi,

i'm looking if it is possible to use the search_* function, that ships with the LISTIT2 module, in such a way that i can look for rows where a certain field is not empty.

For example:
i have a LISTIT2 inctance which is a list of products, each product has a non mandatory field for the upload of a technical sheet.

Can i then get only the products that have technical sheets whith the module tag OR do i need the create a if statement in my template?

the disadvantage of the if state ment is that if there are products, but none with the technical sheet, the template loop will be run anyway.

I tried this code but it returns an error

Code: Select all

{ListIt2products search_dop!=""}

I tried this code but it returns no items at all

Code: Select all

{ListIt2products search_dop="*"}

Kind regards

Posted: **Sat Apr 04, 2015 11:33 am**

Get all items from your search filter but only output those you need, eg:

Code: Select all

{foreach from=$items item=item}
  {if $item->fielddefs->myfield->value != ''}
    ... do your output...
  {/if}
{/foreach}

Posted: **Sat Apr 04, 2015 6:49 pm**

I did have a look at the code/query and it doesn't use the 'like' operator. This means you cannot search for an 'is not empty' value by default.

psy's solution seems the best you can get (though not efficient).

Posted: **Tue Apr 14, 2015 7:44 am**

Thanks Psy & velden, that is what i tought, but i had hoped there was a more efficient way.

Posted a feature request for this: http://dev.cmsmadesimple.org/feature_request/view/10494

and i'll keep my fingers crossed...

Posted: **Tue Apr 14, 2015 8:12 am**

I wouldn't hold my breath.... ListIt2 isn't under active development anymore.

Posted: **Tue Apr 14, 2015 9:46 am**

ListIt2 has discontinued, EasyList is a fork of it
http://dev.cmsmadesimple.org/projects/easylist

Posted: **Fri Apr 17, 2015 9:53 am**

Ok, great news. will check Easylist.

Posted: **Fri Apr 17, 2015 9:57 am**

EasyList is only for CMSMS 2.0, for CMSMS 1.12 you still have to use ListIt2

Posted: **Tue Apr 28, 2015 10:43 am**

staartmees wrote:EasyList is only for CMSMS 2.0, for CMSMS 1.12 you still have to use ListIt2

ListIT2 does not seem to work on every install of CMSMS 1.12.
So for now, no List module .... till CMSMS 2.0 gets out?

Posted: **Tue Apr 28, 2015 10:51 am**

Jo Morg made a work-around, http://forum.cmsmadesimple.org/viewtopi ... =7&t=72707

CMS Made Simple Forums

Listit2 get row if field not empty [solved]

Listit2 get row if field not empty [solved]

Re: Listit2 get row if field not empty

Re: Listit2 get row if field not empty

Re: Listit2 get row if field not empty

Re: Listit2 get row if field not empty [solved]

Re: Listit2 get row if field not empty [solved]

Re: Listit2 get row if field not empty [solved]

Re: Listit2 get row if field not empty [solved]

Re: Listit2 get row if field not empty [solved]

Re: Listit2 get row if field not empty [solved]