Records are unavailable to view depending on the field on which results are sorted
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2022 02:48 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2022 05:47 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2022 10:41 PM
checked, it is not a cause of security constrains

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2022 05:57 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2022 10:37 PM
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