I have a question regarding Custom Properties in FNMS.
When you create drop-down list custom property (UIFieldTypeID = 😎 is it possible to define dynamic query to return selectable values? Or it is only possible to store static list of values?
The only documented way I could find was static list, explained in System Reference PDF. But if I look at [dbo].[UIItem_MT] table I can see that available fields might support more complex solution, as I can see FromTable, SelectName, WhereClause columns, just not sure what the purpose of those?
Mar 26, 2020 02:43 AM
Mar 26, 2020 06:04 AM
I found this topic, because I was actually look for what you suggested.
How can I identify the static list where values from custom drop down are listed? And then update it.
It would actually make sense for me to never change that list so it could potentially be very useful for the client.
Apr 21, 2020 01:44 PM
The static list of values available for a drop-down list custom property is specified in the @DataSource parameter value when calling the AddPropertyToWebUIPropertiesPage stored procedure to configure the custom property. For example:
EXEC dbo.AddPropertyToWebUIPropertiesPage @TargetTypeID = 9, /* asset */ @ExcludeTargetSubTypeIDs = '', @Name = 'CustomAssetEnvironment', @DisplayNameInPage = 'Asset Environment:', @DisplayNameInReport = 'Asset Environment', @UIFieldTypeID = 8, /* drop-down list */ @DataSource = ',Production,Testing,Training'
To see the list of values configured for a property that is already defined, the easiest approach is probably to open a record of the appropriate type in the UI and look at the values that are shown to the end user in the drop-down list.
Apr 21, 2020 11:12 PM
Apr 22, 2020 04:11 AM
Apr 22, 2020 05:46 AM