0_marius asked a question.
Values for drop-down list custom property
Hi,
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?
Marius
If you wanted to have a dynamic list of values where the list doesn't change too often and you are using FlexNet Manager Suite On-premises (not Cloud), then you could possibly look at putting some regular process in place to update the static list that is configured in the database. However it would be important to ensure that once a value is added to the list it is never removed - if a value in the list is used on a record but subsequently removed then things could get messy.Hi Chris,
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.
Kind regards,
Jan
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:
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.
Hi,
you can find values in FNMS compliance table UIItem_MT. Check DataSource column.
Marius
If I would like to add a new value to the drop down then I can just edit XML from DataSource column?
However the UIItem table is not one that I would normally recommend changing directly except in extreme situations. Do so at your own risk. It would be better form and style to make a change like this by re-executing the AddPropertyToWebUIPropertiesPage stored procedure to re-configure the custom property, specifying the new set of values you want for the drop-down list in the @DataSource parameter. This does depend on you having a copy of the SQL script that was used to configure the custom property in the first place, which hopefully you have as part of the configuration details associated with your installation.
New values were added to the drop down menu and records where we used previously existing values remain unchanged.
Thank you!Hi ChrisG
What you mean I can rerun the SQL script using "EXEC dbo.AddPropertyToWebUIPropertiesPage" with the new set of values I want for the drop-down list in the @DataSource parameter. After that, I have to run "EXEC dbo.CustomPropertyUpdateDisplayName" to update it. This will not cause any impact to current Asset data with this custom properties. Correct?
Thanks