please help me to create a particular view

[robisme (Olivier R)]

Hi,

I have a view with the following conditions:

- (Project status is "In Progress") AND

- (Start date "on or before tomorrow" OR Start date "does not exist")

I'd like to add a condition which could be something like :

- NOT ("is project" AND Has subtask is "False")

ie : DON'T display the projects without subtaks (but do display the projects with completed subtaks)

It is something like creating a new conjunction "NOT" in addition to OR and AND

How could I manage to do it?

Thank you for helping me.

Olivier

[Andrei Bacean]

Not sure that i understand you.
Can you give an example of a tree and of the filtered view?


I would create a plain view which shows all the tasks which you want (completed, uncompleted).
Then i would enable the hierarchical view and would apply a filter to the parents(is project, is in progress, start date etc).

Regards
Andrei

[Dwight]

HI, Olivier.

Long ago in symbolic logic class I learned DeMorgan's laws:

Not (a or b)
Equals
(Not a) and (not b)

Also

Not (a and b)
Equals
(Not a) or (not b)

If you apply DeMorgan's laws to your filter I think you will get something easier to code.
-Dwight
Mlo betazoid on Android sgn2

--
You received this message because you are subscribed to the Google Groups "MyLifeOrganized" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mylifeorganiz...@googlegroups.com.
To post to this group, send email to mylifeo...@googlegroups.com.
Visit this group at http://groups.google.com/group/mylifeorganized.
To view this discussion on the web visit https://groups.google.com/d/msgid/mylifeorganized/d28233be-bca0-4fc9-a0e0-85b926b87b37%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[robisme (Olivier R)]

Thanks.

Andrei:

My view display active tasks grouped by context :

- tasks belonging to a "in progress" project AND

- which start date is not in the future (ie no start date or date on or before today)

In this view, there are projects displayed, because they are active.

I'm ok to display the projects with only completed subtasks (ie project became active task, but I don't want to display the projects without any subtask (waiting for me to add tasks but already "in progress"

Dwight: (suppressed previous message, my answer wasnot accurate enough)

I'm no able to reproduce the law, because my purpose isn't "not (a or b)" or "not (a and b)"

I want "Not (a and b), ie Not (is project and hasn't subtask), but if I set "not a" or (not b), I will have all the tasks that are not projects (not a). I don't want that.

I'd like "a But not b"

[robisme (Olivier R)]

My filter is exactly :

[] AND

   [] (StartDateTime on or before Today) OR

   [] (StartDateTime does not exist)

[] (ProjectStatus=In Progress)

I don't know how to add :

[]

   [] (is project=True) AND

   [] (HasSubtasks=True)

It has no effect, because it doesn't avoid the first filter (ProjectStatus=In Progress).

The project with no subtaks still be displayed.

[Dwight Arthur]

I don’t have time to test it so I will just send it and hope it works

 

   ((Project Status = In Progress)

AND

   [(ActiveAction is True)

AND]

      ((StartDateTime OnOrBefore Today)

   Or

      (StartDateTime DoesNotExist))

AND

      (isProject = False)

   OR

         ((isProject = True)

       AND

          hasSubtasks = True)))

 

The part in square brackets is something you didn’t ask for. I would have included it if this were my filter so I threw it in. If you don’t like it just delete everything between the two square brackets.

 

It says, show me all active tasks that are a part of an active project, except that if this is the project entry itself, exclude it if it has no subtasks.

 

-Dwight

To view this discussion on the web visit https://groups.google.com/d/msgid/mylifeorganized/8667229d-e13e-4180-8bbd-9e4f430e9bab%40googlegroups.com.

[Dwight]

Missing a paren, fixed below

-Dwight
Mlo betazoid on Android sgn2

On May 23, 2015, Dwight Arthur <m...@dwightarthur.us> wrote:

I don’t have time to test it so I will just send it and hope it works

 

   ((Project Status = In Progress)

AND

   [(ActiveAction is True)

AND]

      ((StartDateTime OnOrBefore Today)

   Or

      (StartDateTime DoesNotExist))

AND

      ((isProject = False)

   OR

         ((isProject = True)

       AND

          (hasSubtasks = True))))

To view this discussion on the web visit https://groups.google.com/d/msgid/mylifeorganized/00e701d09519%2457eb16d0%2407c14470%24%40dwightarthur.us.

[Andrei Bacean]

Hi Olivier

You are trying to filter 1) the tasks (no date, date before or today) and also 2) the project status (parents of tasks) in the advanced filter dialog.

The advanced filter dialog will filter or the tasks or the projects. And not both of them. This is the problem.

So... i propose to use the advanced filter dialog to show all the tasks which match your criteria (no date, date before or today).

and then to enable the show hierarchy and use the Parent filter (is project and project status=in progress).

Can't attach images. Will try to attach them by sending an email to this thread.

BR

Andrei

пятница, 22 мая 2015 г., 23:33:37 UTC+3 пользователь robisme (Olivier R) написал:

пятница, 22 мая 2015 г., 23:33:37 UTC+3 пользователь robisme (Olivier R) написал:

[Andrei Bacean]

суббота, 23 мая 2015 г., 11:57:29 UTC+3 пользователь Andrei Bacean написал:

[Andrei Bacean]

There are some dupplicated screens. Should be 4 photos.

суббота, 23 мая 2015 г., 12:04:21 UTC+3 пользователь Andrei Bacean написал:

[robisme (Olivier R)]

Hello,

Thank you so much to both of you.

It works.

Andrei : you did a very good tutorial, thank you.

But :

Dwight : I took your solution and it works perfectly

Regards

Olivier