Hi Team,
Is there any option to create a child relation between different data types like Decimal & String by converting decimal value to string value.
TASK.TASK_ID is Decimal & METRIX_AUDIT.KEY_COL_VALUE01 is String 256
Userlevel 7
+22
Hi
I’m not quite sure whether this is possible to match the relationships with two different data types for the primary keys or foreign keys, in which needs to be in the same data type according to the basic principals
+1
The relationships that exist between attributes rely on the parent-child specifications that you assign to attributes. How attributes relate to one another and the types of relationships they share define the system hierarchy which is used to generate SQL. This SQL, in turn, determines the output of a njmcdirect report.
Hi
Child relations \ join constraints must be based on columns sharing the same data type.
In your case I would recommend to create \ setup a custom view which takes responsibility of the casting so you can join it on the task screen accordingly.
Cheers,
Ruben
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.