Database View table join issue - blank fields

[mischellyann]

I am attempting to join two tables and keep coming up with blank fields, fields that I know have data in them like Number and other mandatory fields.   I actually tried running the join with just one table and no filtering statements which should just return that entire table.   It returns the right number of rows but a lot of the columns have no data, again, columns which I know have something in them.

The table I am pulling from is a user created table inherited from Task.   What am I not doing?

Thank you,

Sam

[PeterWiles]

Without knowing your data/table, the table join should be something like this:

Table sys_user

Order 100

ref user

Table task

order 200

ref task

condition - user.user_id = task.caller_id

Left Join = true

Once done, make sure you amend the column listing to pull the correct table fields as there might be some duplicates on both tables.

[mischellyann · Accepted solution]

I actually ended up putting in a ticket to the helpdesk.   It turned out my problem was the use of a capital letter in my variable name.   Apparently, the that messes with the logic used by the Database Views.   Once I changed it to a lowercase, everything worked.

[Callum Spiers]

Can confirm this still happens in San Diego in 2022! Make sure your variable prefix is lowercase or you'll get blank records, or even spookier, blank reference records - so it looks as though it's working properly but actually when you try to drill into the record, it returns null!