Re: [Tracker] Sparql grouping by year/mont

[Michele Tameni <michele tameni it>]

Thankyou so much!

With this bit of info I'm able to do what I need:

tracker-sparql -q "SELECT  distinct fn:month-from-dateTime(?d) as ?m  fn:year-from-dateTime(?d) as ?y { ?resource a nmm:Photo ; nie:contentCreated ?d;    nie:url ?url }"

Now i have a list of month/year where I taken an image.

Great!

Thankyou again!

I'll have a look at Carlos branch tomorrow.

Michele

2015-10-10 20:28 GMT+02:00 Sam Thursfield <ssssam gmail com>:

On 10/10/15, Sam Thursfield <ssssam gmail com> wrote:
> Looking thru the SPARQL 1.1 standard, it does define MONTH() and
> YEAR() functions that do the same thing, and Tracker doesn't implement
> those, so it's a bit confusing. It would be quite an easy patch to fix
> that, if someone has some free time .. :)

Seems Carlos is way ahead of me ... this is in the
wip/garnacho/sparql1.1 branch:
https://git.gnome.org/browse/tracker/commit/?h=wip/garnacho/sparql1.1&id=f5a09f2db0d5b3e2fd869299750a953eb9fb4b97

--

michele tameni