Shopping at LEGO or Amazon?
Please use our links: LEGO.com Amazon
As an Amazon Associate we earn from qualifying purchases.

SQL query - how to select 'Date added to my collection'?

BooTheMightyHamsterBooTheMightyHamster Northern edge of London, just before the dragons...Member Posts: 1,293
I'm trying to build a query to list out all the sets I've bought (and therefore added to my collection in the Brickset database) since a particular date.  While I can browse 'My sets' and order by 'Date added', I suspect that's ordering by the date that the set was added to the Brickset database, not the date I added it to my collection.

Anyone know if this is do-able, please?

Thanks!

Boo 

Comments

  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,455
    It's not possible. The date you added it is not recorded,  to keep database size down.

    Sorry!
    Astrobricks
  • BooTheMightyHamsterBooTheMightyHamster Northern edge of London, just before the dragons...Member Posts: 1,293
    No worries!  Thanks @Huw

    How's it going?  Any punctures yet?  
    Baby_Yoda
  • PaperballparkPaperballpark UK / KLMember Posts: 3,453
    Huw said:
    It's not possible. The date you added it is not recorded,  to keep database size down.

    Sorry!
    Are sets in the DB list for each person ordered by when they were added? So for example the second set you add will be in the DB list after the first set, and before the third set. Or does it not work like that, and it simply crossreferences to the main DB which sets you own? I suspect it's something like the latter.
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,455
    Yes and you can order by that in the query builder but if you want a set before owning it then it'll be shown in the list out of order.
  • PaperballparkPaperballpark UK / KLMember Posts: 3,453
    Ah I see!
Sign In or Register to comment.

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com Amazon

Recent discussions Categories Privacy Policy

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.