Re: [fossil-users] Feature Request: Search Technotes

2017-02-14 Thread Chris Rydalch
Had some time during lunch, and figured out how to list the tech-notes in descending order: $ fossil sqlite3 -R myclone.fossil "SELECT substr(tagname,7), tagxref.rid, max(tagxref.mtime) FROM tag, tagxref WHERE tagname GLOB 'event-*' AND tagxref.tagid=tag.tagid GROUP BY 1 ORDER BY mtime DESC"

Re: [fossil-users] Feature Request: Search Technotes

2017-01-24 Thread Richard Hipp
On 1/24/17, Chris Rydalch wrote: > > I started by trying to combine them, mainly because I'm not a very good > programmer (most of my experience is with Python), and I was thinking this > would be the easiest way. > I agree that combining tech-notes with wiki seems like the

Re: [fossil-users] Feature Request: Search Technotes

2017-01-24 Thread Chris Rydalch
Thanks, good to know they're getting through. No (successful) patches yet, haven't been able to get it to work. I've tried getting technotes to show up alongside wiki results: *db_multi_exec(* * "WITH event(name,rid,mtime) AS ("* * " SELECT substr(tagname,6), tagxref.rid,

Re: [fossil-users] Feature Request: Search Technotes

2017-01-24 Thread Richard Hipp
On 1/24/17, Chris Rydalch wrote: > Is this a complicated issue? Haven't had any luck in this thread, or > another technote-related email I sent to the group. > > I'm not sure if the lack of responses is because the emails aren't actually > making it to the group, I was having

Re: [fossil-users] Feature Request: Search Technotes

2017-01-24 Thread Chris Rydalch
Is this a complicated issue? Haven't had any luck in this thread, or another technote-related email I sent to the group. I'm not sure if the lack of responses is because the emails aren't actually making it to the group, I was having issues with fossil-users list a while back. Either way, it'd be

[fossil-users] Feature Request: Search Technotes

2017-01-18 Thread Chris Rydalch
I really like the concept of technotes, but it'd be super useful if technotes could be included in search results. I find technotes are convenient for adding information and reminders, sort of a work-journal, but I really miss not having that information show up in search results. Could they be