Skip to main content
Question

How to Join Alias ​​Table with other tables in Using Columns of Extension Table for which the alias is created?

  • September 15, 2022
  • 3 replies
  • 92 views

Forum|alt.badge.img+2

Hi All,

We have created an extension table for PART_NEED table as PART_NEED_EXT, for just populating the existing data from Part_Need table we created an alias table for the same, but we need to define a child relation in UI Designer with the Part_Need alias using a field of PART_NEED_EXT table.

Our major challenge is to bring the columns of PART_NEED_EXT table to the alias table to define a child relation.

Please suggest any solution for the same.

 

Thanks in Advance!

 

 

3 replies

Lee Pinchbeck
Ultimate Hero
Forum|alt.badge.img+24
  • Ultimate Hero
  • September 15, 2022

Hi @Shubham Mane ,

Can you advise what exactly the aim is here? What are you trying to display on the screen and why does this require an extension?

Kind regards,

Lee Pinchbeck


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • September 16, 2022

Hi Lee,

Thanks for your response.

 

We want to store an additional Task_ID in Part_Need table but there is no User_Def column available in Part_Need to store that, so due to this reason we have created an extension table for Part_Need. And, in that extension table’s column we are storing that task_id, and that Task_ID we want to display inside a tab on the screen, we only want to display the existing Part_Need data under that tab, so in order to do that we have created an alias table of Part_Need in custom metadata, but in that alias table we are not getting the fields of Part_Need Extension table.

So our goal is to bring the columns of the Part_Need Extension table into the alias table of Part_Need, so that we can utilize the same to display it inside the tab on the screen.

 

Regards,

Shubham Mane


Lee Pinchbeck
Ultimate Hero
Forum|alt.badge.img+24
  • Ultimate Hero
  • September 16, 2022

Hi @Shubham Mane ,

It may assist if you provided screenshots of the setup you have already done to achieve this.

Kind regards,

Lee Pinchbeck