How to return top N records with JPQL

Support
#1

Hi,
Please do you have any idea how I can return top n records using JPQL in my query loader as below?

I have used TOP, LIMIT clause, I am not getting result.

Thanks

 <collection id="quotationRequestsDc" class="com.modula.sapb1portalmgt.entity.sales.quotation.QuotationRequest">
            <fetchPlan extends="_base">
                <property name="customer" fetchPlan="_instance_name"/>
            </fetchPlan>
            <loader id="quotationRequestsDl">
                <query>
                    <![CDATA[select e from spm_QuotationRequest e
                    ]]>
                </query>
            </loader>
        </collection>
#2

This cannot be done in the descriptor.

You can use loadDelegate
In it, load data through the dataManager and set maxResults.

@Install(to = "departmentsDl", target = Target.DATA_LOADER) 
private List<Department> departmentsDlLoadDelegate(final LoadContext<Department> loadContext) { 
    return dataManager.load(Department.class).query("......").maxResults(5).list();
}
#3

Hi Andrey,
Thanks, it works