You can have several matches in the attributre_filter array. These matches are carried out with either "and" or "or" condition.

So I guess what you need is something like

 'attribute_filter', array ( 'or', array( 'title', 'like', '#*'), array(<condition2>), array(<condition3>)))

Modified on Saturday 03 March 2012 8:54:04 am by Olivier Clavel

Hi Oliver i try this but it's not working pls chk my code

'attribute_filter', array( 'or', array('article/archive_status', '=', 0), array('article/publish_date', '<=', currentdate()), array('article/title', '>=', 0), array('article/title', '<=', 9), array('article/title', 'like', concat('#*') )

there is some data that start with # and space also.

Hello Jignesh,

Why are you doing a "concat" in the last filter ? Try:

 array( 'article/title', 'like', '#*')

Have you some error in the debug output ?

Is it possible to use "regexp" insted of "like" is possible please provide some example

Quote from Jignesh Sailor :

Is it possible to use "regexp" insted of "like" is possible please provide some example

Hi,

Built'in operator for attribute filtering are here:

http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Modules/content/Fetch-functions/list

if none of these can match your case, You may create your extended_attribute_filter

NB: there's an example at the bottom of the page, on how to create an extended_attribute_filter.

if you have question about how to create it, you can post it here...

Modified on Wednesday 07 March 2012 11:05:10 am by Ousmane KANTE

Quote from Ousmane KANTE :

Quote from Jignesh Sailor :

Is it possible to use "regexp" insted of "like" is possible please provide some example

Hi,

Built'in operator for attribute filtering are here:

http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Modules/content/Fetch-functions/list

if none of these can match your case, You may create your extended_attribute_filter

NB: there's an example at the bottom of the page, on how to create an extended_attribute_filter.

if you have question about how to create it, you can post it here...

Hi Ousmane i  am new to ezpublish so is it poassible to create extended attribute filter for my requirement, i also want ot know how to print sql query for fetch  so that i can know what  type of sql query is been used i enable the SQLoutput in "site.ini.append.php" but it did't shoq me any query 

Quote from Jignesh Sailor :

Quote from Ousmane KANTE :

Quote from Jignesh Sailor :

Is it possible to use "regexp" insted of "like" is possible please provide some example

Hi,

Built'in operator for attribute filtering are here:

http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Modules/content/Fetch-functions/list

if none of these can match your case, You may create your extended_attribute_filter

NB: there's an example at the bottom of the page, on how to create an extended_attribute_filter.

if you have question about how to create it, you can post it here...

Hi Ousmane i  am new to ezpublish so is it poassible to create extended attribute filter for my requirement, i also want ot know how to print sql query for fetch  so that i can know what  type of sql query is been used i enable the SQLoutput in "site.ini.append.php" but it did't shoq me any query 

Hi,

Not sure to really understand your post.

Do you want to create an extended_attribute_filter?

For showing Sql output in debug, I think should first enable 'DebugOutput' in DebugSettings section in your 'site.ini'. (enable debug output)

Then enable SQLOupt in DataBaseSettings section.

Hope that can Help you

Quote from Ousmane KANTE :

Quote from Jignesh Sailor :

Quote from Ousmane KANTE :

Quote from Jignesh Sailor :

Is it possible to use "regexp" insted of "like" is possible please provide some example

Hi,

Built'in operator for attribute filtering are here:

http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Modules/content/Fetch-functions/list

if none of these can match your case, You may create your extended_attribute_filter

NB: there's an example at the bottom of the page, on how to create an extended_attribute_filter.

if you have question about how to create it, you can post it here...

Hi Ousmane i  am new to ezpublish so is it poassible to create extended attribute filter for my requirement, i also want ot know how to print sql query for fetch  so that i can know what  type of sql query is been used i enable the SQLoutput in "site.ini.append.php" but it did't shoq me any query 

Hi,

Not sure to really understand your post.

Do you want to create an extended_attribute_filter?

 

For showing Sql output in debug, I think should first enable 'DebugOutput' in DebugSettings section in your 'site.ini'. (enable debug output)

Then enable SQLOupt in DataBaseSettings section.

Hope that can Help you

i want to create extended_attribute_filter

Hi

Just take the example 20 on the page above (ie http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Modules/content/Fetch-functions/list)

then you just have to replace the SQL code with your own.

something like that :

class myRegexpExtendedAttributeFilter{

.....

function sqlParts( $parameters )
    {
        $sqlTables= ', ezcontentobject_attribute as myregexp_alias ';
        $sqlJoins = ' ezcontentobject_tree.contentobject_id = myregexp_alias.contentobject_id AND ' .
                    ' ezcontentobject_tree.contentobject_version = myregexp_alias.version AND '.
                    ' myregexp_alias.identifier = "title"  AND ';
        $sqlJoins .= eZContentLanguage::sqlFilter( "myregexp_alias", 'ezcontentobject' ). ' AND ';// for multi lang...
        $sqlCond = ' myregexp_alias.data_text regexp( "'. $paramters . '" ) AND ' . $sqlJoins . ' ';
        return array( 'tables' => $sqlTables, 'joins' => $sqlCond );
    }

....

}

and your template code should looks like

fetch('content', 'list', hash('parent_node_id', $node_id, 'class_filter_type', 'include', 'class_filter_array', array('article'), 'extended_attribute_filter', hash('id', 'myRegExpFilter', 'params', 'your_regexp')))}

extendedattributefilter.ini looks like

[myRegExpFilter]
ClassName=myRegexpExtendedAttributeFilter
MethodName=sqlParts

Test it

Modified on Friday 09 March 2012 5:07:01 pm by Ousmane KANTE