topic Re: Search for range of numbers on a form in Alfresco Archive

Search for range of numbers on a form

d_franz — Mon, 26 Nov 2012 09:46:26 GMT

I have created a form for my individual Aspect. In this Aspect I have created some number fields ("<type>d:int</type>").Now I want to search for this fields on a range based way. But command such as "0..5" or "[0 TO 5]" doesn't work.Is there anything I have to configure or to install to

Re: Search for range of numbers on a form

jpotts — Wed, 28 Nov 2012 17:24:59 GMT

Can you be more specific about which search syntax you are trying to use, where you are trying to execute the search, and the specific query you are executing?

Just to give you something to compare to, when I drop a bunch of images into the Share document library, I can then successfully find them in the Node Browser using this Alfresco FTS query:

@exif\:pixelYDimension:[200 to 900]‍

The exifixelYDimension property is defined as type d:int on the exif:exif aspect.

See http://wiki.alfresco.com/wiki/Full_Text_Search_Query_Syntax#Ranges for more examples.

Jeff

Re: Search for range of numbers on a form

d_franz — Fri, 23 Aug 2013 11:32:28 GMT

I have a form to search that is similar to my forms for putting in all meta data. If I search for the exact values I putted in I can find everything.
But for the most files I want search them with a range.
For example I have a field where I put in a Temperature. Now I want to search for a Temperature range from 10 to 20 degrees to find for example a file with the applied temperature of 15 degrees.

My search form looks like this:
http://s21.postimg.org/4a7tn14qv/Unbenannt.png

How I have to define the search string in this fields to get result?
I want so search for number and date ranges.

Thanks in advance

Re: Search for range of numbers on a form

d_franz — Mon, 02 Sep 2013 07:31:31 GMT

Is it possible to define a field in a search form to search a time window on a meta-data propertiy of type "d:datetime"??

Many thanks in advance!

Re: Search for range of numbers on a form

rjohnson — Mon, 02 Sep 2013 08:53:46 GMT

There is a form control called daterange.ftl that will allow you to do this.

Re: Search for range of numbers on a form

d_franz — Mon, 02 Sep 2013 10:57:08 GMT

Thank You very much!!! That exactly what I was looking for.