Hi everyone,
I need to visualize in the end user devices classes 2 new fields.
I know how to create them, I've done this before, but this time I need to populate the fields with data from a custom table I've created in mysql (which is populated with data from another db on another server).
The fields should be one AttributeString and the other one a dropdown select which shows data based on the input in the first field.
I don't know how to configure these fields to retrieve data from the db table with queries.
Can someone help me?
Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello Madalina,
This is not the way to do, you cannot use a custom table to populate part of an iTop object directly.
The best is to populate those fields through an iTop DataSynchro. You can populate your data from the other server and synchronize them on a daily basis. Read all this carefully as there are multiple ways of doing this, including using a Collector
Last edit: Vincent @ Combodo 2022-02-17
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi everyone,
I need to visualize in the end user devices classes 2 new fields.
I know how to create them, I've done this before, but this time I need to populate the fields with data from a custom table I've created in mysql (which is populated with data from another db on another server).
The fields should be one AttributeString and the other one a dropdown select which shows data based on the input in the first field.
I don't know how to configure these fields to retrieve data from the db table with queries.
Can someone help me?
Thanks in advance.
Hello Madalina,
This is not the way to do, you cannot use a custom table to populate part of an iTop object directly.
The best is to populate those fields through an iTop DataSynchro. You can populate your data from the other server and synchronize them on a daily basis. Read all this carefully as there are multiple ways of doing this, including using a Collector
Last edit: Vincent @ Combodo 2022-02-17