Jump to content
Sign in to follow this  
Ocean West

zero found count and scripted sorts

Recommended Posts

It appears there is a change with 10 that I discovered when running a script.

In a list view layout with header / body / grand summary / footer, the grand summary will stretch to fill the gap between the header and footer depending on how many body rows there are.

If you omit all records from the found set all you will see is the header / grand summary / footer.

In this space I have used either a field or web viewer - calculated to show record count or "End of List" or "No Records Found" occasionally add a button. As i don't mind the user landing on a list with zero found.

However in 10 it appears that the sort operation is evaluated even when the found count is zero, the result is that all body parts are blanked (WHITE)

The quick fix is to wrap the SORT step with If [ Get(FoundCount) ] to exclude the sort step when no records are found preserving the grand summary.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.