Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Preset Filters -Playlist File Mode

Home Register
Log In
By Preset Filters -Playlist File Mode
jeff
3/10/2011
3:40:57 PM

--quote:
"In the UDM wizard, is there any way to look at a range of distances? Reason is, because of my real job ( lol ) a lot of my play is done during the week at night. Two tracks that fit that bill are Delta and Charles Town. Obviously, because of the configuration of those tracks, you can't group the 4.5 and 5F races in with the 6.5 and 7F races. They would be considered "sprints" but are certainly much different.

So, is it possible to look at only 6.5 and 7F races instead of just 6.5 or 7F in the distance selector? I guess I could use the avoid 4.5F or 5F filter? However, I don't see a way to apply special filters in the UDM wizard?"
--end quote


There's an area in the program called Preset Filters that stems from the way the program evolved over the years. Access tables are limited to 255 fields per record. In 2004-2005 as I got closer and closer to that 255 fields per record limit - I needed to find a creative way to add handles for new factors as they were added to the program. I created something called filter codes. A filter code is simply a string of text characters that can be entered into a single field in the table. This solved the immediate problem in that it enabled me to create logic in the program to recognize and handle an (almost) unlimited number of filter codes - which in turn could be stored in a single field in the profile table as part of the UDM definition.

Ok. Reading back what I just wrote it reads like "geek talk."

I'll try and lay it out for you in plain English from here...

To add min and max distance constraints to a UDM you are going to add filter codes for min and max distance. Here are the steps:

1. Bring up the UDM in the UDM Wizard.

2. On the modify screen, select "Filters" as the factor from the factors drop down.

3. Click the Preset Filter Tool button. The filter codes drop down in the preset filter tool contains 700+ preset filter codes. The drop down responds to key strokes. The filter codes for min and max distance begin with numbers.

Let's say for the sake of argument you wanted to add a min distance constraint to your UDM of 6.5 furlongs.

Let's also say for the sake of argument that you wanted to add a max distance constraint of 7.0 furlongs.

Open up the filter codes drop down and key in a 6. The drop down will "jump" to the numeric filter codes dealing with distance starting with the number 6. From there, scroll down a little (a mouse wheel helps.)

You want to add the specific filter code "6.5FMIN" (without the quote characters) to the UDM Definition -- So select "6.5FMIN avoid distance < 6.5 furlongs" (again without the quote characters) from the filter codes drop down.

This will cause the filter code "6.5FMIN" (without the quote characters) to appear in the small preview window (almost there.)

Look at the filter code you are about to add to the UDM Definition. Once you are ok with what you see in the small preview window, click the ADD Filter button. This will move the filter code to the big preview window.

Next, let's add the 7 furlong max distance constraint to the UDM. Select "7.0FMAX avoid distance > 7.0 furlongs" from the filter codes drop down... double check the small preview window... and click the ADD Filter button.

Once you are satisfied with all of the filter code(s) you see in the big preview window, click the SAVE and CLOSE button. This will close the Preset Filter Tool and write all of the filter codes in the big preview window to the UDM Definition.

Hint: A partial list of preset filter codes can be found in the Preset Filters help Doc here:

http://www.jcapper.com/helpDocs/Preset_Filters.html

Sorry for being so long winded. Hope I managed to answer your question in a way that makes sense,


-jp

.

Reply
jeff
3/10/2011
3:54:12 PM

--quote:
"Kind of #2 but in the Data window factors are available that aren't available in the UDM wizard? Any way to make use of those factors in the UDM wizard? Form Cycle for example?"​"
--end quote


Same procedure as above. You are going to add filter codes for min and max FormCycle.

Hint: All of the filter codes dealing with FormCycle begin with the characters "FCYCLE" (without the quote characters.)

Hint: The filter codes drop down responds to Keystrokes. Type "FC" (without the quote characters) to make the drop down "jump" to the FCYCLE filter codes.



-jp

.


Reply
Reply

Copyright 2008 JCapper Software              back to the JCapper Message Board              www.JCapper.com