Skip to Content (Press Enter)
UserImage.jpg
kazuma yamagata
166Views
4Comments
Sort tables
Question
Beginner

Hi everyone


I'm having some problems right now.


1. I'm currently using Strature to populate a table and display it.

When sorting, only one page of records is sorted, which is a problem.

Is there a way to sort all the records in the list?

2. I also want to filter and narrow down.

(For example, put 10 records and only 1~3 of No.


3. The reason why we are using Stracture in the first place is that if we use the DB and perform operations at the same time, there is a problem that conflicts will occur.

Is there a good way to solve it?


If you have any good ideas, please let me know.


Keep the oml attached


checkbox.oml
0
0
03 Aug 2023
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

Hi Kazuma,

To achieve the desired functionality, you just need to make a minor modification in the Sort Button Onclick event screen action flow as highlighted below. 

Instead of referring to the sumimasen local list variable, use the temp_sumimasen local list variable in the ListSort client action. The reason behind this change is that according to the PaginationOnNavigate screen action flow logic, the sumimasen local list variable will only contain a maximum of 5 records (maxrecord) at any given instance. 

Demo app: Screen3

Refer to the attached oml.

I hope this helps you!


Kind regards,

Benjith Sam

checkbox.oml
0
0
03 Aug 2023
Copy Link
UserImage.jpg
kazuma yamagata

Hi Sam!


Thank you for continuing yesterday!

I would be very happy if you could continue to answer your questions.


My question is, why use temp_sumimasen local variables in ListSort?

I'm still not very sure about the need for temp_sumimasen local variables, so I'd like you to tell me.

Also, I haven't used the list filter function very often.

Can you tell me how to use it on this table?


I'm sorry, but thank you.


Kazuma

0
0
03 Aug 2023
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

Replying to kazuma yamagata's comment on 03 Aug 2023 04:38:27

Hi Kazuma,

Apologies for the delayed response. Refer to the following reply addressing your concerns.

Why use temp_sumimasen local variables in ListSort?

  • Based on the PaginationOnNavigate screen action flow logic, the "sumimasen" local list variable will hold a maximum of 5 records at any given time.
  •  However, to retain the entire list of records, we are using the "temp_sumimasen" local variable.
  • For any operation (ListSort, ListFilter, Pagination etc..) that needs to be applied to the entire list of records, you will have to refer to the "temp_sumimasen" local variable.  

I'm still not very sure about the need for temp_sumimasen local variables, so I'd like you to tell me.

  • To enable pagination for the table, we are limiting the number of records displayed in the table. Thus, the variable associated with the table, namely "sumimasen," will only store 5 records to show 5 records per page.
  • However, to retain all the records, we are using the "temp_sumimasen" local variable.

Also, I haven't used the list filter function very often.

I hope this helps you!


Kind regards,

Benjith Sam

1
0
04 Aug 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.