FetchXml on Dynamics doesnt work on a specific user?

Question

I've been struggling with a basic fetch and an inner join.

I've tried the following:

• In the XRMtool FetchXML tester: the fetch works perfectly fine with some non-admin users, but not with others who have the same role as those that work.
• I usually take the condition values from the form, and my intention is to create a custom view depending on the user. So, I tried hardcoding the values, but with some users, it returns data, and with others, it returns <resultset morerecords="0" />.
• I tried giving an administrator role to one user, and that fixed their problem, but some users cannot be fixed that way.

Any help would be appreciated.

    <fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' > 
        <entity name='new_categorias' > 
            <attribute name='new_name' /> 
            <attribute name='new_codigo' /> 
            <attribute name='new_categoriasid' /> 
            <order attribute='new_name' descending='false' /> 
            <link-entity name='new_conveniounitarios' from='new_categoria' to='new_categoriasid' link-type='inner' alias='ab' > 
                <filter type='and' > 
                    <condition attribute='new_fechainicio' operator='on-or-after' value='2023-01-01' /> 
                    <condition attribute='new_fechainicio' operator='on-or-before' value='2023-12-31' /> 
                    <condition attribute='new_convenio' operator='eq' uitype='new_convenios' value='XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX' /> 
                </filter> 
            </link-entity> 
        </entity> 
    </fetch>