JCapper Message Board

JCapper 101
-- UDM construction...

Home	Register Log In

UDM construction...

SILVER01HDW
2/3/2025
3:52:06 PM

How can I create a UDM with a condition...

Like ...

RANKF01 > 1 or PACETOP < 3 or STAGEREADINESS > 0

UDM could click on with either one of these conditions ..maybe a example would help :)

thank you

~Edited by: SILVER01HDW on: 2/3/2025 at: 3:50:57 PM~

~Edited by: SILVER01HDW on: 2/3/2025 at: 3:52:06 PM~

jeff
2/4/2025
9:10:16 AM

Here's a link to a post about combining multiple SQL UDMs I made back in 2014:
http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=1736&forum=JCapper%20101

What happens if we replace 'X' with individual sql commands? (Substitution.)

Instead of SELECT * FROM STARTERHISTORY WHERE (X) if we replace 'X' with '(A) OR (B) OR (C) OR (D)' our sql expression now looks like this:

SELECT * FROM STARTERHISTORY WHERE

((A)

OR (B)

OR (C)

OR (D))

The above sql expression can be used as Template to handle any number of constraints inside of a single UDM.

In the above sql expression:

((A) is a single sql constraint.
(B) is a second single sql constraint.
(C) is a third single sql constraint.
(D)) is a fourth single sql constraint.

Using parenthesis characters ( before the first constraint and ) after the last constraint to 'enclose' or 'wrap' the multiple constraints is the key to making it work.

Using what you posted as an example:

RANKF01 > 1 or PACETOP < 3 or STAGEREADINESS > 0

After applying the Template, the resulting sql looks something like this:

AND ((RANKF01 > 1) or (PACETOP < 3) or (STAGEREADINESS > 0))

-jp
.

SILVER01HDW
2/5/2025
6:56:52 AM

appreciate that..thx

but after running that
why is pacetop 3 showing?
shouldn't it be blank?

~Edited by: SILVER01HDW on: 2/5/2025 at: 6:55:28 AM~

~Edited by: SILVER01HDW on: 2/5/2025 at: 6:56:52 AM~

SILVER01HDW
2/5/2025
6:56:29 AM

SQL: SELECT * FROM STARTERHISTORY
WHERE [DATE] >= #01-01-2025#
AND [DATE] <= #12-31-2025#
AND ((RANKF01 > 1) OR (PACETOP < 3) OR (STAGEREADINESS > 0))

Code:
Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 25666.42 26380.48 26811.24
Bet -35644.00 -35644.00 -35644.00
-----------------------------------------------------
P/L -9977.58 -9263.52 -8832.76

Wins 2190 4369 6470
Plays 17822 17822 17822
PCT .1229 .2451 .3630

ROI 0.7201 0.7401 0.7522
Avg Mut 11.72 6.04 4.14

By: PaceTop

Value P/L Bet Roi Wins Plays Pct Impact AvgMut
----------------------------------------------------------------------------------
0 -7328.56 26368.00 0.7221 1585 13184 .1202 0.9784 12.01 PaceTop: FALSE FigTop: FALSE
1 -905.16 3696.00 0.7551 261 1848 .1412 1.1493 10.69 PaceTop: FALSE FigTop: TRUE
2 -1441.06 3744.00 0.6151 211 1872 .1127 0.9173 10.91 PaceTop: TRUE FigTop: FALSE
3 -302.80 1836.00 0.8351 133 918 .1449 1.1790 11.53 PaceTop: TRUE FigTop: TRUE

SILVER01HDW
2/5/2025
7:01:12 AM

like this

Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 24133.22 24971.84 25390.80
Bet -33808.00 -33808.00 -33808.00
-----------------------------------------------------
P/L -9674.78 -8836.16 -8417.20

Wins 2057 4122 6103
Plays 16904 16904 16904
PCT .1217 .2438 .3610

ROI 0.7138 0.7386 0.7510
Avg Mut 11.73 6.06 4.16

By: PaceTop

Value P/L Bet Roi Wins Plays Pct Impact AvgMut
----------------------------------------------------------------------------------
0 -7328.56 26368.00 0.7221 1585 13184 .1202 0.9880 12.01 PaceTop: FALSE FigTop: FALSE
1 -905.16 3696.00 0.7551 261 1848 .1412 1.1606 10.69 PaceTop: FALSE FigTop: TRUE
2 -1441.06 3744.00 0.6151 211 1872 .1127 0.9263 10.91 PaceTop: TRUE FigTop: FALSE
3 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 PaceTop: TRUE FigTop: TRUE

~Edited by: SILVER01HDW on: 2/5/2025 at: 7:01:12 AM~

jeff
2/5/2025
10:38:43 AM

--quote:

"appreciate that..thx

but after running that
why is pacetop 3 showing?
shouldn't it be blank?"

--end quote

Q. Why is PaceTop = 3 Showing?

A. Because you are using the OR keyword in your sql expression.

W3Schools.com OR vs. AND
https://www.w3schools.com/sql/sql_or.asp

To remove PaceTop = 3 from the query results returned by the sql expression you posted - you could add a second PaceTop constraint using the AND keyword.

Like this:

SELECT * FROM STARTERHISTORY
WHERE [DATE] >= #01-01-2025#
AND [DATE] <= #12-31-2025#
AND ((RANKF01 > 1) OR (PACETOP < 3) OR (STAGEREADINESS > 0))
AND NOT PACETOP = 3

Or like this:

SELECT * FROM STARTERHISTORY
WHERE [DATE] >= #01-01-2025#
AND [DATE] <= #12-31-2025#
AND ((RANKF01 > 1) OR (PACETOP < 3) OR (STAGEREADINESS > 0))
AND PACETOP < 3

-jp
.

SILVER01HDW
2/5/2025
10:52:55 AM

thanks

JCapper Message Board

JCapper 101 -- UDM construction...

JCapper 101
-- UDM construction...