A new Flexera Community experience is coming on November 18th, click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Custom Drop Down

Hi,

I want to add a drop down in a custom field. Can you please help me what exact query to use.

I have referred the below doc but still i am confused. to https://docs.flexera.com/FlexNetManagerSuite2020R1/EN/SystemRef/index.html#SysRef/CustomProperties/tasks/CP-Customizing-DropDown-Lists.html 

(1) Solution

Hi Sweta,

The documentation that your link points to is referring to customizing the options available in a standard FNMS dropdown field, like if you want to create a custom 'Asset Type' or an additional title available for users in the 'Identification' section of the user form.

The options available on a custom field of type 'Drop-down list' (UIFieldTypeID = 8 ) must be specified at creation time.

As an example, the following SQL statement uses the AddPropertyToWebUIPropertiesPage procedure for adding a custom drop-down to the FNMS 'Application' object:

EXEC dbo.AddPropertyToWebUIPropertiesPage
        @TargetTypeID            =  13,			        -- Application (SoftwareTitle)
        @Name                    =  'Fld_Application_Exception',
        @CultureType             =  'en-US',
        @DisplayNameInPage       =  'Application Exception',
        @DisplayNameInReport     =  'Application Exception',
        @TabName                 =  'General',
        @UIInsertTypeID          =  2,               -- AFTER anchor
        @UIFieldTypeID           =  8,               -- Drop-down list
        @RelativePositionTo      =  'Status',
        @SequenceNumber          =  100,
        @Position                =  1,
        @Width                   =  1,
        @DataSource              =  'plug-ins, language packs, fonts',
        @DataSourceDelimiter     =  ',',
        @Required                =  0,
        @StringLength            =  255

The three options available in the drop-down (plug-ins, language packs, fonts) are specified in the '@DataSource' parameter.

Options are seperated using a comma (you can change the delimiter in the @DataSourceDelimiter parameter).

It is possible to update options in custom dropdown fields after creating the fields.
However, this is a bit more involved. Look at the [UIItem] table in the [FNMSCompliance] database.

View solution in original post

(1) Reply

Hi Sweta,

The documentation that your link points to is referring to customizing the options available in a standard FNMS dropdown field, like if you want to create a custom 'Asset Type' or an additional title available for users in the 'Identification' section of the user form.

The options available on a custom field of type 'Drop-down list' (UIFieldTypeID = 8 ) must be specified at creation time.

As an example, the following SQL statement uses the AddPropertyToWebUIPropertiesPage procedure for adding a custom drop-down to the FNMS 'Application' object:

EXEC dbo.AddPropertyToWebUIPropertiesPage
        @TargetTypeID            =  13,			        -- Application (SoftwareTitle)
        @Name                    =  'Fld_Application_Exception',
        @CultureType             =  'en-US',
        @DisplayNameInPage       =  'Application Exception',
        @DisplayNameInReport     =  'Application Exception',
        @TabName                 =  'General',
        @UIInsertTypeID          =  2,               -- AFTER anchor
        @UIFieldTypeID           =  8,               -- Drop-down list
        @RelativePositionTo      =  'Status',
        @SequenceNumber          =  100,
        @Position                =  1,
        @Width                   =  1,
        @DataSource              =  'plug-ins, language packs, fonts',
        @DataSourceDelimiter     =  ',',
        @Required                =  0,
        @StringLength            =  255

The three options available in the drop-down (plug-ins, language packs, fonts) are specified in the '@DataSource' parameter.

Options are seperated using a comma (you can change the delimiter in the @DataSourceDelimiter parameter).

It is possible to update options in custom dropdown fields after creating the fields.
However, this is a bit more involved. Look at the [UIItem] table in the [FNMSCompliance] database.