After applying group by on a field some records are not visible in UI16Issue When a user applies group by on the field 'Name' (dotwalking from sc_cat_item) on the sc_req_item list, some records are not visible anymore. The issue occurs when the user's language is set to a non-english language, and changing the language to English resolves the issue. The issue is linked to a known defect (PRB1942318) which documents that records will not be shown in a non-English Group By when a dot-walked translated-text field is used and the corresponding sys_translated_text entry does not exist.ReleaseAllCause1. The issue is caused by how the list query is constructed when the session language is non-English. In non-english language, the query joins sys_translated_text to compute the bucket value as COALESCE(translated_value, original_name), resulting in records not appearing in the expected bucket if the non-english translation is missing for a referenced cat_item. 2. This behavior matches the analysis of the known defect DEF0742569 (linked Problem PRB1942318), which documents the issue with non-English Group By operations on translated-text fields.Resolution1. The issue is confirmed to be related to a known defect (PRB1942318) which has been closed as 'Won't Fix' by the Dev-Lists engineering team due to the risk of regression in the UI16 list. 2. The development team has confirmed there is no workaround for this behavior at this time. 3. Can link the case to the PRB, and if enough customers are affected, the issue may be revisited for a potential fix.