I have assigned multiple categories to documents. - a main category and one or more additional categories.
Main categories like Technical documents, User manuals, white papers etc.
The documents are then assigned to a different category, connecting them to differnt apps.
The in-syntax use in Edocman Documents only allows for a series of values (which qualifies 1 or 2 or 3 or.....)
What I need are different lists for different categories - mixed and-or Logic, that would make it possible to build up lists like
- all Tech docs for app a
- all Tech docs for apps a,b,d,
- all Tech docs for all apps
-all docs for app a
etc..
Since the module uses straight forward SQL to retrieve the documents, it should be easy to replace todays ... IN (cat,cat2....) With a statement that can retrieve documents that is connected to ALL categories listed as well as ANY, depending on whether ALL or ANY has been checked..
Today I have to insert an unnecessarily arduous sql-statement in the categories-field in Edocman Documents Module.
