Cannot query block property if it's a date (journal page)

[DimitryDushkin]

What happened?

Seems like if block's property is a date it cannot be queried.

Reproduce the Bug

1. Data:

- DONE completed today
  completed:: [[Oct 22nd, 2022]]
- DONE completed yesterday
  completed:: [[Oct 21st, 2022]]
- DONE completed 10 days ago
  completed:: [[Oct 12th, 2022]]

2. Query (assume today is Oct 22nd)

#+BEGIN_QUERY
  {
    :title "Tasks completed yesterday"
    :query [
        :find (pull ?b [*])
        :where
            [?b :block/properties ?properties]
            [(get ?properties :completed) ?completed]
            [(< ?completed :today)]
    ]
  }
  #+END_QUERY

It should return 2 tasks (older than today), but returns all of them.

I've tried to use date format like <2022-10-10> (like SCHEDULED property) both in blocks and a query it also doesn't work.

Expected Behavior

It should return 2 tasks (older than today)

Screenshots

No response

Desktop Platform Information

Latest MacOS, Logseq 0.8.9

Mobile Platform Information

No response

Additional Context

Also queries doesn't work at all in iOS app, but that's an another story.

[logseq-cldwalker]

Hi. :today should be passed in :inputs. See https://www.reddit.com/r/logseq/comments/y8zgu3/how_to_query_block_property_with_date_between/ for a similar question. See https://docs.logseq.com/#/page/Advanced%20Queries for more example queries. Better place to ask this question would be in #queries discord channel

[DimitryDushkin]

Hi. :today should be passed in :inputs. See https://www.reddit.com/r/logseq/comments/y8zgu3/how_to_query_block_property_with_date_between/ for a similar question. See https://docs.logseq.com/#/page/Advanced%20Queries for more example queries. Better place to ask this question would be in #queries discord channel

Hey! That's mine question on reddit (I've updated the post to avoid confusion now) :) And passing it to inputs doesn't work. I mistakenly though it worked since it returned all tasks, but as I said in this issue no matter what dates I pass to the query it always returns all blocks.

And I was asking questions in other channels in Discord, but never got answers, so didn't try this time.