Applications
GUI
table application.category as "Category" from "/" where application != null and application.gui = true sort application.categoryCLI
table application.category as "Category" from "/" where application != null and application.cli = true sort application.categoryHTTP based Applications
table application.category as "Category" from "/" where application != null and application.http = true sort application.categoryOther Applications
table application.category from "/" where application != null and (application.gui = false or application.gui = null) and (application.cli = false or application.cli = null) and (application.http = false or application.http = null) sort application.categorytodo : cleanup categories