Please refrain from posting animated GIFs, memes, joke videos and so on in discussions other than those in the off topic area.

Dismiss this message to confirm your acceptance of this additional forum term of use.

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

BooTheMightyHamsterBooTheMightyHamster Northern edge of London, just before the dragons...Member Posts: 1,281
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,388
    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,281
    No worries!  Thanks @Huw

    How's it going?  Any punctures yet?  
    Baby_Yoda
  • PaperballparkPaperballpark UKMember Posts: 3,388
    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,388
    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 UKMember Posts: 3,388
    Ah I see!
Sign In or Register to comment.
Recent discussions Categories Privacy Policy