Forums / Setup & design / More Specific Fetching

More Specific Fetching

Author Message

Matthew Rat

Thursday 10 April 2003 1:16:03 pm

I have added 2 fields to the Article class: start_date and stop_date. These are to be used by the template to determine if an article has "expired" or not. I have not been successful in implementing a fetch that will retrieve articles from a given node_id where the start_date is prior to now and where the stop_date is after now. Is this unsupported? I know you can do something similar to this using a "section show=" but that seems incredibly inefficient and could severely slow down the process if you are processing attributes AFTER the database call returns everything in a "folder" or node_id. Any thoughts?

Jan Borsodi

Friday 11 April 2003 7:00:26 am

The only way to this at the moment is to create custom template SQLs for the fetching and either put in a custom template operator or template fetch function.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq