Forums / Developer / content fetching operator like the SQL "where zipCode LIKE '89%'"

content fetching operator like the SQL "where zipCode LIKE '89%'"

Author Message

Robin de Silva Jayasinghe

Monday 25 October 2004 12:06:46 am

hello,

is there an template-operator which works like the LIKE operator in SQL?

SELECT * FROM cities WHERE zipCode LIKE '89%'"

my intention is to fetch only the content-objects which attribute "zipCode" has a value beginning with "89".

regards,
robin

visit http://www.jayasinghe.de

Björn [email protected]

Monday 25 October 2004 4:40:03 pm

Paul Borgermans and his guys from belgium have a modified ezcontentobject.php class that can match contentobject attributes like "like"

http://pubsvn.ez.no

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Robin de Silva Jayasinghe

Monday 25 October 2004 8:28:16 pm

thanks a lot! i'll have a look on that..

und viele gruesse nach hannover ! ;)

visit http://www.jayasinghe.de

Robin de Silva Jayasinghe

Tuesday 26 October 2004 5:26:32 am

hmm.. where exactly can i find the file on that site (http://pubsvn.ez.no)? in the "community" or the "ezPublish" - area? is there something like a search functionality ?

regards,
robin

visit http://www.jayasinghe.de

Tobias Persson

Tuesday 26 October 2004 5:36:05 am

Not sure, but this might be the one??
http://www.ez.no/community/contributions/hacks/more_attribute_filter_operators_and_fetch_by_owner_id

Paul Borgermans

Tuesday 26 October 2004 5:38:05 am

Robin,

You can download a version for the latest stable here:

http://ez.no/community/contributions/hacks/more_attribute_filter_operators_and_fetch_by_owner_id

I will post this also as an "extended attribute filter" which makes this independent of ezp upgrades. I guess most of the functionality will land in the trunk (post 3.5 because of the feature freeze)

hth

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans