Theo Todman's Web Page - Notes Pages

1. It’s necessary to keep a copy of the text of the note (ie. without the data embedded by the Functors) as it is too big to paste into the Notes table with the Functor data in it should changes need to be made.
2. The counts and lists are produced by Functors in this page, which are Documented Here³. However, there are on occasion other tables to maintain.
3. To make it easier for me to ensure this maintenance is up to date, I’ve documented the Functors that create the tables further down this page; here⁴. This is the main purpose of this Note.
4. The Functors that create the counts in the lists immediately below all run off the primary queries used to generate the Tables, so don’t require detailed documentation.

1. Statistical Tables
   1. PID Notes referenced in the Text of my Thesis, by Chapter⁵
   2. PID Notes referenced in the Chapter Note-Lists of my Thesis, by Chapter⁶
   3. PID Notes CrossTab by Reading-List Category⁷
   4. PDFs available on Local Website₈ (4,300 items)
2. Items requiring Action
   5. PID Notes not yet referenced in the Text or Note-Lists of my Thesis⁹ (6 items)
   6. PID Notes not yet referenced in the Chapter Note-Lists of my Thesis¹⁰ (5 items)
   7. PID-Related Books not referenced¹¹ (14 items)
   8. PID-Related Papers read but not referenced¹² (33 items)
   9. Works Cited by Thesis Chapter but not in Note-List Reading Lists¹³ (273 items)
   10. PID Papers filed but not referenced in PID Notes¹⁴ (113 items, 1 unactioned)
   11. Undated PID Papers referenced in PID Notes¹⁵ (120 items)
   12. PID Papers without Abstracts referenced in PID Notes¹⁶ (730 items)
   13. Large Pages with > 1,000 hyperlinks¹⁷ (141 items)
   14. Papers with allegedly locally-held PDFs not linked to¹⁸ (438 items)
   15. Papers allegedly in Electronic book but not flagged as held electronically¹⁹ (43 items)
   16. Suspected Duplicate Papers²⁰ (0 items)
   17. Webrefs – defunct or without narratives – in PID Papers²¹ (27 items)
   18. Webrefs – defunct or without narratives – in PID Books²² (6 items)
   19. PID Papers with PDF Local Copies not Cited in Thesis²³ (241 items)
   20. Aeon Papers relevant to my Thesis with outstanding actions²⁴ (185 items)

1. Statistical Tables
   1. PID Notes referenced in the Text of my Thesis, by Chapter:
      • Functor 21, Option 14
      • Uses
        → PID_Notes_Used_By_Thesis_Chapter_Xtab
      • This query works off the Cross_Reference table, so no maintenance is required.
      • Strictly-speaking, not just the ‘Text’ but includes the items in the Chapter Note-List.
   2. PID Notes referenced in the Chapter Note-Lists of my Thesis, by Chapter:
      • Functor 21, Option 16
        → PID_Notes_Used_By_Thesis_Chapter_List_Xtab
      • Runs off the Thesis_Note_XRef table, which is best maintained via:-
        → Thesis_Note_XRef_List
      • In principle, each Note should only appear against one Thesis Chapter. I have now made this the case by suppressing from this Table those Notes that are suppressed from the Reading List by being so flagged on the Thesis_Note_XRef table.
   3. PID Notes CrossTab by Reading-List Category:
      • Functor 21, Option 19
        → PID_Notes_RL_Category_Xtab
      • The query runs off the PID_Note_Reading_Lists table.
      • This is rather an odd HTML Table. Its aim was to show which Notes have their reading lists categorised in some way, and which do not.
      • Now, all items are Categorised as “General” by default, so I segregate out this category as well as any that might arise without a category.
   4. PDFs available on Local Website:
      • Link to Note 1319₂₅, containing Functor 22, Option 12
        → PDF_File_List
2. Items requiring Action
   5. PID Notes not yet referenced in the Text or Note-Lists of my Thesis:
      • Functor 22, Option 5
        → PID_Notes_Unused_By_Thesis
   6. PID Notes not yet referenced in the Chapter Note-Lists of my Thesis:
      • Functor 22, Option 11
        → PID_Notes_Unused_By_Thesis_Note_Lists
   7. PID-Related Books not referenced:
      • Functor 21, Option 18
        → IdentityBooks_Unreferenced_Gen, then
        → IdentityBooks_Unreferenced
   8. PID-Related Papers read but not referenced:
      • Functor 21, Option 15
        → IdentityPapersRead_Unreferenced_Gen, then
        → IdentityPapersRead_Unreferenced
   9. Works Cited by Thesis Chapter but not in Note-List Reading Lists:
      • Functor 21, Option 17
        → Works_Missing_By_Thesis_Chapter
   10. PID Papers filed but not referenced in PID Notes:
       • Functor 21, Option 23
         → PID_Books_To_Regen, then
         → PID_Papers_Filed_Not_Referenced
   11. Undated PID Papers referenced in PID Notes:
       • Functor 21, Option 24
         → PID_Papers_Referenced_Undated
   12. PID Papers without Abstracts referenced in PID Notes: Functor 21, Option 25
       → PID_Papers_Referenced_No_Abstract
   13. Large Pages with > 1,000 hyperlinks:
       • Functor 21, Option 26
         → Large_Page_List
   14. Papers with allegedly locally-held PDFs not linked to:
       • Functor 21, Option 27
         → PDF_Missing_List
   15. Papers allegedly in Electronic book but not flagged as held electronically:
       • Functor 21, Option 34
         → Papers_Inconsistently_Electronic
       • The above query excludes items with “Audio” or “Video” in the Paper Title, as well those that have Paper Abstract starting with “Full Text”. This is the way to get them off the list!
   16. Suspected Duplicate Papers:
       • Functor 21, Option 28
         → Duplicate_Papers
   17. Webrefs – defunct or without narratives – in PID Papers:
       • Functor 21, Option 29
         → Missing_Webref_DisplayText_List
       • A method I devised to make the correction of these discrepancies easier is as follows:-
         1. Delete all old rows from Missing_Webref_DisplayText_List_Editable.
         2. Run Missing_Webref_DisplayText_List_Editable_GEN to add new rows to the table.
         3. Open query Missing_Webref_DisplayText_List_Editable_List, which runs off this table and allows easy editing of WebRefs_Table (to correct any dud WebRefs, where this is possible, and to add Narratives where the WebRefs are active, or revived) and Paper Comments (to remove irreparable links).
            
   18. Webrefs – defunct or without narratives – in PID Books:
       • Functor 21, Option 32
         → Missing_Webref_DisplayText_List_Books
   19. PID Papers with PDF Local Copies not Cited in Thesis:
       • This section firstly has a summary table by PID-Note showing the totals of outstanding PDFs,broken down into ‘Pending’, ‘Reserved’ and ‘Unclassified’, with links to the further tables below. Uses Functor 21, Option 33, which in turn uses:-
         → PID_Missing_Online_Papers_List_Summary, using
         → PID_Missing_Online_Papers
       • Functor 21, Option 30
       • Firstly, the “Table” is split into multiple sections which are themselves HTML Tables, one for each associated PID Note. This is so that those Notes can refer back to the relevant part of this Page using Functor 23, Option 22. It’s aesthetically displeasing that the mini-Tables don’t have the same column-widths.
       • Basically, the Table-collection is generated via:-
         → PID_Missing_Online_Papers_List, using
         → PID_Missing_Online_Papers
       • The table is best maintained using PID_Missing_Online_Papers_Editable_List, which returns rows in the same sequence as the Table, and ignores rows with either “Accept” or “Drop” set to ‘true’.
       • Rows are added to the PID_Missing_Online_Papers using the query PID_Missing_Online_Papers_Add, which runs automatically as part of the Recalculation and Housekeeping process.
       • There are 6 Flags on the PID_Missing_Online_Papers Table:-
         1. Accept: This Paper is ready to be added to PID_Note_Reading_Lists via PID_Note_Reading_Lists_Append.
         2. Pending: Set manually. Means I haven’t decided what to do yet.
         3. Reserve: Set Manually. Means I’ve not decided to either drop or accept, but am “thinking about it”.
         4. Drop: Set Manually. Means I’ve decided against this Paper, which will not be added to the Thesis reading lists. The rows have to be retained or they’ll get added back in.
         5. PDF_OK: Set Manually. Means I’ve checked that I really do have the PDF on disk. If I can’t find it I need to set the “On Laptop” Flag on Papers to False, and then delete this row.
         6. PID_RL_OK: Can be set Manually, but best to use PID_Missing_Online_Papers_RL_OK_Set after ensuring “Accept” and “PDF_OK” are set. In due course, these rows can be deleted.
            
       • Use PID_Papers_Referenced_Undated_Editable to set dates.
       • I need a similar procedure to the above for Books.
         • Use PID_Books_Referenced_Undated_Editable to set dates.
   20. Aeon Papers relevant to my Thesis with outstanding actions
       • Functor 22, Option 15
         → Aeon_Papers_Task_List
       • This runs off the Aeon_Files table and selects items with Review_Group set to 1 and Review_Date_Logged & Review_Status set as required.

Summary of Notes Referenced by This Note

To access information, click on one of the links in the table above.

Summary of Notes Citing This Note

To access information, click on one of the links in the table above.

Text Colour Conventions

1. Blue: Text by me; © Theo Todman, 2025