Asset tag, serial number is null in database view

[Nithin21]

Why are some fields empty in the data generated by Database view. 

Note: This is done on OOB instance without any customizations

Example:

Configure Database view on alm_hardware table 

Select below mentioned 3 fields under "View Fileds" menu

View the data using "Try it" menu. All the records have Asset Tag and Serial number as empty

[Deepak Ingale1 · Accepted solution]

Interesting !!!

I tried that in my personal instance and got same result !!!

When debugged, found that access to serail_number and asset_tag field dependent of "quantity" field

So, please add quantity field as another field in view fields related list and see the magic !!!

Note: Please mark reply as correct if it answers your question

[Nithin21]

Thanks Deepak for your response, you are right. 

Can you advice steps to debug such a case

In my company instance asset tag and serial number blank even after adding Quantity.

I would need to follow your debug steps to find out which other field is a dependancy

[Nithin21]

Interestingly in my company instance the fields are empty even after adding "Quantity" as another field in view fields. 

ACL debug says that ACL on Asset tag field and serial number field is still returning FALSE 

Condition defined on these ACLs are OOB 

Quantity = 1

[Deepak Ingale1]

Could you please share the screenshot of ACLs?

Also try to clear the cache by hitting cache.do page ( /cache.do )