The Application table contains applications that are available for deployment to users.

Column	Type	Description
Name	LocalizedString	Application name.
DisplayName	LocalizedString	Application display name.
Icon	String	Path of application icon image.
Description	LocalizedString	Application description.
Handler	String	Application handler.
TemplateName	String	Application template name.
AppType	String	Application type.
AppTypeDisplayName	String	Display name of application type.
WebAppType	String	Application web-app-type.
WebAppTypeDisplayName	String	Display name of application web-app-type.
State	String	Application state.
IsTestApp	Boolean	Whether this application is for testing only.
CorpIdentifier	String	An additional field required for login. For example, Company ID, organization code, sub-domain of a login URL, etc.
Brand	String	A specific brand name that this application is made for.
NotSelfService	Boolean	Whether this application must be configured by a Cloud Admin.
Generic	Boolean	Whether this application is implemented using a generic application template.
OnPrem	Boolean	Whether this application can be hosted on-premise.
IsGatewayed	Boolean	Whether this application is using App Gateway.
ShadowAppLink	String	Rowkey for this Gateway Shadow SAML application.
Featured	Boolean	Whether this application is featured.
Popular	Boolean	Whether this application is popular.
Category	LocalizedString	Category of this application.
Admintag	String	Application admin tag.
MobileAppSource	String	Source of this mobile application. For example, "App Store", "InHouse", "Unknown".
MobileAppType	String	Mobile application type. Target platform of this mobile application. For example, "Android", "Ios", "OSX", "Unknown".
Version	String	Version of this application.
VersionName	String	Version name or information of this application. For example, "5.1.0" or "Varies with device".
IsMarketplaceApp	Boolean	Whether this application comes from Samsung Knox Marketplace.
ProvCapable	Boolean	Whether this application is capable of User Provisioning.
ProvSettingEnabled	Boolean	Whether User Provisioning is enabled on this application.
ProvSettingPreview	Boolean	Whether User Provisioning is in Preview Mode.
ProvConfigured	Boolean	Whether User Provisioning has been configured.

Example Query

The following query searches for entries with 'test' in the name.

{Script: "Select * FROM Application 
    WHERE Name LIKE '%test%' 
    ORDER BY State COLLATE NOCASE"}

The query displays the following entries in the Application table, ordered by State.

Application table query response:

"Success": true,
"Result":
{
...
"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "Application",
        "Key": "********-****-****-****-**************",
        "IsForeignKey": false
      }
    ],
    "Row": {
      "Featured": null,
      "ProvSettingPreview": null,
      "Category": "Social Media",
      "Name": "Test Facebook",
      "MobileAppType": null,
      "DisplayName": "Facebook",
       "AppTypeDisplayName": "Web - User Password",
      "OnPrem": null,
      "ID": "********-****-****-****-**************",
      "ShadowAppLink": null,
      "Description": "Facebook is a social utility that connects people with friends
                     and others who work, study and live around them.",
      "ProvConfigured": null,
      "Version": null,
      "IsGatewayed": null,
      "Generic": false,
      "CorpIdentifier": null,
      "MobileAppSource": null,
      "Brand": null,
      "AppType": "Web",
      "Icon": "/vfslow/lib/application/icons/facebook",
      "WebAppTypeDisplayName": "User Password",
      "IsTestApp": null,
      "WebAppType": "UsernamePassword",
      "ProvSettingEnabled": null,
      "TemplateName": "Facebook",
      "Admintag": "Social Media",
      "IsMarketplaceApp": null,
      "Handler": "cloudlib;Idaptive.Saas.apphandlers.BrowserExtensionHandler",
      "State": "Active",
      "NotSelfService": null,
      "_MatchFilter": null,
      "VersionName": null,
      "Popular": null,
      "ProvCapable": null
    }
  },
  {
    "Entities": [
      {
         "Type": "Application",
        "Key": "********-****-****-****-**************",
        "IsForeignKey": false
       }
    ],
    "Row": {
      "Featured": null,
      "ProvSettingPreview": null,
      "Category": "Design",
      "Name": "TEST Cageapp",
      "MobileAppType": null,
      "DisplayName": "Cageapp",
      "AppTypeDisplayName": "Web - User Password",
      "OnPrem": null,
      "ID": "********-****-****-****-**************",
       "ShadowAppLink": null,
      "Description": "Collaboration just got a whole lot easier. A simple way for designers and teams to share, manage and approve their creative work.",
       "ProvConfigured": null,
      "Version": null,
      "IsGatewayed": null,
      "Generic": false,
      "CorpIdentifier": "",
      "MobileAppSource": null,
      "Brand": null,
      "AppType": "Web",
      "Icon": "/vfslow/lib/Application/Icons/cageapp",
      "WebAppTypeDisplayName": "User Password",
      "IsTestApp": null,
      "WebAppType": "UsernamePassword",
      "ProvSettingEnabled": null,
      "TemplateName": "Cageapp",
      "Admintag": "Software Development",
      "IsMarketplaceApp": null,
       "Handler": "cloudlib;Idaptive.Saas.apphandlers.UserPass",
      "State": "Active",
      "NotSelfService": null,
      "_MatchFilter": null,
      "VersionName": null,
      "Popular": null,
      "ProvCapable": null
    }
  }
}