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

Help with custom queries

BorgataBorgata Member Posts: 22
in The Database
Hi all,

I was trying to create two queries, but it seems that Query Creation Page don't allow me to fulfill my needs.

The queries are:
- Worst euro-dollar exchange rate (it seems there is no chance to create it, it must be predefined and I can only find the £-$ one).
- A page "on the fly" created from a specific list of sets (something like: SELECT * FROM Sets WHERE Number IN ('1111', '2222', "3333", etc... ) ).

Is there any chance to obtain these?

Thanks!

Comments

  • BorgataBorgata Member Posts: 22
    Maybe is it the wrong section for this question?
  • HuwHuw Administrator Posts: 7,088
    I've added the Euro price field to the query builder: thanks for the reminder as that's a relatively new field in the database.

    BrickLists are the better way of creating a list of specific sets.
  • BorgataBorgata Member Posts: 22
    Thanks for the answer and the addition!

    So I've to create a "bricklist"... Ok, now I only have to understand what is a bricklist and use it! :p
  • BorgataBorgata Member Posts: 22
    EDIT:
    I was Trying bricklists but... how can I add a bunch of sets all together?
    Insert sets one by one makes it not useful for my purpose.
    I'll make some other try.
  • JosephJoseph Member Posts: 629
    edited February 2014
    If the sets you want are all in a row, you can just list the first and last ones with a dash in between (example: 9469-9473).
    There used to be a method for doing exactly what you are taking about (I believe by separating the set numbers with commas) but I don't think that works any more.
  • BorgataBorgata Member Posts: 22
    Thanks.
    I made some try, but it seems that even the addition of consecutive sets doesn't work.
    Anyway, usually the list I use contains scattered sets.

    Bricklists are a great idea, much better than the query I requested, but if I need to add items one by one, it is very uncomfortable (besides the field "Notes" is requested, so it is even more slow).
  • BorgataBorgata Member Posts: 22
    edited February 2014
    @Huw
    I notice that you added only the "Retail Price in EUR" field but not the "EUR:USD Price Ratio" one, that was what I need to create the "Worst €:$ exchange rate" query.

    Any chance to have a "mass upload" function for bricklists?

    PS: a NOTE about what I wrote above: the trick to add consecutive sets doesn't work for bricklists, but works in site's search.
  • HuwHuw Administrator Posts: 7,088
    What exactly are you trying to achieve? Maybe I have a solution.
    Joseph said:

    If the sets you want are all in a row, you can just list the first and last ones with a dash in between (example: 9469-9473).
    There used to be a method for doing exactly what you are taking about (I believe by separating the set numbers with commas) but I don't think that works any more.

    You're right, it doesn't work any more although, actually, it wouldn't be that hard to add it back. I'll see what I can do...

  • BorgataBorgata Member Posts: 22
    edited February 2014
    Huw said:

    What exactly are you trying to achieve? Maybe I have a solution.

    A simple and fast way to populate a bricklist inserting a bunch of sets all together and not one by one.

    For example I've a list of sets like this one (not too long because it is for example purposes):
    6073, 6235, 6245, 6382, 6657, 6368, 6687, 4010, 6508, 6507, 6652, 6630, 6360
    and I want to create a bricklist to show these sets to a friend.
    Inserting one by one is a very slow process, while submitting all the list together (for example as a comma separated list) would be much more practical.
  • HuwHuw Administrator Posts: 7,088
    edited February 2014
    http://brickset.com/sets?query=6073-1, 6235-1, 6245-1, 6382-1, 6657-1, 6368-1, 6687-1, 4010-1, 6508-1, 6507-1, 6652-1, 6630-1, 6360-1

    I might add the ability to upload sets to a BrickList in future but this method will hopefully suffice for now, subject to the max length of a URL, of course.
  • BorgataBorgata Member Posts: 22
    Yes, it is enough for now, thanks! :)

    I hope to see massive "upload" of sets for bricklists soon!
    I'm thinking to upload my sets list to brickset and it is very long, unthinkable to upload the sets one by one.

    Any news about €:$ price ratio? (and any other combination if you want, such as £:€ !)
  • HuwHuw Administrator Posts: 7,088
    I need to add some more fields to the database view to provide those ratios, I'll see if I can get them in this week.
  • BorgataBorgata Member Posts: 22
    Great, thanks!
  • BorgataBorgata Member Posts: 22
    Hi Huw,
    Did you threw in the sponge for the missing price ratio?
    More complicated than expected ?
    I hope you will find a way to implement it soon.
  • HuwHuw Administrator Posts: 7,088
    €:$ and £:€ are now implemented for use in the query builder.
  • BorgataBorgata Member Posts: 22
    Thanks! :)
Sign In or Register to comment.

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com • Amazon

Recent discussions • Categories • Privacy Policy • Brickset.com

Howdy, Stranger!

It looks like you're new here. Sign in or register to get started.

Sign In Register

Categories

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.