| Time |
Nick |
Message |
| 07:45 |
|
redavis joined #evergreen |
| 07:49 |
|
bott_grpl joined #evergreen |
| 08:46 |
|
mmorgan joined #evergreen |
| 08:51 |
|
mantis1 joined #evergreen |
| 09:05 |
|
dguarrac joined #evergreen |
| 10:24 |
|
mmorgan1 joined #evergreen |
| 10:57 |
|
sandbergja joined #evergreen |
| 11:01 |
|
redavis joined #evergreen |
| 11:01 |
redavis |
Bmagic++ |
| 11:04 |
|
Dyrcona joined #evergreen |
| 12:00 |
pinesol |
News from commits: LP2109745 Color correction for heading 2 (staff) <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=a90440c7a53fff9d8feff78f61a2bae2d0464d0d> |
| 12:17 |
csharp_ |
@decide fast or slow |
| 12:17 |
pinesol |
csharp_: go with fast |
| 12:17 |
csharp_ |
pinesol: wrong |
| 12:17 |
pinesol |
csharp_: well, that's what you get for not being a shell script |
| 12:59 |
berick |
got you there |
| 14:11 |
* Dyrcona |
gets tired of working around action trigger issues. I'm on my fifth program to fix things because every time we make changes to our process to resolve issues something different/new pops up. |
| 14:14 |
|
collum joined #evergreen |
| 14:30 |
pinesol |
News from commits: LP2111283 Fix button type on bib ID/TCN search <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=1f5d2c8e0449423dfd3a80181e51d2ddb19f41eb> |
| 14:30 |
pinesol |
News from commits: LP 1890629: Make Self-Registration Opt-in Settings Lookup Tree Aware <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=6493ac73e950a8d3bd682279a1f9bd7d129f301d> |
| 14:41 |
Dyrcona |
It's not clear in the documentation, so I wonder if I can do a left join on a table with itself using an alias in a CStore JSON query..... I guess I'll have to try it and see. I supposed I could always use DBI to pull the initial data and hand it over to Evergreen calls if I can't get it to work. |
| 14:43 |
berick |
Dyrcona: you can do that |
| 14:44 |
Dyrcona |
berick: I thought so, it just looks like it will be kind a complicated. I suppose I refer to the joined tables with +alias in the where and select clauses? |
| 14:44 |
berick |
https://github.com/evergreen-library-system/Evergreen/blob/main/Open-ILS/src/perlmods/lib/OpenILS/Application/Circ/Holds.pm#L1699 |
| 14:44 |
berick |
easier than that |
| 14:45 |
Dyrcona |
Well, it has to be a left join in two cases. |
| 14:45 |
berick |
that may not match your exact use case |
| 14:46 |
Dyrcona |
I left join atev with itself, join with circ and left join circ with itself. |
| 14:48 |
Dyrcona |
I essentially want to turn this into a JSON query, and I'll likely add some columns to the output. |
| 14:48 |
Dyrcona |
https://paste.debian.net/1375568/ |
| 14:57 |
Dyrcona |
i think the from is going to get complicated.... |
| 15:01 |
pinesol |
News from commits: LP2109643 Browser default font size for self-checkout <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=df5fcca60753c25156546a207ccc0de72103fb22> |
| 15:01 |
pinesol |
News from commits: LP1911063 Part Hold List Exclude Unholdable Parts <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=15ca8e2ca6942bdceec1ea05107b01c374a6eccb> |
| 15:01 |
pinesol |
News from commits: LP1911063 Part Hold List Exclude Unholdable Parts <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=1d6ba2b8d2074f6e443db2c329fb8496a12f1263> |
| 15:01 |
pinesol |
News from commits: LP1911063 Part Hold List Exclude Unholdable Parts <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=572ae64bc430106f530e35e2b59e7622bd90db79> |
| 15:01 |
pinesol |
News from commits: LP2078713 Label for OPAC privacy waiver name field <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=b726e5a1f5d668ef5059b89232bba1a452084786> |
| 15:01 |
pinesol |
News from commits: LP2096790 Browse Courses form layout <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=014bb049c0ed1e4265cf0d48197a3bc9bce0fb3b> |
| 15:01 |
pinesol |
News from commits: LP2096790 Course, Advanced Search layout tweaks <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=55b03d2fb51001fba8431aad242e969743c8984f> |
| 15:01 |
pinesol |
News from commits: LP2096790 Make Course Search match Advanced Search <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=5c33804fe3f3c2e159d060f4ac8c19dca5bef8c0> |
| 15:08 |
Dyrcona |
Now, I'm getting an odd number of elements in hash error trying to transform that into a json query. I'm only doing atev and circ to start. |
| 15:09 |
Dyrcona |
OK. fixed that, but I get no rows back when I should get some. |
| 15:10 |
Dyrcona |
maybe I have fkey and field bacwards? |
| 15:19 |
Dyrcona |
In the end, it might be easier to search action_trigger_event with the left join, then grab the circulation data later. |
| 15:20 |
Dyrcona |
I fixed some syntax issues and I am getting results with just atev and circ. I've not tried the left joins, yet. |
| 15:31 |
pinesol |
News from commits: LP2080887 Dark Mode: White Flash Betweeb Ang/AngJS <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=4a0ab93c888738b5ca77fb4a53560b29874133b7> |
| 15:31 |
pinesol |
News from commits: LP1819068 Offset for AngJS focused primary button <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=fbbe827ff2e259a0273fc9b2f953a9ffda0283ed> |
| 15:31 |
pinesol |
News from commits: LP2102217 Holdings View Sublibrary Sort Order <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=3df0ccdcd7322af0a798cedf8d31839da99e4f69> |
| 15:31 |
pinesol |
News from commits: lp2098718 Holdings_View_Unreadable_Text <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=4c67fc697bc54e1f408a565c252523d69d4404c0> |
| 16:01 |
pinesol |
News from commits: LP2089184: Run perl unit tests on Github Actions <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=5690c1533f239a04f4e84b4ac46bfe294306899c> |
| 16:01 |
pinesol |
News from commits: LP#2103535 Shelving Location Order Spacing Issue <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=ca9ba41bd6a7e76fae44b73439de495842e55881> |
| 16:01 |
pinesol |
News from commits: LP2104272 Follow-up: style tweaks for Self-check <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=609f0c9e1d210cce38f853763d5b070091cdbbf6> |
| 16:01 |
pinesol |
News from commits: LP2104272 Self-check tweaks for use with ChromeOS kiosks <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=09b4c062927a47843885c61ff7771ffd6482693f> |
| 16:01 |
pinesol |
News from commits: LP2099938 Checkbox border contrast & background color <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=e980c5972d1d055fe18829faaa36ddea60945c14> |
| 16:17 |
Dyrcona |
Well, I'm definitely not getting the syntax to join circ again for the renewal correct. |
| 16:24 |
Dyrcona |
I got the left join on atev with itself to work. |
| 16:25 |
Dyrcona |
So, maybe now I can get the left join on circ to work. |
| 16:29 |
Dyrcona |
Ooh. that works now. I might try a slightly different syntax. |
| 16:31 |
Bmagic |
Dyrcona: I think you and I are working on the same thing. I'm trying to solve an autorenewal JSON filter that seems to somehow still include circulations that have a null value for auto_renewal_remaining |
| 16:34 |
Dyrcona |
Bmagic: Not at all. I'm trying to fix autorenewals that fail. |
| 16:34 |
Dyrcona |
Here's my query represented a Perl equivalent of JSON: https://paste.debian.net/1375588/ |
| 16:36 |
Dyrcona |
Bmagic: I'm not sure that the event filter will work in that case. IIRC, the reactor takes over at the point where you want that checked. |
| 16:44 |
Bmagic |
Here's my JSON filter: https://pastebin.com/JNqaPfRL and here's the query that is produced: https://pastebin.com/Tt3dBFud |
| 16:59 |
|
spagnod left #evergreen |
| 16:59 |
Bmagic |
It sure seems like it shouldn't include null values, but it does |
| 17:00 |
Bmagic |
maybe, like you said, the perl code gathers up other circulations outside of the filter somewhere during execution |
| 17:00 |
Bmagic |
(the query doesn NOT include null values) |
| 17:00 |
Bmagic |
so the filter is working at least up to that point |
| 17:05 |
|
mmorgan1 left #evergreen |
| 17:35 |
|
sandbergja joined #evergreen |
| 23:50 |
|
sandbergja joined #evergreen |
