| *** Jan_Garaj3 has joined #zope | 00:09 | |
| *** giacomos has joined #zope | 00:23 | |
| *** J1m has quit IRC | 00:46 | |
| *** J1m has joined #zope | 00:47 | |
| *** J1m has quit IRC | 00:52 | |
| *** giacomos has quit IRC | 00:59 | |
| *** dixond has quit IRC | 01:07 | |
| *** dixond has joined #zope | 01:21 | |
| *** Jan_Garaj3 has quit IRC | 01:22 | |
| *** rbanffy has joined #zope | 01:22 | |
| *** supton has quit IRC | 01:28 | |
| *** Jan_Garaj3 has joined #zope | 01:30 | |
| *** menesis has quit IRC | 01:42 | |
| *** Jan_Garaj3 has quit IRC | 01:51 | |
| *** rbanffy has quit IRC | 03:45 | |
| *** do3cc has quit IRC | 03:49 | |
| *** do3cc has joined #zope | 04:02 | |
| *** [Arfrever] has quit IRC | 06:14 | |
| *** [Arfrever] has joined #zope | 06:17 | |
| *** projekt01 has joined #zope | 07:37 | |
| *** tisto has joined #zope | 08:08 | |
| *** yvl has joined #zope | 09:15 | |
| *** __mac__ has joined #zope | 09:20 | |
| *** agroszer has joined #zope | 09:23 | |
| *** avoinea has joined #zope | 09:25 | |
| *** avoinea has joined #zope | 09:26 | |
| *** PeterZ1 has joined #zope | 10:05 | |
| *** PeterZ1 has left #zope | 10:05 | |
| *** giacomos has joined #zope | 10:06 | |
| *** maurits has joined #zope | 11:12 | |
| *** menesis has joined #zope | 11:55 | |
| *** projekt01 has quit IRC | 13:14 | |
| *** projekt01 has joined #zope | 13:42 | |
| *** menesis has quit IRC | 13:57 | |
| *** rbanffy has joined #zope | 14:06 | |
| *** yvl has quit IRC | 14:37 | |
| *** Gogo|tty has quit IRC | 14:37 | |
| *** Gogo|tty has joined #zope | 14:37 | |
| *** yvl has joined #zope | 14:37 | |
| *** PeterZ1 has joined #zope | 14:38 | |
| *** PeterZ1 has left #zope | 14:38 | |
| *** menesis has joined #zope | 14:55 | |
| *** __mac__1 has joined #zope | 15:29 | |
| *** __mac__ has quit IRC | 15:31 | |
| *** J1m has joined #zope | 16:27 | |
| *** __mac__1 has quit IRC | 16:52 | |
| *** agroszer has quit IRC | 17:02 | |
| *** rbanffy_ has joined #zope | 17:46 | |
| *** rbanffy has quit IRC | 17:49 | |
| *** projekt01 has quit IRC | 18:16 | |
| *** Jan_Garaj3 has joined #zope | 19:00 | |
| *** maurits has quit IRC | 19:06 | |
| *** tisto has quit IRC | 19:09 | |
| *** Jenkens has joined #zope | 19:10 | |
| Jenkens | would anyone here have any ideas why my zope grids sorted by 'creation date' in descending order do not always order right? This is a custom app based on Zope and the team who manages it isn't really sure | 19:11 |
|---|---|---|
| Jenkens | well, sorting by any numerical value or date.. | 19:12 |
| Jenkens | or is this a better question for solr? | 19:12 |
| *** giacomos has quit IRC | 20:09 | |
| betabug | Jenkens: it's a pretty hopeless question, without any details it's hopeless to know what goes wrong | 21:13 |
| Jenkens | what would you like to know? | 21:14 |
| betabug | e.g. what does mean "not always order right" | 21:14 |
| betabug | ? | 21:14 |
| Jenkens | ok, if i sort by date descending | 21:14 |
| Jenkens | you'd hope 10/21 10:45 would come before 10/21 10:44 in the grid view | 21:14 |
| Jenkens | however.. sometimes it doesn't happen that way | 21:14 |
| Jenkens | 10:44 comes before 10:45 (the creation date of the file) | 21:14 |
| betabug | now it depends on what you are doing there | 21:14 |
| Jenkens | ok | 21:15 |
| betabug | what indexes are you using for sorting, etc. | 21:15 |
| Jenkens | that i'm not sure of.. this isn't my code base | 21:15 |
| Jenkens | i'm just digging for ideas to relay | 21:15 |
| betabug | well, if they are sorting on a stringified date/time thing, it better be ISO dates based | 21:15 |
| Jenkens | well, it also does this on a 'size' field too | 21:16 |
| betabug | otherwise if it's a DateIndex from the zope catalog, I guess it should work out of the box | 21:16 |
| Jenkens | which i'd assume is integer | 21:16 |
| Jenkens | if i put the size column into my grid and sort descending | 21:16 |
| Jenkens | you'd hope you'd see 1MB at the top, 900K below it, etc... | 21:16 |
| betabug | it's all just assumptions ;-) | 21:16 |
| Jenkens | but instead it's a jumble | 21:16 |
| betabug | apart from "this stuff should usually work on zope", what answer could one give you? | 21:16 |
| Jenkens | i dunno? | 21:17 |
| Jenkens | "go ask in solr".. assuming that's the indexer? | 21:17 |
| betabug | maybe they have text fields that contain "1MB" and "900K" and they sort on that alphabetically (for a totally stupid guess)? | 21:17 |
| betabug | what is solr? | 21:17 |
| Jenkens | is solr not part of zope? | 21:17 |
| Jenkens | apache solr? | 21:17 |
| betabug | never heard of it | 21:18 |
| Jenkens | i was told that was part of the search caching/mechanism | 21:18 |
| betabug | no, not part of zope AFAIK | 21:18 |
| Jenkens | i see mentions of collective.solr when searching for solr+zope or solr+plone | 21:18 |
| Jenkens | hrmm | 21:18 |
| Jenkens | alright | 21:19 |
| betabug | that would be some product that integrates solr with something zopeish or ploneish | 21:19 |
| betabug | so the problem could come up somewhere on that line of communication there | 21:20 |
| Jenkens | http://i.imgur.com/Ru8QrQR.png | 21:21 |
| Jenkens | here's an example | 21:21 |
| Jenkens | transition time is easier to see because that colum shows hh:mm:ss in the field, where creationdate (the one I typically use) does not | 21:21 |
| Jenkens | column* | 21:21 |
| betabug | maybe it sorts only on the date, not the time at all? | 21:23 |
| Jenkens | possibly, but 'it used to work' is all i can say | 21:23 |
| betabug | all I can do is just shoot some darts with blind eyes, totally useless | 21:24 |
| Jenkens | we had a crash, restored the data/db from a backup.. reloaded the custom CMS and now we have ethis weird sorting issue | 21:24 |
| betabug | you need to debug what's going back and forth there | 21:24 |
| *** menesis has quit IRC | 21:24 | |
| Jenkens | alright.. just thought i'd see if anyone had seen something similar or had an idea | 21:24 |
| betabug | not me, sorry | 21:24 |
| Jenkens | fair enough | 21:24 |
| *** Jenkens has left #zope | 21:27 | |
| *** avoinea has quit IRC | 22:02 | |
| *** menesis has joined #zope | 22:15 | |
| *** menesis has quit IRC | 22:17 | |
| *** menesis has joined #zope | 22:18 | |
| *** Jan_Garaj3 has quit IRC | 23:03 | |
| *** rbanffy_ has quit IRC | 23:06 | |
| *** Jan_Garaj3 has joined #zope | 23:28 | |
| *** stereo__ has joined #zope | 23:50 | |
Generated by irclog2html.py 4.0.0 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!
