How do I add a related list condition for a view I created?

Robert Campbell
Tera Guru

I created a related list but I don't see reference to them when I select this view. I actually created two "relationships", one to itself and the other to the relationship table. I want to have a dashboard that shows multiple views of the same data at once and the easiest way to do that was to create a view and build all the reports off that view. What do I need to do to see related list conditions for view that I made?

 

RobertCampbell_0-1738875695487.png

 

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

A database view isn't something you can handle like 'normal' tables. Yes, you can put related lists on the forms you create for it, but those aren't selectable through reports. Your data is already coming from different tables and the related lists aren't directly related. Those are scripted.

 

What exactly are you trying to do? Because 'showing multiple views of the data' is still that data. My name is the same in no matter which view I look at it. It can just be that sometimes it is shown and sometimes it's not. So just adding all fields you need to see, no matter the view, would get you all the data, right? Or are we missing something?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

2 REPLIES 2

Mark Manders
Mega Patron

A database view isn't something you can handle like 'normal' tables. Yes, you can put related lists on the forms you create for it, but those aren't selectable through reports. Your data is already coming from different tables and the related lists aren't directly related. Those are scripted.

 

What exactly are you trying to do? Because 'showing multiple views of the data' is still that data. My name is the same in no matter which view I look at it. It can just be that sometimes it is shown and sometimes it's not. So just adding all fields you need to see, no matter the view, would get you all the data, right? Or are we missing something?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

I wanted to do something like "having less than 1"... but I realized because I do have all of the data needed in one view I can simply do "where service is empty".  Thanks. Sometimes you just need a response to open your eyes.