|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Horses only ? Males | |
| JustRalph 10/30/2010 6:29:09 PM | in playlist mode I have a udm that I have used for a while. I ran it based on sex and find that horses listed as "horses" perform better and I am trying to figure out how to clone it and use it for "horses" only. I found the info on adding a 3 letter code to the profile table......but there is no designation for "horses" anybody wanna give me a tip on an easier way to do this? 66 208 .3173 0.9806 f (filly) 18 42 .4286 1.3245 m (mare) 41 108 .3796 1.1732 c (colt) ROI 1.4450 10 20 .5000 1.5452 h (horse) I know it's a small databse......but I want to tinker with it a little.......any ideas appreciated
| |
| jeff 10/30/2010 9:45:13 PM | From the preset filters list: http://www.jcapper.com/presetfilters.asp Age and Sex Filters: FilterCode: C5 When this filter is applied, horses that are 5 years in age or older are filtered out of Maiden Claiming Races. FilterCode: 3O When this filter is applied, horses that are 3 years old are filtered out if they are facing older horses in today's race. The FilterCode is 3O with an alphabetic "O" character not a numeric "0" or zero character. FilterCode: GENF When this filter is applied, horses with a sex code of f (Fillies) are filtered out. FilterCode: GENM When this filter is applied, horses with a sex code of m (Mares) are filtered out. FilterCode: GENC When this filter is applied, horses with a sex code of c (Colts) are filtered out. FilterCode: GENH When this filter is applied, horses with a sex code of h (Horses) are filtered out. FilterCode: GENG When this filter is applied, horses with a sex code of g (Geldings) are filtered out. FilterCode: GENR When this filter is applied, horses with a sex code of r (Ridglings) are filtered out. If you want to make a playlist file mode UDM flag horses only, you have to filter out the others. Adding the following filter codes to a playlist file mode UDM is one way to do this: GENF-GENM-GENC-GENG-GENR In sql mode, you would use the sex field of the starterhistory table. To make a sql UDM flag only horses, add something like the following line to your sql expression: AND SEX = 4 -jp . ~Edited by: jeff on: 10/30/2010 at: 9:45:13 PM~
| |
| JustRalph 11/5/2010 3:17:49 PM | Thanks very much Jeff......... Good stuff !!
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |