topic Re: How to create a field that is searchable by giving a range in Alfresco Forum

How to create a field that is searchable by giving a range

hiten_rastogi1 — Thu, 13 Apr 2017 05:40:08 GMT

Hi,I have three fields that contains values for the tenure of a contract, e.g. custom:tenureYear=5, custom:tenureMonth=11 and custom:tenureDays=3, these fields are simple text, non editable and are calculated through a behavior.I want that in the adv. search form I can have three other fields in whi

Re: How to create a field that is searchable by giving a range

afaust — Thu, 13 Apr 2017 15:52:52 GMT

Configure the search form to use the numberrange.ftl form control template for the fields you need. I would also adivse you to change the data model to use d:int instead of d:text for these properties, otherwise the sorting of the field values may not be correct and you might end with incorrect results of range queries too.

Re: How to create a field that is searchable by giving a range

hiten_rastogi1 — Mon, 17 Apr 2017 10:05:47 GMT

Thanks Axel,

I will give this a try.

Re: How to create a field that is searchable by giving a range

andy1 — Fri, 15 Sep 2017 09:16:10 GMT

It is easy to fall into the trap of describing why your solution does not work and skip the problem ....

Is the route cause that we do not index duration very well? I assume that the start and end dates for the contract are not enough and you want something that also includes the contract length. One way to do duration is simply with numeric fields for days etc described. You can probably abuse date relative to some fixed point in the past and then use SOLR date math in your queries for duration - with easy rounding and date math. You would have to do some query building.

Andy

Re: How to create a field that is searchable by giving a range

hiten_rastogi1 — Fri, 15 Sep 2017 10:16:31 GMT

Thanks Andy for you input. I was able to overcome the challenge by using number range ftl as described by Axel above.