CUSTOM PROPERTY FIELD - SQL QUERY

spyfly

Is there anyway to use an sql query to populate a drop down list for a custom property field?

Basically we want to create custom properties fields and use them for interfaces with circuit IDs
we would have these custom properties

Circuit ID - manually text entered
LATA - manually created down list
Service Provider - manually created down list
Service Type - manually created down list
Owner - manually text entered
Near End Device - this would be an sql query to list all devices (router nodes) * these would pull from the Nodes Table
Near End IP - manually text entered
Near End Interface - this would be a sql query based on the select device above and have the query list all interfaces from said Near End Device
Far End Device - this would be an sql query to list all devices (router nodes)
Far End IP - manually text entered
Far End Interface -   this would be a sql query based on the select device above and have the query list all interfaces from said Far End Device

I have a feeling this can not be done but I am hoping that it could or it would be a really neat feature request

Thanks in advance

mesverrum

This process could be managed through an interaction with the API, but the default UI wouldn't have this capability.

I can definitely see how I could do this in powershell since thats how I usually interact with the API.  Basically build a little scripted "interface Property filler" with prompts like "enter CID", ..., "Choose Near Router from this list" and have it display a list of the router nodes for them to pick from.  If I was any good in VB you could even wrap it up all in a little UI.