|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | How Do I Exclude Off the Turf in My UDM | |
| crestwood1972 7/24/2012 11:27:01 AM | My UDM works across all surfaces and distances but performs poorly for races taken off the turf. I checked and was unable to find a filter that I could employ to exclude these races. How can I accomplish this?
| |
| jeff 7/24/2012 4:01:56 PM | Playlist File Mode UDMs- First, the racing surfaces: D - Outer main dirt course d - Inner dirt course O - Off the Turf (race carded for the turf but run on a dirt course) T - Outer or main turf course t - Inner turf course Next, the list of available surface definitions for use in UDMs taken from the surface drop down on the UDM Wizard Modify Screen: D - Restricts horses flagged by the UDM to outer main dirt course only. d - Restricts horses flagged by the UDM to inner dirt course only. O - Restricts horses flagged by the UDM to races taken off the turf only. D* - Restricts horses flagged by the UDM to include D, d, and O surfaces above. (Think it through and you'll realize the D* designation causes the UDM to avoid T and t surfaces.) T - Restricts horses flagged by the UDM to main turf course only. t - Restricts horses flagged by the UDM to inner turf course only. * - Causes the UDM to flag horses on any and all surfaces. (Or no surface restriction.) Q. So how do you make a playlist file UDM avoid off the turf races? A. By giving it a D, d, T, or t surface restriction - or put another way - by NOT giving it a D* or O surface definition. Depending on how you are using your UDMs and what you want from them - this may involve multiple UDMs. If you have a single all purpose UDM - and you want it to avoid off the turf races - CLONE IT - and then give each clone its own unique surface definition. Examples... Each clone of an all purpose UDM can have the following possible surface designations: D - This clone, if created, would only flag horses on the outer or main dirt course. d - This clone, if created, would only flag horses inner dirt courses. T - This clone, if created, would only flag horses on an outer or main turf course. t - This clone, if created, would only flag horses on an inner turf course. The strategy involves creating a clone for each specific surface you want handled. If you think it through, because none of the clones have a D* or O surface definition - the collection of clones never flags a horse in an O (off the turf) race. Yet at the same time, the collection of clones handles each of the surfaces that you DO want handled... Effectively accomplishing the goal of complete avoidance of off the turf races. -jp . ~Edited by: jeff on: 7/24/2012 at: 4:01:56 PM~
| |
| jeff 7/24/2012 12:48:19 PM | SQL Mode UDMs- First, the racing surfaces: D - Outer main dirt course d - Inner dirt course O - Off the Turf (race carded for the turf but run on a dirt course) T - Outer or main turf course t - Inner turf course Next, from the Table Scema, these are the values for the intsurface field in the starterhistory table: Field Name Data Type Description Q. So how do you make a SQL Mode UDM avoid off the turf races? A. It's easier to accomplish in SQL Mode than it is in playlist file mode because in SQL Mode you can reference values in the intsurface field directly. Basically, you just add a line to the sql expression driving the UDM referencing the appropriate intsurface field value. Here are 4 examples: 1. AND INTSURFACE <> 3 2. AND NOT INTSURFACE = 3 3. AND INTSURFACE < 3 AND INTSURFACE > 3 4. AND INTSURFACE <= 2 AND INTSURFACE >= 4 So if you have an all purpose SQL Mode UDM, one that has no restriction for surface, and you want it to avoid off the turf races - adding the following line to the expression driving the UDM should do the trick: AND NOT INTSURFACE = 3 -jp . ~Edited by: jeff on: 7/24/2012 at: 12:48:19 PM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |