Build selection fetch/list and sort

Previous topic

Setup & design

Next topic

Author	Message
Tim Dickinson	Friday 15 December 2006 6:50:46 pm Hi all, I have created a class which contains a number of selection datatypes. What I would like to be able to do is to create a form with pulldown lists for users to limit their fetch by choosing what they want from those selection datatypes. To try to explain it a bit better, the content class look like the following -title -body -selection_a -----option_a_1 -----option_a_2 -----option_a_3 -selection_b -----option_b_1 -----option_b_2 -----option_b_1 -selection_c -----option_c_1 -----option_c_2 -----option_c_3 -rating -url I would like the user to be able to choose each option for each datatype through a series of pulldown menus, and then when the form is submitted to produce a list of results that have each of those options. I would then like to sort the list by rating (descending) I know this has something to do with fetch and sort, but I am at a complete loss as to how to create the pulldown lists. Thanks in advanace, Tim http://www.AdBalance.com - Ad network news and reviews http://www.DevPublisher.com - Website publisher guides, tools and news http://www.AudioMelody.com - Make better music
Marko Žmak	Monday 18 December 2006 7:59:53 am You should use attribute filter and sorting by attribute. Check the examples on the bottom of this page: http://ez.no/doc/ez_publish/technical_manual/3_8/reference/modules/content/fetch_functions/list -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth

Author

Message

Tim Dickinson

Friday 15 December 2006 6:50:46 pm

Hi all,

I have created a class which contains a number of selection datatypes.
What I would like to be able to do is to create a form with pulldown lists for users to limit their fetch by choosing what they want from those selection datatypes.

To try to explain it a bit better, the content class look like the following

-title
-body
-selection_a
-----option_a_1
-----option_a_2
-----option_a_3
-selection_b
-----option_b_1
-----option_b_2
-----option_b_1
-selection_c
-----option_c_1
-----option_c_2
-----option_c_3
-rating
-url

I would like the user to be able to choose each option for each datatype through a series of pulldown menus, and then when the form is submitted to produce a list of results that have each of those options. I would then like to sort the list by rating (descending)

I know this has something to do with fetch and sort, but I am at a complete loss as to how to create the pulldown lists.

Thanks in advanace,

Tim

http://www.AdBalance.com - Ad network news and reviews
http://www.DevPublisher.com - Website publisher guides, tools and news
http://www.AudioMelody.com - Make better music

Marko Žmak

Monday 18 December 2006 7:59:53 am

You should use attribute filter and sorting by attribute. Check the examples on the bottom of this page:

http://ez.no/doc/ez_publish/technical_manual/3_8/reference/modules/content/fetch_functions/list

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

eZ debug

Timing:	Jan 18 2025 11:22:54
Script start
Timing:	Jan 18 2025 11:22:54
Module start 'layout'
Timing:	Jan 18 2025 11:22:54
Module start 'content'
Timing:	Jan 18 2025 11:22:54
Module end 'content'
Timing:	Jan 18 2025 11:22:54
Script end

Main resources:

Total runtime	0.0278 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.0150	588.0313	152.6406
Module start 'layout'	0.0150	0.0039	740.6719	39.4609
Module start 'content'	0.0189	0.0066	780.1328	89.3203
Module end 'content'	0.0256	0.0022	869.4531	30.3047
Script end	0.0278		899.7578

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	11.1698	14	0.0002
Check MTime	0.0014	5.0673	14	0.0001
Mysql Total
Database connection	0.0016	5.8557	1	0.0016
Mysqli_queries	0.0042	15.0210	3	0.0014
Looping result	0.0000	0.0788	1	0.0000
Template Total	0.0018	6.5	1	0.0018
Template load	0.0010	3.5907	1	0.0010
Template processing	0.0008	2.8931	1	0.0008
Override
Cache load	0.0007	2.5949	1	0.0007
General
dbfile	0.0015	5.2832	8	0.0002
String conversion	0.0000	0.0360	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