A new Flexera Community experience is coming on November 18th, click here for more information.
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
Oct 29, 2024 11:36 AM
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.
Oct 30, 2024 06:19 PM
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.
Oct 30, 2024 06:19 PM
User | Count |
---|---|
8 | |
7 | |
3 | |
3 |