+1Does anyone know of an Entity Relationship Diagram for IFS Cloud?
What I am trying to do is link between RentalObject and the EquipmentSerial entities and CustomerOrder.
I need to add a read-only field to RentalObject that returns the Serial Number of the Rented Object.
Any idea if this is possible?
Best answer by Mathias Dahl
Hi Rob,
There is no single ERD in IFS. We have a number of separate ones but they are neither complete nor published in an easy manner (you need IFS Developer Studio, our main developer tool, to see them).
The information is right there under your fingertips though, in the database :)
How to find all columns/attributes in an entity:
SELECT column_name
FROM Dictionary_Sys_View_Column
WHERE lu_name = 'DocTitle'
How to find references from an entity to other entities:
SELECT column_reference
FROM Dictionary_Sys_View_Column
WHERE lu_name = 'DocTitle'
Armed with this, you should be able to query the database for the information you need. If you are using Cloud Deployment you can create one or a few quick reports to extract the same information.
Good luck!
+32Hi Rob,
There is no single ERD in IFS. We have a number of separate ones but they are neither complete nor published in an easy manner (you need IFS Developer Studio, our main developer tool, to see them).
The information is right there under your fingertips though, in the database :)
How to find all columns/attributes in an entity:
SELECT column_name
FROM Dictionary_Sys_View_Column
WHERE lu_name = 'DocTitle'
How to find references from an entity to other entities:
SELECT column_reference
FROM Dictionary_Sys_View_Column
WHERE lu_name = 'DocTitle'
Armed with this, you should be able to query the database for the information you need. If you are using Cloud Deployment you can create one or a few quick reports to extract the same information.
Good luck!
Ok, but is there somehow a way to see dependencies?
Eg. in order to add a customer, what tables does it depend on?
Does something like that exists? That would be of great help for data migration and other topics.
+32Ok, but is there somehow a way to see dependencies?
Eg. in order to add a customer, what tables does it depend on?
Does something like that exists? That would be of great help for data migration and other topics.
Check my last query above for the LU CustomerInfo, and combine with this condition:
AND required_flag = 'M'
Then you will find what entities a customer references and which are mandatory.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
