Database View returns rows but empty data

[Shane11]

Hi All,
I created a Database View so we can report if a Requested Item associated to a Change has a different start date than the change.
The view is returning the correct amount of rows but all the columns are empty. Any ideas?

View Tables:

Table: change_request
Order: 1
Prefix: CHG
Where: <blank>
Fields: number, sys_id, start_date, u_request_item

Table: sc_req_item
Order: 100
Prefix: RITM
Where: RITM_sys_id = CHG_u_request_item
Fields: number, sys_id, expected_start

Thanks in advance!

[TJW2]

I created one on DEMO that did NOT work, recreated using all lower case 'ritm' & 'chg' and it worked fine. Perhaps CAPS have something to do with it???

[Shane11]

I thought that might have been an issue and I changed them but it still didn't work for me. When I added the second table they both also had the same order, maybe that messed something up behind the scenes ?

I dunno...

Thanks for you help Terri!

[mrkesu]

Wow, I read your comment and I laughed a bit, but I renamed all my CAPS prefix'es to lower case, and suddenly everything worked, the Name field that were outputted as "(empty)" suddenly had the actual names.

What a weird bug. I'm on Kingston btw.