I need to create folder tree structure, but only for the folder which actually contains searched items, not the whole hierarchy. Is there any way to do it?
1. I have created Dynamic list with custom query
2. I have created Form ListTree item for that query
3. The ListTree item shows only Folders
4. I need to present only Folder Hierarchy for the items which represent query result with LIKE condition.
Code |
---|
QueryText = "SELECT | Nomenclatura.Ref AS Ref, | Nomenclatura.IsFolder AS IsFolder, | Nomenclatura.Description |FROM | Catalog.Nomenclatura AS Nomenclatura |WHERE | Nomenclatura.Description LIKE &SearchString"; |