Too much results

[Winours]

Hi everyone, I am experiencing slow perf with tasks plugin. i understood that I have to make a querry which is not returning a great number of tasks.
Here is the querry I use, and I would like to modify it to return only the "overdue" and "scheduled Today" tasks. Can you help ?

not done
path does not include courses
path does not include recycle
tags does not include Nathalie
tags does not include checklist
sort by priority
sort by due
sort by scheduled
sort by starts
group by function task.happens.moment? (task.due.moment?.isBefore(moment(), 'day') ? task.due.format("[%%0%%‼️ Overdue]") : (task.due.moment?.isBetween(moment(), moment(), 'day', '[]') ? task.due.format("[%%1%%❗ Due Today]") : (task.happens.moment?.isBefore(moment().add(1, 'day'), 'day') ? task.happens.format("[%%2%%📆 Scheduled Today]") : (task.happens.moment?.isBefore(moment().add(7, 'days'), 'day') ? task.happens.format("[%%3%%⬆️ Upcoming]") : task.happens.format("[%%4%%💤Beyond Seven Days]"))))) : "No Date"
group by function reverse task.scheduled.format("%%%%")

hide task count

[claremacrae]

First, let's understand the problem, and its scale:

1. Please comment-out (with #) the hide task count line - and report here how many tasks are being displayed
2. Please try temporarily change to the default Theme, and disable all CSS snippets, to see if that fixes the performance problem.

modify it to return only the "overdue" and "scheduled Today" tasks

overdue: Add this line:

due before today

scheduled Today: Add this line:

scheduled today

Another thing you can do is to add a limit - I recognise that by 'group by function' line, and the original author included:

limit groups 10

As the purpose was to get a manageable list of tasks...

[Winours]

Thanks !

Yes that's 844 tasks for now...
That works if i add scheduled today
But i lost all benefits from group by function

What if I want to limit only the groups "upcoming" "beyon 7 days" and "no date" ?

[claremacrae]

Yes, 844 tasks is way too many for reasonable performance.

I recommend going back to your original query above, and then adding something like:

limit groups 30

That should give you plenty of tasks to chose to work on.

[Winours]

ok thanks you are right... 30 tasks is enough !!

[Winours]

Hi, do you have the code if I want to remove "beyond seven days" and "no date" categories ? I don't need them. (perhaps also "upcoming" categorie, so that the plugin could be as fast as possible.)

I don't understand well this code I took somewhere on this forum... :

group by function task.happens.moment? (task.due.moment?.isBefore(moment(), 'day') ? task.due.format("[%%0%%‼️ Overdue]") : (task.due.moment?.isBetween(moment(), moment(), 'day', '[]') ? task.due.format("[%%1%%❗ Due Today]") : (task.happens.moment?.isBefore(moment().add(1, 'day'), 'day') ? task.happens.format("[%%2%%📆 Scheduled Today]") : (task.happens.moment?.isBefore(moment().add(7, 'days'), 'day') ? task.happens.format("[%%3%%⬆️ Upcoming]") : task.happens.format("[%%4%%💤Beyond Seven Days]"))))) : "No Date"
group by function reverse task.scheduled.format("%%%%")

[claremacrae]

I don't understand well this code I took somewhere on this forum... :

That first, long group by function line was written before Tasks supported if/else and continuation lines, so it had to be written as a one-liner...

It is precisely equivalent to this rather more readable code:

group by function \
    if (!task.happens.moment) { \
        return 'No Date' \
    } \
    if (task.due.moment?.isBefore(moment(), 'day')) { \
        return task.due.format('[%%0%%‼️ Overdue]') \
    }  \
    if (task.due.moment?.isBetween(moment(), moment(), 'day', '[]')) { \
        return task.due.format('[%%1%%❗ Due Today]') \
    }  \
    if (task.happens.moment?.isBefore(moment().add(1, 'day'), 'day')) { \
        return task.happens.format('[%%2%%📆 Scheduled Today]') \
    }  \
    if (task.happens.moment?.isBefore(moment().add(7, 'days'), 'day')) { \
        return task.happens.format('[%%3%%⬆️ Upcoming]') \
    }  \
    return task.happens.format('[%%4%%💤Beyond Seven Days]')

remove "beyond seven days" and "no date" categories?

Sure, That long code above only controls how tasks that match the query are grouped.

So you need to add more filters to exclude tasks in those categories.

Looking at the code above, you should try adding:

has happens date
NOT (happens after in 6 days)

That second one was a bit tricky to work out, with some experimentation.

[claremacrae]

(above edited for formatting and readability)

[claremacrae]

That second line is very odd - where did you get it from?

group by function reverse task.scheduled.format("%%%%")

It looks like it adds the same empty heading (with no visible content) to all tasks that have a scheduled date.

[claremacrae]

Oh, maybe it splits up scheduled from due in the 'Beyond 7 days' category?

[Winours]

Your modifications is way much comprehensive for me !
And it seems to do what I want...
I found this code here : https://www.youtube.com/watch?v=s3_mhGqJY4U&t=2s&ab_channel=PrakashJoshiPax
It was on a discord channel then...