Question

Show data from connecting tables without a view

  • 17 November 2023
  • 3 replies
  • 48 views
Blommetje
Userlevel 5
Badge +11

Hi, 

When I have a table Activity with a connecting table to Item. This is the table Activity_item. Since I can connect several items to several activities. 

The connection table has 2 columns, activity_id and item_id, both the pk. 

The end user however would like to see more data from the item_table  weight, owner, position, etc. 

Currently we can one get this data by creating a view from the connection table, join the tables and show all data needed. This is quite unpractical. 
What other ways would be possible to solve this, since connecting tables will (almost) always need more data from the other tables. I do not want to save duplicate data of course.. 

 

Thanks! 

Blommetje 

 

3 replies

R
Rank
Userlevel 1
Badge

Hi Blommetje,

A other option I could think of is adding a expression field to your connection table. 

E
Rank
Userlevel 6
Badge +16

Can you clarify why you want to avoid a view? Because it sounds like that's exactly what you are looking for?

Mark Jongeling
Rank
Userlevel 7
Badge +21

Adding to Erwin's reply, you can look into Meta auto or Meta custom views: https://docs.thinkwisesoftware.com/docs/sf/data_model#views

Those views do not require manual coding but are automatically generated based on your given tables and columns. Very handy for the more simple views. 

"Wake me up before you low-code"

Reply


Terms & ConditionsCookie settings