Search on multiple categories?

[OKCTalk]

I know you can assign multiple categories to any one wiki article but can you create an index and/or search on more than one category?

For example, I can show a complete index of everything within a category I have labeled OFFICE BUILDINGS but what if I wanted to create a list of OFFICE BUILDINGS that are also in the DOWNTOWN category?

If the software does not have this functionality is there a way to write a custom script query?


TIA.

[OKCTalk]

Bump for answer please.

[pegasus]

VaultWiki doesn't have an automatic function to search on two categories at once. You would need to get the thread IDs of the categories you want to use as category IDs. Then search vault_category for rows that share a threadid and have both categoryid values. For this kind of search, you might join the vault_category table to itself, which makes this kind of search impractical from a coding standpoint and dangerous from a performance standpoint. A safer method would be to recursively get the lists of pages in each category ID and cross reference them during each step until no category IDs are left to check. This increases the number of queries but, if done with efficiency in mind, should funnel down the number of results per query, rather than a same-table join which could attempt to process millions of rows at the same time. However, the first query could still have many thousands of results, and could become problematic on very large wikis.