Question

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

  • 15 September 2022
  • 3 replies
  • 73 views

Badge +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

Userlevel 7
Badge +24

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

Badge +2

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

Userlevel 7
Badge +24

Hi @Shubham Mane ,

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

Kind regards,

Lee Pinchbeck

Reply