| Time |
Nick |
Message |
| 07:35 |
|
collum joined #evergreen |
| 07:41 |
|
kworstell-isl joined #evergreen |
| 07:59 |
|
BDorsey joined #evergreen |
| 08:10 |
|
BDorsey_ joined #evergreen |
| 08:10 |
|
cbrown-isl joined #evergreen |
| 08:24 |
|
Dyrcona joined #evergreen |
| 08:33 |
|
cbrown_isl joined #evergreen |
| 08:42 |
|
mmorgan joined #evergreen |
| 08:42 |
|
mantis joined #evergreen |
| 10:15 |
Dyrcona |
hrm.....quandary.... I want to get circulations that are not checked in, excluding lost and paid for. Sounds easy, dunn'it? However, the SQL that we've been using for years doesn't work, but lost and paid that are not checked in still show up. |
| 10:17 |
Dyrcona |
Oh! AND.... It's a left join. |
| 10:20 |
Dyrcona |
Ohh. got it and it's relatively easy: checkin_time is null and not (stop_fines = 'LOST' and xact_finish is not null) |
| 10:31 |
* Dyrcona |
has a hunch we need something even more sophisticated, but that's a problem for another day. |
| 10:37 |
jeff |
I don't often use NOT (...), but in this case, that comes in handy because it (among other things) saves you from needing to do something like AND (stop_fines IS NULL OR stop_fines <> 'LOST') |
| 10:40 |
Dyrcona |
Yeahp. This might be the first time I've directly used it like that. I've probably done it via CSTORE before. |
| 11:13 |
|
Christineb joined #evergreen |
| 11:45 |
|
jihpringle joined #evergreen |
| 11:49 |
|
mantis left #evergreen |
| 12:17 |
|
dmoore joined #evergreen |
| 13:26 |
|
mantis joined #evergreen |
| 13:52 |
|
kworstell_isl joined #evergreen |
| 14:30 |
|
kworstell-isl joined #evergreen |
| 14:33 |
|
kworstell_isl joined #evergreen |
| 15:25 |
|
mantis left #evergreen |
| 16:10 |
|
jvwoolf joined #evergreen |
| 16:44 |
|
jvwoolf left #evergreen |
| 16:59 |
|
mmorgan left #evergreen |
| 17:21 |
|
rlefaive joined #evergreen |
| 17:53 |
|
rlefaive joined #evergreen |
| 18:07 |
|
rlefaive joined #evergreen |
| 18:24 |
|
rlefaive joined #evergreen |
| 19:02 |
|
rlefaive joined #evergreen |
| 19:37 |
|
rlefaive joined #evergreen |
| 20:09 |
|
rlefaive joined #evergreen |
| 20:16 |
|
rlefaive joined #evergreen |
| 20:34 |
|
rlefaive joined #evergreen |
| 20:52 |
|
rlefaive joined #evergreen |
| 21:15 |
|
JBoyer joined #evergreen |
| 21:28 |
|
rlefaive joined #evergreen |
| 22:05 |
|
rlefaive joined #evergreen |
| 22:26 |
|
rlefaive joined #evergreen |
| 22:37 |
|
rlefaive joined #evergreen |
| 22:54 |
|
rlefaive joined #evergreen |
| 23:13 |
|
rlefaive joined #evergreen |
| 23:47 |
|
rlefaive joined #evergreen |
