Skip to main content
Question

QFACT views

  • December 16, 2024
  • 3 replies
  • 51 views

Forum|alt.badge.img+10

Hello,

How do I refresh a QIS, the ial that it is based on has 12000 but the QIS has only 10000 records ?

 

Thanks

3 replies

Forum|alt.badge.img+7
  • Hero (Employee)
  • 49 replies
  • December 17, 2024

Hi ​@JannetteC,
There is no refresh option for QIS since that is an online view.

If you have 12k records on IAL but QIS only have 10K records then this could be due to a row level security (RLS) issue.
Are you using the same user to query both IAL and QIS?

Do you have a RLS filter at the IAL level in the WHERE clause?

Is the IAL created using tables or views? if views, do those views have some kind of RLS check inbuilt?

Eg : if there is a site access check RLS filter, then the no of rows visible will depend on the access of the querying user.

Best regards,

Subash
 


Forum|alt.badge.img+7
  • Hero (Employee)
  • 49 replies
  • December 17, 2024

Due to some refresh issue the same comment posted twice and I can’t remove the duplicate it seems. πŸ™

Hi ​@JannetteC,
There is no refresh option for QIS since that is an online view.

If you have 12k records on IAL but QIS only have 10K records then this could be due to a row level security (RLS) issue.
Are you using the same user to query both IAL and QIS?

Do you have a RLS filter at the IAL level in the WHERE clause?

Is the IAL created using tables or views? if views, do those views have some kind of RLS check inbuilt?

Eg : if there is a site access check RLS filter, then the no of rows visible will depend on the access of the querying user.

Best regards,

Subash


ChanakaEA
Do Gooder (Partner)
Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • 11 replies
  • January 24, 2025

HI ​@JannetteC ,
Are you getting only 10K rows to the BR report? If that the case, please check the Max number of rows to retrieve during report execution (highlighted below) parameter value in BR System Parameters. 

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings