Why is my database view for sys_journal_field and incident only showing one record?

[Mitch Moses]

It is showing the right amount of records it should from checking the sys_journal_field table with the same conditions, but they aren't showing up?

Here's the question where I got it working, but it's not displaying the data correctly. I am an admin.

https://community.servicenow.com/community?id=community_question&sys_id=6163e57edbdf3340f7fca851ca96...

[Brandon Barret1]

Are there any javascript errors coming up in the browser console? Do you have the ITIL role also, by any chance? Not sure if this may be of any use:

https://community.servicenow.com/community?id=community_question&sys_id=a7e383e5dbd8dbc01dcaf3231f96...

[Mitch Moses]

It's so weird because it shows 1 record and if I go to anymore of them then it doesn't show any. 

If I keep going, then it won't show any more records, but if i filter out the record. It will show new ones. 

Or if I filter all of the records it will show me a new one on top

[Mitch Moses · Accepted solution]

I made a new view and used left join on incident instead of sys_journal and it worked. Also, I didn't pick out any of the fields inside of the tables. Hope this helps someone 🙂

[Joel Lignier]

I've just encountered this same issue but with different tables in the join. Things started working correctly when I removed all the 'View Fields' from all the tables.