Selection ID query across markets

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lbwZach
    Junior Member
    • Nov 2023
    • 1

    #1

    Selection ID query across markets

    Excuse me if this hasn't been answered yet, I tried searching for the answer and couldn't find anything that definitively answered my question, and if the answer is out there I wasn't able to find it.

    In a database I am looking to store orders I have placed as part of that. The main identifiers will be the market id and selection id. The only markets this is for is for Australian Horse Racing and only on the win market, NOT place market.

    When I store the market id and selection Id, I understand that those two combined together will definitely be unique.

    However, if a horse races on a certain day it will have a selection id. When this runner/selection inevitably races in the future. Will the selection id be the same, or will it have a new selection id in the future?

    Thanks in advance!
  • jabe
    Senior Member
    • Dec 2014
    • 705

    #2
    That's a good question, but I don't know the answer. I suspect it's yes, but you should be able to check it easily enough. FInd a horse that has recently run twice and make the necessary calls to see what its selection ids were in those races, either with a bit of extra code in your program or with the test thingy. And let us know what you find!

    Comment

    • pwebtech
      Member
      • Apr 2021
      • 49

      #3
      yes selectionIds are stable across races, easy check is to look back at some histrorical data and you see the same IDs being used each time a horse runs

      Comment

      Working...
      X