Skip to main content
Solved

Show data from connecting tables without a view

Blommetje
Forum|alt.badge.img+13

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 

 

Best answer by Mark Jongeling

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. 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Remco Duijsens
Vanguard
Forum|alt.badge.img+1

Hi Blommetje,

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

Marius Korff
1 person likes this
  • Marius Korff
    Marius Korff
E
Moderator
Forum|alt.badge.img+17
  • Erwin Ekkel
  • Moderator
  • 761 replies
  • November 21, 2023

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

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Mark Jongeling
  • Administrator
  • 3936 replies
  • Answer
  • November 21, 2023

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"
Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Hi @Blommetje,

Were these reactions sufficient to solve your situation?

Terms & 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