Database View - blank columns for itil user, but not consistent!

Tommy SN Sahlin
Kilo Sage

‎02-06-2024 08:27 AM - edited ‎02-06-2024 08:28 AM

Hi Community,

 

we have created a DB View, which combines incident, kb_knowledge and m2m_kb_task tables. This way, we can do a lot of good reporting on how knowledge articles are being used when working with incidents. Here's how it is built:

TommySNSahlin_0-1707236563533.png

Looks as it should and works fine - except the itil user gets blank columns for all fields originating from kb_knowledge - and only for some records, the others show just fine! The odd thing is I can't find any consistency, pattern, or reason - it appears to be random. Also, the itil user can search and open the "blank" knowledge articles just fine from all other parts of the platform. Does anyone recognize this, or have a clue about what might be going on..?

 

many thanks in advance  /Tommy 

0 Helpfuls
  • 333 Views
1 REPLY 1

ASA5
Kilo Sage

‎02-06-2024 08:57 AM

Hi Tommy,

 

When you load a record on the list view, ACL are not evaluated correctly if they need a field that is not present in the list. This is used by ServiceNow to prevent performance issue.

If those fields are reference they may be concerned.

Please check the link for more details : 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827368

 

Best

 

0 Helpfuls