Enabling the Extended Attributes Tab of the Application View

AdminStudio 2023 | 25.0 | Application Manager

To enable the Extended Attributes tab of the Application View, you need to open a provided sample ApplicationExtendedAttributes.SQL script file, edit that script file to define your application attributes, and then run that SQL script on your Application Catalog.

After you edit and run the SQL script named ApplicationExtendedAttributes.SQL script, the extended attributes that you have defined are listed on the Extended Attributes tab of the Application View

Important:The Extended Attributes tab will only be visible for applications imported into the Application Catalog after the ApplicationExtendedAttributes.SQL script is run.

To enable the Extended Attributes tab of the Application View:

Create a new Application Catalog.

Important:You can also run this script on an existing Application Catalog that already contains applications, but the Extended Attributes tab will not be visible for those existing applications; it will only be visible for applications imported after the script is run.

Open Microsoft SQL Server Management Studio and connect to your database server.

Open the following file:

[AdminStudio_Installation_Directory]\Support\SQL_Scripts\ApplicationExtendedAttributes.SQL

You will see the following sample query (in comment form):

For each extended attribute that you want to define in the ApplicationExtendedAttributes.SQL script, copy the following three lines of code (without the leading hyphens):

insert into ASCMExtendedAttribute

([Name],[DisplayText],[HelpText],[Type],[Values],[DefaultFileExtension],[FileFilter],
[DefaultValue],[OptimisticLockField],[GCRecord]) values

('Name','DisplayText','HelpText','Text','Values','DefaultFileExtension','FileFilter',
'DefaultValue',0,NULL)

Note the following regarding this code:

•

Table name—The first line of code (insert into ASCMExtendedAttribute) identifies the table in the Application Catalog that you are editing.

Important:Do not edit this line of code.

•

Column names—The second line of code—which starts with ([Name],[DisplayText], etc.—lists the columns in the table that need to be defined for each extended attribute.

Important:Do not edit this line of code.

•

Defining the attribute—The third line of code—which starts with ('Name','DisplayText', etc.—defines the extended attribute. You will need to replace each of the default values in this line of code with the value appropriate for the extended attribute you are defining. Each value is separated by a comma.

Important:Do not delete any of the quote marks or commas from this line of code. If you do not want to define a value for a column, enter NULL or just leave a space between the quote marks.

Define each attribute, as described in Defining Application Extended Attributes.

Under the list of attribute definitions, enter the command GO.

From the drop-down list in the toolbar, select the name of the Application Catalog you want to create these extended attributes in.

Click the Execute button in the toolbar.

In Application Manager, import an application and then open the Application View. A new Extended Attributes tab should now be displayed, listing the attributes you defined in the SQL file.