"Dynamic " select in template: HOW?

Next topic

Author	Message
PaoloMellerio kk	Monday 31 May 2004 8:35:27 am Hi, I've the need to have a SELECT object in one of my template whose lines are the result of a fetch of values contained in an attribute of one of my classes. My problem is that the lines of this SELECT must be UNIQUE, that is to say that the choice in the SELECT is restricted only at UNIQUE values coming from the fetch: <select class="search" name="t219" id="Search"> <option selected value="">Choose</option> {let myfolder=47 used_node=false()} {* 47 is the id of the folder containing the classes - ID=17 in which I must look...*} {section loop=fetch(content,tree,hash(parent_node_id, $myfolder,class_filter_type, "include",class_filter_array, array(17)))} <option>{$:item.data_map.myattributeclass.content}</option> {/section} {/let} </select> I don't understand how to make the Array Operator \|UNIQUE to interact with my code to reach my need... Any Idea? THX in Advice Paolo Mellerio (Clikka!com) Paolo Mellerio http://www.clikka.com
Trond Åge Kvalø	Tuesday 08 June 2004 7:38:50 am Hello Paolo! If I understand you correctly, the attribute may contain identical values, is that correct? And you only want to show one of the identical values, right? Then I would write your select like this: <select class="search" name="t219" id="Search"> <option selected value="">Choose</option> {let myfolder=47 used_node=false()} {let myAttributeValues=fetch(content,tree,hash(parent_node_id, $myfolder,class_filter_type, "include",class_filter_array, array(17)))} {$myAttributeValues\|unique} {This is where you remove the duplicate values} {section loop=$myAttributeValues} <option>{$:item.data_map.myattributeclass.content}</option> {/section} {/let} </select> I have not tested this, but try to see if it works. best regards trondåge trondåge

Author

Message

Monday 31 May 2004 8:35:27 am

Hi,
I've the need to have a SELECT object in one of my template whose lines are the result of a fetch of values contained in an attribute of one of my classes. My problem is that the lines of this SELECT must be UNIQUE, that is to say that the choice in the SELECT is restricted only at UNIQUE values coming from the fetch:

<select class="search" name="t219" id="Search">
<option selected value="">Choose</option>
{let myfolder=47 used_node=false()} {* 47 is the id of the folder containing the classes - ID=17 in which I must look...*}
{section loop=fetch(content,tree,hash(parent_node_id, $myfolder,class_filter_type, "include",class_filter_array, array(17)))}
<option>{$:item.data_map.myattributeclass.content}</option>
{/section}
{/let}
</select>

I don't understand how to make the Array Operator |UNIQUE to interact with my code to reach my need...

Any Idea?

THX in Advice

Paolo Mellerio (Clikka!com)

Paolo Mellerio
http://www.clikka.com

Trond Åge Kvalø

Tuesday 08 June 2004 7:38:50 am

Hello Paolo!

If I understand you correctly, the attribute may contain identical values, is that correct?

And you only want to show one of the identical values, right?

Then I would write your select like this:

<select class="search" name="t219" id="Search">
<option selected value="">Choose</option>
{let myfolder=47 used_node=false()} 
{let myAttributeValues=fetch(content,tree,hash(parent_node_id, $myfolder,class_filter_type, "include",class_filter_array, array(17)))}
{$myAttributeValues|unique} {*This is where you remove the duplicate values*}
{section loop=$myAttributeValues}
<option>{$:item.data_map.myattributeclass.content}</option>
{/section}
{/let}
</select>

I have not tested this, but try to see if it works.

best regards
trondåge

trondåge

eZ debug

Timing:	Jan 18 2025 19:29:42
Script start
Timing:	Jan 18 2025 19:29:42
Module start 'layout'
Timing:	Jan 18 2025 19:29:42
Module start 'content'
Timing:	Jan 18 2025 19:29:42
Module end 'content'
Timing:	Jan 18 2025 19:29:42
Script end

Main resources:

Total runtime	0.0165 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.0059	589.3438	152.6250
Module start 'layout'	0.0059	0.0029	741.9688	39.4609
Module start 'content'	0.0088	0.0056	781.4297	89.4609
Module end 'content'	0.0144	0.0020	870.8906	30.3047
Script end	0.0164		901.1953

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	20.8163	14	0.0002
Check MTime	0.0012	7.2260	14	0.0001
Mysql Total
Database connection	0.0010	6.3295	1	0.0010
Mysqli_queries	0.0024	14.5549	3	0.0008
Looping result	0.0000	0.0912	1	0.0000
Template Total	0.0016	9.5	1	0.0016
Template load	0.0009	5.4547	1	0.0009
Template processing	0.0007	4.0092	1	0.0007
Override
Cache load	0.0006	3.7847	1	0.0006
General
dbfile	0.0003	1.7975	8	0.0000
String conversion	0.0000	0.0536	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