DocLister - filtering query: if an image tv is not empty

nick0

Hello,

Just after some help please with the correct filter logic to use in a DocLister call in an Evo 1.4.15 site.

Specifically:
What's the right filter to use for "if a tv is not empty" usage?

The scenario:

There are currently 21 profiles.
Only 18 profiles have a photo (via a TV called image)... so 3 profiles do not have a photo.
We always want to display 6 profiles.
We always want to exclude profiles that do not have a photo.
In other words - always display 6 profiles that do not have an empty image TV

I am trying this as the filter as an 'if not empty' type check but it is not working (profiles without a photo are still included in the output)...

&filters=`AND(
       	tv:image:!=:;
)`

Using an IF statement like the below in the row template of this menu works to some extent - only profiles with a photo are displayed however the display quantity of 6 is ignored (sometimes it shows 4 profiles, sometimes 5 profiles, rarely 6 profiles) so I am presuming this is not the right way to do this

In an If statement the if not empty check would be something like:
[[if? &is=`[+image+]:!empty` &then=`this is a profile we want to display in this menu` &else=`we don't ever want to display this profile in this menu`]]

but in reality:
[[if? &is=`[+image+]:!empty` &then=`this is a profile we want to display in this menu`]]

This is currently the Doclister call.

[[DocLister?
	&id=`profile[*id*]`
	&idType=`parents`
	&parents=`15`
	&depth=`1`
	&display=`6`
	&ownerTPL=`profileH-menu-wrapper`
	&tpl=`profileH-menu-row`
	&noneTPL=`profile-menu-NO`
	&tvPrefix=``
	&tvList=`image,roles`
	&renderTV=`roles`
	&orderBy=`rand()`
	&filters=`AND(
       	     tv:image:!=:;
	)`
]]

Any ideas on how to filter this correctly?

Thanks in advance for any help.

BBloke

Took me an age to figure out a working call on my end.
I managed it but I don't think it does what you think it does!

So, &filter=AND(tv:image:!=:;); produces this inclusion in the MySQL statement:

(
    (
      `dltv_tags_1`.`value` != '' 
      OR `dltv_tags_1`.`value` IS NULL
    )
  )

Please excuse I've had to replace 'images' with 'tags' so my own call works.
The above results in everything being returned.
anything with a value or anything that is NULL!

It's by design.

If you change the filter so that it's =, this is what you get:

(`dltv_tags_1`.`value` = '')

which would give you any record with something.

What's not in the docs is 'isnull'.

Change your filter to tv:image:isnull: and you should get back records with no TV value (there is also an 'isnotnull').

nick0

Thank you BarnsleyBloke - you are amazing!

Apologies for the tardy reply.

That is genius.

'isnotnull' did the trick - with usage like so tv:image:isnotnull:;... woohoo!

I dare say this style of 'isnull / isnotnull' filter is going to get a workout from here on in... it will be very handy.

The DocLister call is below in case anyone is interested...

[[DocLister?
	&id=`profile[*id*]`
	&idType=`parents`
	&parents=`15`
	&depth=`1`
	&display=`6`
	&ownerTPL=`profileH-menu-wrapper`
	&tpl=`profileH-menu-row`
	&noneTPL=`profile-menu-NO`
	&tvPrefix=``
	&tvList=`image,roles`
	&renderTV=`roles`
	&orderBy=`rand()`
	&_addWhereList=`c.isfolder=0 AND c.id!=[*id*]`
	&filters=`AND(
		tv:image:isnotnull:;
	)`
]]

Thank you again BB - you're an absolute whiz, legend and gentleman all rolled into one... 😄

BBloke

I added the details in my github for docs.