We have a lot of networks areas with IP addr from/to. So I create a class for that. Additionally to this, we have networks with IP addresses inside this areas - a second class. This IP addr has a reference to a device - a third class. If the user add a new network card, the user select a network area and should only select a free IP address from the selected IP addr area.
Because of this handling, the network IP has a reference to the IP network area. The real IP addr should be a dynamic lookup, created always new, depending on the selected IP network area. Until now I think it is not possible to setup such a situation with the GUI.
How can I generate dynamic lookups for general? And more special. how can I use such dynamic lookup just in time while the user changing the value of a select box (at least a reference)?
More general, how can I use user events (like "on select" or "on change") to modify the card dialog?
In general in CMDBuild you can get into “Reference” fields value lists dynamically filtered, using the “Filter” field available in the attribute definition and specifying an CQL condition. But in this case the free IP values are not on CMDBuild cards, so you can not use a “Reference” field (similar to foreign key). To solve your problem you can configure a wizard with the workflow mechanism, unfortunately more complicated to implement than the definition of a filter. CMDBuild Team
First of all, I create a new class for all free IPs. Than I wrote a first trigger function to fill this class initially. The next steps are wrote some other trigger functions to select / delete / create single free IPs from/into the class depending of the users usage and build a reference to the free IPs instead to use an inet attribute.
So with this it could be work - I hope.
Volker
PS
Is it possible to connect a different postgres database inside of an postgres function? My own CMD using postgres and it would by very helpful for an upload.