Skip to main content
G
gautami7457
April 29, 2023
Question

Filtering Task Report

  • April 29, 2023
  • 4 replies
  • 0 views

Hi All,

I am trying to make a task report interface. This is a snippet of my report.

Here, I just want to ensure that by default when a user lands to this page, they only see their assigned tasks, and only when they click on  the dropdown they should be able to view other task status in the grid such as "Completed" , "Accepted" and "Not started".
Here is the snippet of my code, I tried using the local!statusfilter to be just as "Assigned", but that is not working, for now the value is null.

Request some help on this!

4 replies

S
sanchitg0002
April 29, 2023

Make sure that your Status column in Report is "c5" only. AFAIK when a report is generated it is "c1" by default.

To confirm, store the result of queryProcessAnalytics() in a local variable and check its value.

G
gautami7457Author
April 29, 2023

My Status is stored in C5 only.

And also, where do I need to mention that the tasks which are "Assigned" should only be shown?

S
sanchitg0002
April 29, 2023

Okay.

If you are trying to show only "Assigned" tasks initially when there is no value selected in the dropdown then for that you can copy below code at Line:122

a!defaultValue(local!statusFilter, 0)

Or, you can set the value for local!statusFilter to 0 at the time of declaration but this will show "Assigned" selected in the dropdown when form loads, which I think should not be a concern.

Terms & ConditionsAccessibility statement