Log in to AnswerLog in to Follow
Nandini T S
19Views
5Comments
Solved
Dynamic display of data per page when filters applied
Question
Traditional Web
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 

0
0
on 25th Mar
Rahul Sahu
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


See solution in context
3
0
on 25th Mar

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

See solution in context
DynamicNumPage.oml

0
0
on 25th Mar
cezarF
Solution

Hi Nandini,

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

-cezarF


See solution in context
0
0
on 25th Mar
Rahul Sahu
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


3
0
on 25th Mar
cezarF
Solution

Hi Nandini,

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

-cezarF


0
0
on 25th Mar

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

0
0
on 25th Mar

Hi,

below is the another option to manage by advanced query .

OFFSET @Offset ROWS
FETCH NEXT @NumRows ROWS ONLY

Regards,

Vijay

0
0
on 25th Mar

@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 ...



2
0
on 25th Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.