You are viewing limited content. For full access, please sign in.

Question

Question

Forms 11 Update 3 Open Task List Change Feedback

asked on March 7, 2023

In Forms 11 Update 3 the following change was made:

  • Improved the task list performance by reducing the number of lines retrieved at a time.

 

We have discovered that this change loads only 100 tasks at a time for the various Inbox tabs (Open Tasks, Completed Tasks, etc.). We have received some feedback from end-users that have several hundred tasks in their Open Tasks and how this change has affected their efficiency.

For the Completed Tasks they appreciate the performance increase in loading tasks since before it would take a lot longer for users that have been using the system for a while.

For Open Tasks it's a different story. They have discovered that they are only able to Search, Sort, and Filter based on the first 100 tasks that have been loaded. From testing it appears that Open Tasks loads the first 100 based on Date Assigned, loading today's tasks first. Our users would like the ability to Search, Sort, and Filter across all tasks in their Inbox at once instead of having to click "Load More" over and over again and then perform those actions.

For now, is there a setting in a file that can be changed to tell Forms to load more than 100 by default just for the Open Tasks?

1 0

Replies

replied on March 7, 2023

You can change the items to load for inbox tasks list by running following query on Forms database(it will affect all Inbox tasks list not only Open Tasks):

  update [cf_options] set optionvalue='5000' where optionname='GridLoadLimit'

5000 was the default value for Forms before Forms 11 Update 3, and we changed to 100 by default in Forms 11 Update 3.

The Search for the tasks list is across all tasks, but Sort and Filter are just based on the data already loaded in the browser. The users didn't notice the difference before as their number of tasks is under 5000.  

How many number of open tasks in general will the users have?

 

2 0
replied on March 7, 2023

Thank you for that information. 

The users that have commented have between 1,000-2,000 Open Tasks. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.