Skip to main content
Question

FSM : UI Designer : Child Relation Editor


Forum|alt.badge.img+15

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

 

3 replies

Saranga Amaraweera
Superhero
Forum|alt.badge.img+22

Hi @CKOppBox ,

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


Forum|alt.badge.img+1
  • Do Gooder
  • 1 reply
  • June 2, 2022

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.

 


Forum|alt.badge.img+13
  • Hero (Employee)
  • 124 replies
  • June 7, 2022

Hi @CKOppBox , 

 

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings