|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Filters in SQL mode.. | |
| ADAnto 2/10/2010 9:12:02 AM | Hello, wondering how can i use the CLEAN filter in SQL mode. I don't see it on the list? is it possible yet? Regards, Tony
| |
| jeff 2/10/2010 1:40:25 PM | Link to Table Schema: http://www.jcapper.com/helpdocs/starterhistorytableschema.html The field name (from the Table Schema) that you want is cantrunxformattrib The value in the cantrunxformattrib field of the starterhistory table for CLEAN horses is 0. The value for DIRTY or XFORM horses is 1. And the value for CANTRUN horses is 2. So, to make a SQL UDM flag CLEAN horses, use a SQL Expression like the following: AND CANTRUNXFORMATTRIB = 0 -jp . ~Edited by: jeff on: 2/10/2010 at: 1:40:25 PM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |