When I search with "D:>flow", the generated query is SELECT TOP 100 "System.FileName", "System.ItemUrl", "System.ItemType", "System.ItemPathDisplay" FROM "SystemIndex" WHERE (Scope = 'file:D:/' OR CONTAINS(System.FileName,'"D:\"',2052)) AND System.FileName > 'flow' AND scope='file:', which doesn't give me the correct result I want.
I don't understand why we use System.FileName > flow as condition instead of CONTAINS(System.FileName, "flow"), and the extra `scope='file:'" is redundent.
Also, we should also make the folder result appears earlier similar to the search without index.