Skip to main content
Solved

Is self joining possible in RDM tables ?

O
Star Blazer L1
Forum|alt.badge.img+4

Hello,

Is it possible to self-join tables in RDM to populate some information? I would like to try something like shown in the screenshot. Attribute 4 and 5 values are selected from RDM UI. So, dropdown should only show values from the same table where att2 = CAT2 for Att4 and att2 = CAT3 for Att4

Table1          
      Selection from RDM UI  
Att1 Att2  Att3 Att4 (where att2 = CAT2) Att5 (where att2 = CAT3)  
ID1 CAT1 val1 ID3 ID5  
ID2 CAT1 val2 ID4 ID6  
ID3 CAT2 val3      
ID4 CAT2 val4      
ID5 CAT3 val5      
ID6 CAT3 val6      
           

 

I somehow tried to create self join in relationship like below. I was able toi upload configuration successfully on RDM with these relationships. 

 

However, when edit the record on RDM the lookup is blank. it does not show any value although table is populated.

 

  (this can also be understood as employee info vs manager info relationship. Both info are available in the employee table)

Thanks in advance.

Ojaswini

Best answer by may_kwok

You likely need to set the display mode for Att1 to “label”.

 

Setting the display mode to “label” allows that attribute to be chosen by a child column in the combo box.

Your drop down box looks empty, but it’s actually got all the rows in your table “underneath” it. There likely was no columns set as “label”, and therefore the combo box doesn’t know which column to put as display.

Have a go and see if that works?

Link to the official documentation is here.

 

 

View original

may_kwok
Star Blazer L3
Forum|alt.badge.img+4
  • may_kwokStar Blazer L3
  • Star Blazer L3
  • May 28, 2025

You likely need to set the display mode for Att1 to “label”.

 

Setting the display mode to “label” allows that attribute to be chosen by a child column in the combo box.

Your drop down box looks empty, but it’s actually got all the rows in your table “underneath” it. There likely was no columns set as “label”, and therefore the combo box doesn’t know which column to put as display.

Have a go and see if that works?

Link to the official documentation is here.

 

 

O
1 person likes this
  • O
    Ojaswini
O
Star Blazer L1
Forum|alt.badge.img+4
  • OjaswiniStar Blazer L1
  • Star Blazer L1
  • June 3, 2025

Thank you very much. Yes, ID was set as Normal. Thank you. Oops. I didn't even notice that. 

Best regards,

Ojaswini

Reply


Community Terms of Use & ConditionsCookie settings

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