Dynamic display of data per page when filters applied
Application Type
Traditional Web
Service Studio Version
11.10.13 (Build 39571)

Hi Team ,


I need to display number of records as per the drop down selected (let's say if I have 3 numbers in drop-down 50,100, 150, ) if 50 is  selected it should display 50 records per page after applying all the necessary filters...


E.g., :- I have total 1000 students in DB 

And 3 branches :- CS ,IS ,EC 

if I select CS(active students) in check box and select 50 in drop-down it should display 50 records per page after applying the filter ...

Need assistance ...

Thanks 

mvp_badge
MVP
Solution

Hi Nandini,

When you get data from Aggregate you have option to set Max Record-


take a one local variable integer type bind it with Dropdown.

whenever you changed drop down pass this value in max record.

accordingly you get number of records.


Hope this will help you.

Regards

Rahul


Hi @Nandini T S 

Please check here if it's the expected behavior: https://galmeida.outsystemscloud.com/DynamicNumPage/Entry1.aspx?_ts=637522720311815873

If it's ok you can check the oml as well.

Regards

Gonçalo Almeida

DynamicNumPage.oml

Solution

Hi Nandini,

You can also bind "Line Count" property of a Table Record widget to the value of the selected dropdown.

-cezarF


mvp_badge
MVP
Solution

Hi Nandini,

When you get data from Aggregate you have option to set Max Record-


take a one local variable integer type bind it with Dropdown.

whenever you changed drop down pass this value in max record.

accordingly you get number of records.


Hope this will help you.

Regards

Rahul


Solution

Hi Nandini,

You can also bind "Line Count" property of a Table Record widget to the value of the selected dropdown.

-cezarF


Hi @Nandini T S 

Please check here if it's the expected behavior: https://galmeida.outsystemscloud.com/DynamicNumPage/Entry1.aspx?_ts=637522720311815873

If it's ok you can check the oml as well.

Regards

Gonçalo Almeida

DynamicNumPage.oml

Hi,

below is the another option to manage by advanced query .

OFFSET @Offset ROWS
FETCH NEXT @NumRows ROWS ONLY

Regards,

Vijay

@Rahul Sahu ,@cezarF ,  @Goncalo Almeida , @Vijay Malviya 

Thanks a lot for the response ... 

I got different solutions from your side ... 

Implemented it and working fine ...



Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.