Page 1 of 1

Advanced searching

PostPosted:Thu Jan 27, 2022 11:02 am
by polandia12
Hallo everyone!

Community version 6.3 CE

I already know that we have option what allows us to search advance but.... is it possible to make it better?

For example I want to search folder name and second folder what is in next folder. Lets say structure is like it:

Folder1 -> Folder2 -> Folder3

I would like to search the file what is in Folder2 i know for exmaple the full name of first one(Folder1) and part of name from the second one(Folder2). We have quiet big structure of folders and a lot of documents inside what I noticed is that is no problem to search something with one argument like Folder1 but problem is when we want to search something using two.

Why is so importent for us? I can search for exaple in first folder type of thing like some metal and in second height or wide of this metal.

Re: Advanced searching

PostPosted:Sat Jan 29, 2022 10:36 am
by jllort
This kind of query can not be done from Lucene Search Engine ( explanation is large, but basically for it, the DMS should have calculated always the path of a node and this is a bad idea because performance, a node in the search engine do not have the current path indexed ). This is so much specific and should be used standard SQL for this purpose.