Hello, is there a way to generate summaries of all notes created in a specific year? I’ve attempted to combine two searches—one for notes created after January 1, 20xx, and another for notes created before December 31, 20xx—using the “??" operator, but it hasn’t worked. It seems that the “??" operator is not recognized as a valid operator. Any suggestions?
I think you are on to the right track.
I just tested, and you can create searches like this:
\creation-date(after: 01/01/2020)
and
\creation-date(before: 01/01/2021)
If you create those two, I think it will do what you want.
1 Like
Unfortunately, it doesn’t appear to be functioning for me. When I conduct a search for the year 2023, it retrieves notes from 2022 or 2021, as well as from 2023. Could it be possible that my database is corrupted? If that’s the case, is there a method to rebuild it?
Did you setup the search like I described? Note that the creation-date is not the same as the date you add to the note. Can you perhaps post a screenshot of the search you made?
I think it is unlikely that your database is corrupted. More likely there is a bug in search. But let me know, and I’ll see if I can track it down.
I’m afraid there’s a bug with the search feature. Here’s a screenshot of my search as requested. It’s easy for me to test this because I only have four notes from 2023, as I didn’t use Agenda that year (I had to switch to Windows).
By the way, the same type of search works correctly when I use the “assigned date” parameter.
One more thing: my OS language is set to American English. When I write the date as dd/mm/yyyy, Agenda correctly recognizes and displays the date in words. For instance, if I write 31/12/2022, Agenda interprets it as “December 31, 2022.” However, it doesn’t perform the correct search unless I input the date as mm/dd/yyyy.
So the search does work, but only with the wrong date format?
The search does work when using the “assigned-date” parameter. When using the “creation-date” parameter, the search does not yield the expected results regardless of the date format used.
I tested 3 projects in 3 different categories in one test using the search suggested by @drewmccormack. There were 42 notes total with text, headers, links, attachments, events and todos. I had 5 notes that I know shouldn’t have been there. Three had creation dates more recent than last edited because they were moved; two were re-used(Bad Habit). I think I remember having a discussion with @mekentosj regarding this happening on merged and split notes. A merged note that is the primary (note merged to) is to me not new, it’s edited. The note from the secondary is a child of the primary and no longer exists. A primary split note retains it’s created date and the secondary that is split off becomes arguably new or retains the create and edit date/times of the parent.
It couldn’t have anything to do with the “and” term there right? I think that is just matching the word “and”, not making a logical AND.
By default, searches with multiple tokens will use AND. You can change that by clicking on the tokens and setting them to “optional” in the filter mode.
I wasn’t aware of that, thank you. I based my understanding on the information in the help pages, which mention that boolean operators can be used. I also saw that “??” can be used in place of “AND,” but when I typed “??,” I didn’t see any noticeable effect.
I’ll give it another shot without using “AND.” By the way, do boolean operators function properly in searches or not?
I think && may be an and operator, but the default operator is already an “and”. We favor more the option of clicking on the tokens to indicate whether they must be present, or can just optionally be present.
Understood. After making several attempts to search for notes by creation date, I unfortunately have to say that the search doesn’t yield the expected results. There is probably some technical intervention needed at the level of the search engine.
OK, I’ll investigate. So the problem is searching for two date ranges and-ed together, correct?
Correct. Creation dates, not other date types.
I have made some changes, and tested, and I think this is working now. Will be in the next minor update, so please do check it.
All right, thank you for following up on this.