topic Re: FTS-Alfresco search query with text range in Alfresco Forum

FTS-Alfresco search query with text range

woong — Mon, 12 Mar 2018 00:56:43 GMT

Hello,I have a question that using Alfresco Full Text Search.There are some example.In the text field of file,"..... point A = 11 ..... point B = 15 ....."I want to query for range search like,"point A should greater than 10 & point A should less than 12 & point B should greater than 14 &

Re: FTS-Alfresco search query with text range

andy1 — Mon, 19 Mar 2018 15:34:27 GMT

It is possible to do range on text but is probably does not do what you want. Text is lexicologically ordered - even if the text is numeric. Tokensied fields also give unexpected behaviour from the highest or lowest value. As your text is numeric, I do not think you will get what you expect.

Andy

Re: FTS-Alfresco search query with text range

woong — Thu, 22 Mar 2018 00:34:10 GMT

Thanks Andy

I could not resolve through this idea.

So I designed new model has numeric fields.

Thank you.

Woong