I have 2 indexes that I am joining and I am getting different results based on whether I start the search with one index vs the other. The join is a one to many relationship
Indexes
- filemeta (1)
- fileacl (*)
Query 1 - 1 Result
index="filemeta" Path="\\server\testshare" | join "Path" [ search index="fileacl" ]
Query 2 - 6 results
index="fileacl" Path="\\server\testshare" | join "Path" [ search index="filemeta" ]
Am I missing something on Query 1 in order to see all the results from the fileacl index?
... View more