Quote:
Originally Posted by wold
Thanks. Mhmm, in the DB there are various dates stored. Used now is 'time altered'. A sync could explain them being equal, or manual insertion - but that matters less now.
To properly investigate this the SQL rows are needed. I'll add a debug function to show those ASAP.
In the meantime, if you can run a SQL query on books.db, then see the code below. Ensure the original DB row number are shown under settings > annotation viewer. Added in now are those from the screenshot.
Code:
--for the item data
SELECT * FROM Items WHERE OID IN (690, 736, 751, 756, 758, 759)
--for the tag data
SELECT * FROM TAGS WHERE ItemID IN (690, 736, 751, 756, 758, 759)
The UI issues will get also get fixed. |
For the item data I get the following results:
OID ParentID TypeID State TimeAlt HashUUID
788 787 4 0 1654799165 74D7B0C5-57D2-5469-8CDF-C63CAC6E9C40
841 787 4 0 1654799165 062335FC-045A-503A-9AA9-6936EFBEDE1D
863 787 4 0 1654799165 7FC99316-843A-5125-AB56-DB4D6C1BB42B
869 787 4 0 1654799165 88010505-62D2-5842-9B6E-4EE54E95753C
871 787 4 0 1654799165 8a51847e-b269-4e9b-a99a-900d91471664
872 787 4 0 1654847212 919bc2f9-69e0-4d44-8c9d-fd911ca16d7d
For the tags data I get the results:
OID ItemID TagID Val TimeEdt
8636 788 101 {
"created" : 1654358266,
"updated" : "2022-06-04T15:58:23Z"
}
1654358304
8637 788 102 note 1654777571
8639 788 105 {
"text" : "magenta, page 2, 2022-06-04",
"updated" : "2022-06-09T12:26:10Z"
}
1654777571
8640 788 106 magenta 1654507566
8658 788 104 {"begin":"pbr:/page?page=2&offs=19#epubcfi(/6/6!/4/2[toc]/4/2[cover]/2/1:0)","end":"pbr:/page?page=2&offs=24#epubcfi(/6/6!/4/2[toc]/4/2[cover]/2/1:5)","text":"Cover","updated":"2022-06-06T09:24:58Z"} 1654799165
8632 841 102 note 1654777585
8634 841 105 {
"text" : "green, page 1, 2022-06-06",
"updated" : "2022-06-09T12:26:24Z"
}
1654777585
8635 841 106 green 1654507645
8656 841 101 {"anchor":"pbr:/page?page=1&offs=92#epubcfi(/6/4!/4/2/6/1:6)","created":1654507644,"updated":"2022-06-06T09:27:24Z"} 1654799165
8657 841 104 {"begin":"pbr:/page?page=1&offs=92#epubcfi(/6/4!/4/2/6/1:6)","end":"pbr:/page?page=1&offs=102#epubcfi(/6/4!/4/2/6/1:16)","text":"Consortium","updated":"2022-06-06T09:27:24Z"} 1654799165
8642 863 102 note 1654777556
8644 863 105 {
"text" : "yellow, page 3, 2022-06-07",
"updated" : "2022-06-09T12:25:55Z"
}
1654777556
8645 863 106 yellow 1654588179
8659 863 101 {"anchor":"pbr:/page?page=3&offs=185#epubcfi(/6/8!/4/2/4/6/1:5)","created":1654588178,"updated":"2022-06-07T07:49:38Z"} 1654799165
8660 863 104 {"begin":"pbr:/page?page=3&offs=185#epubcfi(/6/8!/4/2/4/6/1:5)","end":"pbr:/page?page=3&offs=196#epubcfi(/6/8!/4/2/4/6/1:16)","text":"publication","updated":"2022-06-07T07:49:38Z"} 1654799165
8647 869 102 note 1654777613
8649 869 105 {
"text" : "cyan, page 4, 2022-06-08",
"updated" : "2022-06-09T12:26:52Z"
}
1654777613
8650 869 106 cian 1654665052
8661 869 101 {"anchor":"pbr:/page?page=4&offs=643#epubcfi(/6/8!/4/2/10/10/1:126)","created":1654665051,"updated":"2022-06-08T05:10:51Z"} 1654799165
8662 869 104 {"begin":"pbr:/page?page=4&offs=643#epubcfi(/6/8!/4/2/10/10/1:126)","end":"pbr:/page?page=4&offs=651#epubcfi(/6/8!/4/2/10/10/1:134)","text":"complete","updated":"2022-06-08T05:10:51Z"} 1654799165
8652 871 102 note 1654777439
8654 871 105 {
"text" : "red, page 5, 2022-06-09",
"updated" : "2022-06-09T12:23:58Z"
}
1654777439
8655 871 106 red 1654777439
8663 871 101 {"anchor":"pbr:/page?page=5&offs=197#epubcfi(/6/10[xhtml-001]!/4/4[visual-010]/4/1:144)","created":1654777438,"updated":"2022-06-09T12:23:58Z"} 1654799165
8664 871 104 {"begin":"pbr:/page?page=5&offs=197#epubcfi(/6/10[xhtml-001]!/4/4[visual-010]/4/1:144)","end":"pbr:/page?page=5&offs=203#epubcfi(/6/10[xhtml-001]!/4/4[visual-010]/4/1:150)","text":"change","updated":"2022-06-09T12:23:58Z"} 1654799165
8668 872 102 note 1654846954
8670 872 105 {
"text" : "blue, page 6, 2022-06-10",
"updated" : "2022-06-10T07:42:34Z"
}
1654846954
8671 872 106 blue 1654846928
8672 872 101 {"anchor":"pbr:/page?page=7&offs=538#epubcfi(/6/12[xhtml-002]!/4/2[sample-text]/6/7:85)","created":1654846929,"updated":"2022-06-10T07:42:08Z"} 1654847212
8673 872 104 {"begin":"pbr:/page?page=7&offs=538#epubcfi(/6/12[xhtml-002]!/4/2[sample-text]/6/7:85)","end":"pbr:/page?page=7&offs=544#epubcfi(/6/12[xhtml-002]!/4/2[sample-text]/6/7:91)","text":"called","updated":"2022-06-10T07:42:08Z"} 1654847212
To get the right data I needed to replace for the queries the original ids as you mentioned.
I hope I could provide you with the the data you were looking for
