Forums / Suggestions / fetch image and filter

"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".

fetch image and filter

Previous topic

Suggestions

Next topic

Author	Message
stephane couzinier	Saturday 23 December 2006 1:58:50 am It will be use full to filter/sort image by ratio (width/height) Actually the width and height are store on a XML fields, but there is no way to make a fast SQL query. With a photo Gallery , sometime I need to find the first image with a ratio greater than 1 another I need to display an image width a ratio less than 1. To resolve this pb: - I create a new table ( i store the id,width,height,ratio of all images) - Every time a image is upload, I update my table - I add a new extended attribute filter to get images by ratio It's work, but It's will be better for me ;-) to have this on ez don't flush the cache
alan robert	Monday 02 April 2007 9:07:17 am This is good idea, I just need something like this, but I don't use sort image by ratio, I need use table to control image for another using. do you can provide your code or demo in somewhere? Thanks in advance. http://www.softsea.com/
Janet Kellman	Sunday 08 July 2007 3:20:13 am alan robert, I also need something like this. can you write code example for using ? thanks! http://rbytes.net/software/

Author

Message

stephane couzinier

Saturday 23 December 2006 1:58:50 am

It will be use full to filter/sort image by ratio (width/height)
Actually the width and height are store on a XML fields, but there is no way to make a fast SQL query.

With a photo Gallery , sometime I need to find the first image with a ratio greater than 1 another I need to display an image width a ratio less than 1.

To resolve this pb:
- I create a new table ( i store the id,width,height,ratio of all images)
- Every time a image is upload, I update my table
- I add a new extended attribute filter to get images by ratio

It's work, but It's will be better for me ;-) to have this on ez

don't flush the cache

alan robert

Monday 02 April 2007 9:07:17 am

This is good idea, I just need something like this,
but I don't use sort image by ratio, I need use table to control image for another using.

do you can provide your code or demo in somewhere?

Thanks in advance.

http://www.softsea.com/

Janet Kellman

Sunday 08 July 2007 3:20:13 am

alan robert, I also need something like this. can you write code example for using ?
thanks!

http://rbytes.net/software/