Forums / Setup & design / More Specific Fetching

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

More Specific Fetching

Previous topic

Setup & design

Next topic

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

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