(will not work when used as multiple selector)

Previous topic

Developer

Next topic

Author	Message
Fabricio Guerrero	Monday 23 January 2006 6:14:55 am Hi, (will not work when used as multiple selector) I've seen that comment all over the forum and documentation section but my problem :( is that i indeed have a Class with a multiple selector and an important part is for me to fetch and filter on that field. To give a bit more detail we're creating a site based on articles and these articles can have various categories. As an user you can be able to view articles by categories. The fetch works if that Article only belongs to one category but if the article has various categories(multiple selector working here) the fetch just wont return the article... I've tested various ways of filtering(like, in) but none seem to work. Here's the simple fetch: {let filter_cat=fetch( 'content', 'tree', hash( 'parent_node_id', 77, class_filter_type, "include", class_filter_array, array(25), attribute_filter, array( array( 'article_issue/category', '=', $selected ) ), ... Thank you in advance for all help given... Fabricio http://www.solobromasychistes.com <<Joomla Site :P http://www.recipesforhealthyfood.com/ <<Drupal Site :P http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...
Fabricio Guerrero	Tuesday 24 January 2006 9:49:08 am Hi, Trying to bump this up... I've done a work around for this.. My need was or is to be able to Filter Multiple Selection Attributes. Since all over this site it specifically indicates that the "attribute_filter" cann't filter these type of Attributes I rewrote the fetch using the 'search' 'text' feature... this way i can perform a text search in the Multiple Selection Attribute and get the Articles assigned to either one or multiple categories... example fetch: {def $search=fetch( 'content', 'search', hash( 'text', 'value_looking_for_here', 'class_id', 25, 'class_attribute_id', multiple_selection_attribute_id_here, 'offset',$view_parameters.offset, 'limit', $numberOfObjects, 'sort_by', array( 'published', false() ) ))} {set search_result=$search['SearchResult']} {set search_count=$search['SearchCount']} ...here start looping... Does anybody have any other ways to filter a Multiple SelectionAttribute? Regards, Fabricio http://www.solobromasychistes.com <<Joomla Site :P http://www.recipesforhealthyfood.com/ <<Drupal Site :P http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...

Author

Message

Fabricio Guerrero

Monday 23 January 2006 6:14:55 am

Hi,

(will not work when used as multiple selector)

I've seen that comment all over the forum and documentation section but my problem :( is that i indeed have a Class with a multiple selector and an important part is for me to fetch and filter on that field.

To give a bit more detail we're creating a site based on articles and these articles can have various categories. As an user you can be able to view articles by categories. The fetch works if that Article only belongs to one category but if the article has various categories(multiple selector working here) the fetch just wont return the article...

I've tested various ways of filtering(like, in) but none seem to work. Here's the simple fetch:

{let
filter_cat=fetch( 'content', 'tree', hash( 'parent_node_id', 77,
class_filter_type, "include", class_filter_array, array(25),
attribute_filter, array( array( 'article_issue/category', '=', $selected ) ),
...

Thank you in advance for all help given...

Fabricio

http://www.solobromasychistes.com <<Joomla Site :P
http://www.recipesforhealthyfood.com/ <<Drupal Site :P
http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...

Fabricio Guerrero

Tuesday 24 January 2006 9:49:08 am

Hi,

Trying to bump this up... I've done a work around for this.. My need was or is to be able to Filter Multiple Selection Attributes.

Since all over this site it specifically indicates that the "attribute_filter" cann't filter these type of Attributes I rewrote the fetch using the 'search' 'text' feature... this way i can perform a text search in the Multiple Selection Attribute and get the Articles assigned to either one or multiple categories...

example fetch:

{def $search=fetch( 'content', 'search',
hash( 'text', 'value_looking_for_here',
'class_id', 25,
'class_attribute_id', multiple_selection_attribute_id_here,
'offset',$view_parameters.offset,
'limit', $numberOfObjects,
'sort_by', array( 'published', false() )
))}
{set search_result=$search['SearchResult']}
{set search_count=$search['SearchCount']}

...here start looping...

Does anybody have any other ways to filter a Multiple SelectionAttribute?

Regards,
Fabricio

http://www.solobromasychistes.com <<Joomla Site :P
http://www.recipesforhealthyfood.com/ <<Drupal Site :P
http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...

eZ debug

Timing:	Jan 20 2025 20:57:57
Script start
Timing:	Jan 20 2025 20:57:57
Module start 'layout'
Timing:	Jan 20 2025 20:57:57
Module start 'content'
Timing:	Jan 20 2025 20:57:57
Module end 'content'
Timing:	Jan 20 2025 20:57:57
Script end

Main resources:

Total runtime	0.0157 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	588.0469	151.2266
Module start 'layout'	0.0048	0.0030	739.2734	36.6797
Module start 'content'	0.0078	0.0062	775.9531	90.1875
Module end 'content'	0.0140	0.0017	866.1406	33.9922
Script end	0.0156		900.1328

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	16.5274	14	0.0002
Check MTime	0.0012	7.3967	14	0.0001
Mysql Total
Database connection	0.0006	4.0608	1	0.0006
Mysqli_queries	0.0029	18.3571	3	0.0010
Looping result	0.0000	0.1018	1	0.0000
Template Total	0.0013	8.0	1	0.0013
Template load	0.0010	6.4772	1	0.0010
Template processing	0.0002	1.4544	1	0.0002
Override
Cache load	0.0007	4.4681	1	0.0007
General
dbfile	0.0016	10.3784	8	0.0002
String conversion	0.0000	0.0638	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs