Applications

GUI

table application.category as "Category" from "/" where application != null and application.gui = true sort application.category

CLI

table application.category as "Category" from "/" where application != null and application.cli = true sort application.category

HTTP based Applications

table application.category as "Category" from "/" where application != null and application.http = true sort application.category

Other 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.category

todo : cleanup categories