Advanced Lucene Search

[tpod2]

So the problem we are tackling is

L1
    L2
        L3
           I1
              P1, P2, P3, P4 etc.
          I2
              P1, P2, P3, P4 etc.

Where L1, L2, L3 are all folders and I1 in an image (instance) and P1, P2 P3 etc are all aspects.

We are looking for a result set of all L3  where I* has some P1 = value.. So for example return all folders that contain images where the P1 has the word “Large” in it. We tried with Categories and were not able to get much back.

Thanks

[pmonks]

I suspect this can't be expressed solely in Lucene (it's not as powerful a query language as SQL), but it could be implemented via a combination of Lucene (to find all images where P1="Large") and direct repository traversal (to find the parent folders of the set of images returned by the Lucene query).

Provided this is done in-process (eg. in a Web Script) this should be pretty performant, despite requiring N + 1 atomic operations (1 for the Lucene query + N for the directory lookups).

Cheers,
Peter