Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Get tasks completed on a specific day? #9

Open
alper opened this issue Feb 8, 2022 · 1 comment
Open

Get tasks completed on a specific day? #9

alper opened this issue Feb 8, 2022 · 1 comment
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@alper
Copy link

alper commented Feb 8, 2022

Hey, I love this,

Just a question: is there a way for me to get the tasks completed on a certain day? Like specifically I'd like to programatically get the output of the logbook for yesterday.
@alper
Copy link
Author

alper commented Feb 8, 2022

Oh I see there are:

    logbook             Shows completed tasks
    logtoday            Shows tasks completed today

but no logyesterday

@AlexanderWillner AlexanderWillner added enhancement New feature or request good first issue Good for newcomers labels Feb 13, 2022
@bkleinen bkleinen mentioned this issue Nov 30, 2022
Merged
mikez added a commit to thingsapi/things.py that referenced this issue May 22, 2023
@mikez
Add support for exact date queries including optional operators.
13391c1 
start_date, stop_date, and deadline parameters now allow to pass
ISO 8601 dates with an optional operator. The input is converted
to a "Things date" integer prior to running the SQL statement
if it such a date column; otherwise regular UNIX Time is used.

Examples:

'2023-05-22'
'<=2023-05-22'
'>2023-05-22'

In SQL, depending on its column type, the parameter '<2023-05-22'
is converted into

    deadline < 132602624

or

    date(stopDate, 'unixepoch') < date('2023-05-22')

See also: #96 and thingsapi/things-cli#9
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request good first issue Good for newcomers
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alper @AlexanderWillner