Hello guys,
depending on the field that I am sorting, the records are present or not -> the total amount doesn't change
Here are two screenshots, any ideas what can be the cause?:
Are you sure you are allowed to see all objects of this table?
For me it looks like, that somehow your company deactivated the ACL message "Number of rows removed from this list by Security constraints". Because of that you think, there are no objects, but you just not allowed to see them.
So please check with your admin, if there are any ACLs on this table.
That is a screenshot with a valid ACL message.
Hi Bartłomiej,
Sorting by different rows shouldn't change number of records that are displayed.
Is this happening only when records are sorted by column "Name" or does this happen when sorted by other columns such as "Asset" and "Assigned to"?
Also like to make sure. The records are sorted by clicking on the column header.
Does this also happen when the sort order is selected from the "Add Sort" in filter condition?
Finally, is this an actual table or a database view?
When using other columns than name, operational status, status, and updated -> everything works fine.
When I don't have query for u_sap_system.u_etd_monitoring=true also there is no trouble with filtering by name, or status.
Using the 'Add Sort' functionality doesn't change anything.
It is an actual table.
The column u_sap_system.u_etd_monitoring is the only foreign column here, so maybe it can be the cause?
However, when I move to SAP System table, then I can easily use that query and there is no problem with any sorting
SSo I think that's not a cause of any ACLs
