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]

Have you tried returning all fields to see if your data is joining?

[Shane11]

I originally had it returning all fields, I narrowed it down thinking that was causing the empty rows, I just removed the fields again and get the same result.

[paddyosmond]

Hi Shane, I experienced the same issue today, not 100% sure what the issue was even now, i even encountered this problem with the already implemented views. The only resolution when I had this issue was to simply delete the view and start from scratch again. One thing that may have helped was not including any uppercase characters for table names, however i think given that this was an issue on existing views perhaps this is a database view bug rather than human error.

Paddy Osmond

Junior Technical Consultant at Focus Group Europe

[Shane11]

I created another one to test, and it works fine, I made it exactly the same... I dunno.

Thanks anyway