Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Hiding races on HTML Report

Home Register
Log In
By Hiding races on HTML Report
NYMike
12/2/2025
7:13:24 AM
How do I hide races on the HTML report?

On screen five in the Order By section I can add

and Race>= 2

and none of the first races show up on the report.

How do I do that to avoid a race with no will pay? I use this as a UDM to highlight a race with no will pay. I'm trying versions of this but cannot get it to work

AND INSTR('3,4,6,7,8,9', RACE) > 0
AND INSTR('ZIA', TRACK) > 0

Is it possible?

Thanks,

Mike

Reply
jeff
12/3/2025
12:54:41 PM
You have to identify the races that'll have will pays.

And there's a bit of daily maintenance work involved.

But it's possible.

Suppose for the sake of argument your definition of will pays is double will pays (not pick3, pick4, pick5, etc.)

For tracks with rolling doubles the only race without a will pay is R1.

For tracks with that situation, for example today's 12-03-2025 MVR card:

And doing this entirely from inside of a UDM:

You could add a track-race constraint to a UDM like this:

AND NOT (TRACK='MVR' AND RACE=1)


And of course the daily maintenance part would be looking at the wager list for the next MVR card and making sure nothing has changed as relates to races where doubles are offered.

For tracks that don't offer rolling doubles you need to look the card over and identify races where doubles are offered. And from there, add a track-race constraint excluding races without will pays.

Using today's 12-03-2025 RPX card as an example, doubles are offered in R1 and R8 only.

That means R1 and R3 through R8 are not going to have double will pays.

For that situation:

And doing this entirely from inside of a UDM:

You could add a track-race constraint to a UDM like this:

AND NOT (TRACK='RPX' AND RACE=1)
AND NOT (TRACK='RPX' AND RACE BETWEEN 3 AND 8)


And of course the daily maintenance part would be looking at the wager list for the next RPX card and making sure nothing has changed as relates to races where doubles are offered.

Fyi, UDMs can have multiple track-race constraints, and placement of parenthesis characters is crucial:

For example:

AND NOT (TRACK='MVR' AND RACE=1)

AND NOT (TRACK='RPX' AND RACE=1)
AND NOT (TRACK='RPX' AND RACE BETWEEN 3 AND 8)




-jp
.














Reply
NYMike
12/3/2025
1:17:44 PM
Jeff,
This is perfect.

I'm not using it in a way that needs daily maintenance as that would be a pain. An example would be MNR Race 3 that is always a non will pay race.

I just want to weed out races that I don't need to see right now.

Thanks,

Mike

Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com