JCapper Message Board

JCapper 101
-- Second Call Last Out

Home	Register Log In

Second Call Last Out

jeff
5/22/2013
9:47:28 PM

--quote:

"Jeff, Could you provide examples for using position and beaten lengths at the second call last out in a UDM? Thanks."

--end quote

It's easy.

SQL Mode
From the Table Schema, here are the relevant field names:


Field Name   Data Type       Description
----------   -------------   ----------------------------------------
len2call     number single   beaten lengths at second call last start
pos2call     number integer  position at second call last start

The following line illustrates how to restrict starters returned to only those that were in front at the second call last out:

AND pos2call = 1

The following 2 lines illustrate one way of restricting starters returned to only those that were within 2 lengths of the leader at the second call last out:

AND (pos2call = 1 OR (pos2call > 1 AND len2call <= 2))

Note that in in the above expression, positioning of the parenthesis characters is critical. (Everything wrapped inside of parenthesis characters gets evaluated first and is then treated as if it were a single expression.)

Note: Always a good idea to double check your work by running the expression through the Data Window with the data broken out by whatever factor you are working with. (That applies here.)

-jp

.

jeff
5/22/2013
9:58:34 PM

Playlist File Mode
Handles for second call last out (both position and beaten lengths) are provided as Preset Filter Codes. All of them begin with the characters "2CALL" (without the quotes.)

-jp

.

JCapper Message Board

JCapper 101 -- Second Call Last Out

JCapper 101
-- Second Call Last Out