benwbrum / fromthepage

61%

development: 68%

LAST BUILD ON BRANCH 4751-sql-optimizations-part-2

branch: 4751-sql-optimizations-part-2

CHANGE BRANCH

x

Reset

• 4751-sql-optimizations-part-2
• 042022-gem-updates
• 1042-stats-on-summary-admin-dashboard
• 1171-description-owner-works-tab
• 1171-project-description-owner-works-tab
• 1202-standardize-config-files
• 1216-deeds-and-document-sets
• 1216-deeds-and-sets-revisited
• 1278-add-support-email
• 1279-add-newsletter-post-link
• 1281-switch-to-sassc
• 1322-visits-show-wrong-time
• 1331-next-page-after-completed-work
• 1334-include-owner-names-search
• 1378-allow-images-rotation
• 1385-handle-text-markup-sidebar
• 1389-dont-lose-collection-on-import
• 1428-reafactor-has-untranscribed-pages
• 1435-show-private-projects-to-collaborators
• 1439-fix-footer-text-alignment
• 1443-dont-email-opt-out-users
• 1444-export-display-version
• 1446-ocr-conditionalizing-language
• 1446-redux
• 1447-make-titles-clickable
• 1449-bulk-export-api
• 1464-links-on-duplicates
• 1469-fix-friendly-id-issue
• 1470-fix-broken-iiif-url
• 1476-admin-collection-list
• 1480-IA-annotations
• 1482-bump-devise
• 1491-fix-notes-breaking-with-long-title
• 1497-subject-page-performance
• 1503-content-dm-vanity-urls
• 1504-coveralls
• 1507-mark-blank-redirect
• 1511-add-abstractxmlhelper-tests
• 1513-filter-eventless-ahoy-visits
• 1526/image-filters
• 1531-replace-zoomer-with-openseadragon
• 1544-remove-email-display
• 1552-show-more-notes
• 1552-show-more-notes-from-dev
• 1557-4572-html-export-fixes
• 1559-limit-trial-page-count
• 1560-individual-researcher-message
• 1563-page-translation-status-api
• 1566-disable-spinner-still-editing
• 1576-extract-ocr-from-pdf-rails4
• 1576-extract-ocr-from-pdf-rails4-spaces
• 1576-extract-ocr-from-pdf-spaces
• 1578-add-formats-export-all-works
• 1585-diff-collection-account-types
• 1588-user-export-mailing-lists
• 1593-disable-still-editing-ahoy-logging
• 1594-fix-admin-user-search
• 1596-tiff-memory-errors
• 1606-fix-indentation
• 1610-attribution-name-for-users
• 1610-devise-changes
• 1611-fix-rake-logging
• 1617-tei-resp-attribution
• 1619-handle-real-names-better
• 1621-add-tei-to-zip
• 1627-fix-export-subjects-url
• 1633-disable-subject-linking
• 1634-show-works-on-empty-list
• 1640-import-metadata-iiif-manifest
• 1645-redirect-to-owner-tab
• 1653-fix-importing-manifest
• 1655-display-private-collections
• 1657-intercom-breaks-iiif-collection-import
• 1660-real-name-for-owners
• 1666-tabular-export-breaks
• 1675-find-a-project-performance
• 1677-inactive-projects-do-not-have-transcribing-buttons
• 1678-no-version-creation-from-ocr
• 1684-hourly-report
• 1687-notify-duplicate-manifest
• 1691_admin_email
• 1692-fix-rmp
• 1696-owner-profile-loses-name-rails4
• 1696-owner-profile-loses-name-rails6
• 1699-limit-api-for-private-collections
• 1704_export_joined_deeds
• 1712-fix-newline-whitespace-plaintext
• 1713-manifest-typo
• 1714-rel-nofollow
• 1717-ia-import-fixes
• 1720-non-transcr-cdm-fts
• 1739-i18n
• 1742-restrict-transcribed-works
• 1748-notes-and-questions
• 1751-tei-subject-categories
• 1752-works-to-collections
• 1754-works-thumbnail-link
• 1756-revert-button-is-hidden
• 1758-use-cdm-fts
• 1761-upload-subjects
• 1761-upload-subjects-unfixed-tests
• 1765-remove-dead-code
• 1767-missing-space-in-needs-review-pages
• 1768-add-footers
• 1778-subject-uri-links
• 1786-move-preview-and-autolink-buttons
• 1796-IIIF-Manifest-on-About-page
• 1803-owner-content-not-flagged
• 1803-user-content-not-flagged
• 1804-other-user-alert
• 1804-other-user-alert-fix
• 1809-reorder-admin-tabs
• 1812-dont-strip-hyphens-on-display
• 1812-retain-dash-in-export
• 1823-lt-gt-signs
• 1824-add-footers-finish
• 1828-remove-new-upload-emails
• 1828-remove-new-upload-emails-finish
• 1832-add-transcriber-docs
• 1833-owned-by-to-project-by
• 1842-progress-shows-blank
• 1844-outdated-ocr-conditional
• 1847-autolink-is-not-mentioned
• 1853-param-in-link
• 1853-rename-email-param
• 1854-inclusive-language-blacklist-to-denylist
• 1854-inclusive-language-whitelist-to-allowlist
• 1858-no-add-a-new-work-when-project-is-inactive
• 1861-edit-fields-to-fields
• 1861-edit-fields-to-fields-new
• 1875-form-feed
• 1886-base-image-fix
• 1887-prerender-deed-url
• 1888-remove-render_anywhere-gem
• 1890-fix-dashboard-locale
• 1891-admin-tabs-regression
• 1897-orphan-notes-break-collection-show
• 1898-notes-for-deleted-pages
• 1900-fix-regression
• 19020tei-regression
• 1903-findaproject-hides-accounts
• 1911-1913-unpermitted-params
• 1914-fixes-tail-logfile
• 1915-fix-daily-emails-regression
• 1918-tei-export-xml-escape
• 1919-combining-subjects-doesnt
• 1926-locale-selection
• 1929-fix-deed-regression
• 1929-fix-domain-regression
• 1938-replace-bookreader-with-osd
• 1943-br-div-to-newline-on-plaintext-export
• 1952-work-assignment-broken
• 1954-search-returns-wrong-docset
• 1966-no-multiauth
• 1971-missing-space-in-message
• 1972-fix-iiif-url-regression
• 1978-owner-profile-performance
• 1986-add-english-fallback
• 1992-duplicate-collection-owners
• 1993-all-collaborator-emails
• 1995-handle-nil-articles
• 1995-mock-objects-for-deeds
• 1998-hide-dashboard-link
• 2000-autolink-regex-escape
• 2010-refactor-link-query
• 2011-fix-thumbnail-size
• 2017-work-search-searches-metadata
• 2023-lat-lon-save
• 2026-optimize-still-editing
• 2034-social-links
• 2035-uri-not-url
• 2036-needs-review-and-mark-blank-not-applied-on-saving-pages
• 2043-fix-notes-reset-bug
• 2044-ahoy-activity-summarizes-ocr
• 2046-fix-cdm-export
• 2051-cdm-export-sync
• 2052-larger-thumbnails
• 2059-improve-default-conventions
• 2062-check-timeout-on-still-editing
• 2087-add-geo-to-non-place-subjects-in-tei
• 2092-add-iiif-collections-route
• 2096-metadata-description
• 2101-enhance-iiif-api
• 2102-end-search-via-get
• 2107-add-ago-to-notes-edits
• 2111-alphebetize-subjects-from-sets
• 2111-list-subjects-alphabetically
• 2118-new-metadata-fields-on-works
• 2119-work-search-doc-set
• 2122-assign-sets-on-import
• 2128-2575-ajax-user-search
• 2128-reviewer-role
• 2129-quality-control
• 2130-add-reviewer-deed
• 2130-new-metadata-in-tei-export
• 2134-remove-collaborators-tab-docsets
• 2139-enforce-chronological-order-in-comparison-diff
• 2144-create-cdm-log-directory
• 2146-further-sso-improvements
• 2148-fix-page-image-upload
• 2152-i18n-contd
• 2155-not-all-hyphens
• 2157-more-tolerant-links
• 2162-bad-notes-message
• 2164-preserve-edit-area-focus
• 2168-order-works-in-sets
• 2175-prerender-deeds-correctly
• 2181-uploads-with-braces
• 2195-carousel
• 2198-project-specific-buttons-hardcode
• 2207-missing-messages
• 2211-metadata-upload-fixes
• 2213-search-user-email
• 2215-work-search-from-document-set
• 2218-cdm-bulk-import
• 2220-advanced-editor
• 2221-long-lines-etc
• 2222-undo-codemirror
• 2223-expan-tag
• 2224-2935-cb-pb-rendering-editor-support
• 2225-render-lb-in-table-cells
• 2231-findaproject-no-setless-owners
• 2238-increase-osd-timeout
• 2239-if-no-field-warning
• 2239-no-field-warning
• 2239-no-fields-warning-alert
• 2246-show-all-notes
• 2251-add-space
• 2253-add-joined-tasks-to-collaborator
• 2257-old-article-edit-path
• 2263-reg-tag
• 2265-arrays-in-imported-manifests
• 2266-add-tag-for-folger
• 2266-catchword-softbreak-marginalia
• 2266-head-tag-for-folger
• 2266-mouseover-lb-text
• 2266-new-abbr-tag-and-hover
• 2268-search-bug
• 2271-riiif-resolver
• 2274-open-api-for-tei-html-exports
• 2277-handle-eventless-visits
• 2289-api-keys
• 2296-2316-performance
• 2298-tei-api
• 2300-button-config
• 2322-subject-details-export
• 2328-fix-422-on-invalidation
• 2328-slug-validation
• 2343-highlight-row-fix
• 2343-spreadsheet-editor
• 2343-spreadsheet-feature
• 2343-test-spreadsheet-config
• 2343-viewer-overlay
• 2348-br-removal
• 2350-index-ia-leaves-page-id
• 2352-category-assignment-in-document-set
• 2360-improve-search
• 2364-error-500-creating-note
• 2367-work-spreadsheet-export
• 2377-doc-sets-start-transcribing
• 2379-unbalanced-parens
• 2380-2342-no-empty-popup
• 2385-organize-subjects-verically
• 2386-latitude-longitude
• 2387-fix-safari-scrolling-issue
• 2391-bulk-tei-empty-work
• 2392-error-displaying-deleted-pages
• 2395-bulk-export-work-download
• 2395-work-export-ui
• 2400-email-blocklist
• 2407-handle-new-cdm-uris
• 2421-free-from-transcription
• 2424-categories-and-doc-sets
• 2429-allow-transcribers-to-delete-subjects
• 2437-static-site-export
• 2442-fix-owner-emails
• 2447-ocr-multiple-cdm
• 2454-contentdm-iiif-uri-pattern
• 2457-initial-image-fit-width
• 2458-bottom-toolbar-buttons
• 2459-no-extension-thumbnail
• 2464-spreadsheet-fields-fixes
• 2465-merge-problems
• 2465-sortable-fields
• 2468-cdm-export-new-url
• 2468-cdm-url-api-2
• 2478-add-row-on-selection
• 2483-field-config-ui-fix
• 2484-rename-column-header-500
• 2490-export-renamed-column-headings
• 2493-autocomplete-instead-of-dropdown
• 2494-table-to-plaintext
• 2500-iiif-metadata-from-work
• 2501-multi-page-fields
• 2504-export-document-sets
• 2508-promulgate-headers-footers
• 2509-checkbox-save-fix
• 2512-remediate-bad-cdm-uris
• 2512-support-old-cdm-iiif
• 2519-expose-status-in-ui-and-export
• 2522-add-tooltips-for-buttons
• 2524-include-metadata-contributors-in-pdf
• 2526-download-warning
• 2539-needs-review-to-transcribing
• 2553-table-export-performance
• 2555-fix-race-condition
• 2555-logging-for-field-and-ledger
• 2556-optional-rend
• 2562-import-xml-source
• 2567-include-metadata
• 2568-work-table-bulk-export
• 2568-work-table-bulk-export-dev-branch
• 2573-backlevel-omniauth
• 2575-settings-page-perf
• 2582-footnote-tag
• 2583-pandoc-2-support
• 2603-wide-footnotes
• 2604-changing-fields-warning
• 2606-fix-fields-reordering
• 2609-logging-for-no-record-exception
• 2613-subject-coocurrence-export
• 2616-bulk-export-regression
• 2616-hand-coded-tables
• 2618-bulk-export-test
• 2622-fix-editor-min-height
• 2626-use-riiif-for-ios
• 2627-no-paren-delimiter
• 2627-parse-subject-hierarchies
• 2628-subject-distribution-export
• 2636-hash-in-metadata-values
• 2648-project-owner-emails
• 2653-fix-dictation
• 2656-export-config-in-list
• 2676-delete-work-after-bulk-export
• 2680-docset-subjects
• 2684-pdf-export-encoding
• 2685-rename-subjects-with-parens
• 2686-transfer-set-documents
• 2705-2627-work-ids-correct-hierarchies
• 2705-docset-api-export
• 2707-preview
• 2711-edit-user-nil-expiration
• 2720-inactive-project-help-link
• 2724-remove-current-password
• 2729-export-failures
• 2737-more-work-exports
• 2738-dictation-codemirror-reprise
• 2748-move-speedometer
• 2751-only-create-default-categories-on-create
• 2753-md-table-codemirror
• 2756-empty-spreadsheet-failure
• 2763-reformat-pdf-metadata
• 2767-about-page-path
• 2792-fix-prev-next-controls
• 2801-metadata-multiselect
• 2802-facets-with-nil-order
• 2810-upload-renames-titles
• 2815-transcription-success
• 2815-try-3
• 2816-multilingual-metadata-imports
• 2826-access-message
• 2827-multi-lingual-facet-labels
• 2835-docsets-bad-on-facets-or-reviewers
• 2837-uniquify-slugs
• 2869-untranscribed-pages
• 2871-missing-transcription-button-translations
• 2872-subject-linking-wording
• 2873-user-about-datatype
• 2875-lines-or-records-stats
• 2880-tei-export-idno-element
• 2881-include-full-url-in-index-csv
• 2883-status-of-works-in-sets
• 2892-no-image-replacement-for-imports
• 2893-creation-date-on-work-export
• 2897-improve-metadata-search
• 2899-apostrophe-in-pdf-metadata
• 28xx-metadata-ui-issues
• 2900-export-subject-article-text
• 2903-owner-becomes-staff
• 2906-review-metadata-description
• 2911-update-page-status-from-settings
• 2912-errant-question-mark
• 2915-non-utf-diacritics-subject-upload
• 2918-add-scribe-route
• 2920-restrict-nuclear-settings
• 2927-deleted-fields-export-error
• 2929-show-incomplete-pages
• 2934-structured-contribution-api
• 2939-ampersands-not-escaped
• 2946-ia-spaces
• 2949-metadata-ui-tweaks
• 2952-work-restricted-no-collaborators
• 2953-work-title-links
• 2956-list-owners-alphabetically
• 2960-voyant-new-tab
• 2961-raw-html-field-instructions
• 2968-remove-rows
• 2970-add-staff-to-edit
• 2974-new-work-field-recipient
• 2976-document-date-hint
• 2976-edtf-document-dates
• 2979-metadata-template-and-download-should-be-consistent
• 2982-limit-doc-sets-owner-page
• 2983-sign-up-for-owner
• 3005-metadata-export-work-id
• 3006-remove-work-versions
• 3012-expand-options
• 3015-guest-404
• 3022-row-config-not-saving
• 3030-speadsheet-data-full-text-search
• 3034-description-in-readwork
• 3041-update-collection-statistics
• 3044-escape-ampersands-on-export
• 3046-metadata-field-not-saving
• 3050-onboarding-static
• 3051-tag-cloud-find-a-project
• 3066-uri-fix-for-quartex
• 3077-exception-logging-for-iiif
• 3088-translation-in-msword-pdf
• 3090-update-owner-statistics
• 3092-recalculate-sample-set
• 3096-numeric-upload-slug-fix
• 3105-500-error-page-image
• 3112-add-ftp-id-to-ss-export
• 3112-workid
• 3116-confused-works
• 3129-hide-review-tab
• 3130-add-http-to-urls
• 3135-update-identifier-in-metadata-upload
• 3138-better-metadata-upload
• 3142-only-public-docsets
• 3142-show-pub-docsets
• 3151-iiif-layers-wrong-work
• 3165-translate-to-french
• 3166-remove-subject-graph-options
• 3172-double-braces-ocr
• 3179-translate-spanish-review
• 3180-translate-portuguese-review
• 3182-show-warning-on-session-timeout
• 3185-document-set-restricuted-api-problem
• 3188-remove-unused-devise-views
• 3191-improve-subject-index-perf
• 3194-autolink-stopwords
• 3300-user-profile-pic
• 3331-fixed-mission-transcription-status-for-indexed-work
• 3352-navigator-fullscreen
• 337-replace-gravatar-for-profile
• 3566-add-contributors-column-in-metadata
• 3605-fixed-reordering-broken-fields
• 3619-improve-owner-dashboard
• 3624-upgrade
• 3624-upgrade-rails-to-current-version-2
• 3631-clone-collection-settings
• 3639-root-convert-into-landing
• 3643-weekly-trial-cohort-less-than
• 3644-search-attempt-lifecycle
• 3644-search-attempt-tracking
• 3680-status-on-page-version-screen
• 3689-sort-work-list-transcibed-based
• 3712-reviewers-on-leader-board
• 3721-header-position-transposed
• 3736-datatables-works-list
• 3738-export-collection-notes
• 3738-export-notes-update
• 3744-spins-after-back
• 3758-fixed-broken-forum
• 3759-improve-collection-settings
• 3769-fix-transcriber-works-list
• 3775-search-docset-bug
• 3776-deed-datatables-bug
• 3779-help-tab-error-of-work
• 3780-slow-statistics-fix
• 3786-performance
• 3790-server-side-datatables
• 3839-new-tag-tools
• 3854-allow-owners-to-delete-subjects-with-links
• 3854-article-delete-bug-fix
• 3936-option-to-include-notes-in-pdf-exports
• 3937-links-clicked-in-read-views-replace-current-tab
• 3962-make-document-sets-read-only
• 4010-4474-small-annoyanaces
• 404-work-edit
• 4041-redo-adding-collaborators-to-restricted-works
• 4103-improve-document-set-settings-tab
• 4129-new-findaproject-performance
• 4129-new-findaproject-performance-part-2
• 4130-externalize-rack-attack-initializer
• 4174-pdf-import-text-layer-fix
• 4203-change-transcribe-to-incomplete
• 4207-dont-titleize-instructions
• 4211-adding-collaborators-refresh-list
• 4223-approved-pages-with-no-changes-need-a-version
• 4224-saved-alert-to-mention-moving-to-next-page
• 4236-missing-subject-popup
• 4243-spreadsheet-header-lose
• 4255-error-making-collection-private
• 4261-debug-bulk-exports
• 4263-Revert
• 4263-bootstrap-css-classes-not-working
• 4263-bootstrap-css-classes-not-working-2
• 4265-bento-no-current-user
• 4269-log-article-deletion
• 4271-rake-called-twice
• 4275-pandoc-error
• 4280-slider-hides-metadata
• 4282-subject-description-codemirror
• 4288-fix-versions-tab
• 4289-switch-text-source
• 4290-improve-collection-page-edit
• 4290-improve-collection-page-edit-v2
• 4294-icons-not-appearing-in-production
• 4300-duplicate-owner-profile-links
• 4302-missing-page-breaks-on-facing-pdf
• 4304-remove-update-ia-work-server
• 4311-missing-display-name-fix
• 4312-document-sets-need-to-show-up-in-tag-cloud
• 4319-fix-500-on-empty-tag
• 4325-carrierwave-allowlist
• 4327-htr-view
• 4330-improve-export-specs
• 4334-add-title-to-all-anchors
• 4340-messageboard-group-duplication-error
• 4343-collection-level-transcription-changes-not-propagating-down-to-works
• 4344-url-encode-images
• 4348-rake-task-imports-all
• 4350-ingestor-hangs-when-an-empty-zipfile-is-uploaded
• 4353-duplicate-work-fix
• 4359-date-spreadsheet
• 4360-unsaved-changes-warning-showing-after-spreadsheet-save
• 4372-notes-filterable-table
• 4374-unbalanced-tag-warn
• 4380-warn-owners-that-collections-settings-are-overridden-by-works
• 4382-cant-add-collaborator-as-owner
• 4383-move-tempfiles-from-public-to-tmp
• 4388-admin-searches-averages-error-fix
• 4394-notes-form-input-sync-fix
• 4406-search-attempt-fix
• 4408-ia-cache-workaround
• 4408-revert-ia-cache
• 4412-ia-vcr-specs
• 4414-fix-typo-in-bulk-export-api
• 4416-replace-thumbnail-when-page-image-is-replaced
• 4424-feedback-on-settings-update
• 4425-add-importmaps
• 4426-inaccessible-scrolling-down
• 4427-hide-bang-header
• 4431-markdown-table
• 4433-page-version-username-should-match-recent-version
• 4434-nested-tei-elements-pdf-export
• 4435-metadata-upload-needs-all-works
• 4438-refactor-js-assets
• 4440-wrong-recent-edits-showing-up-on-a-collection
• 4448-refresh-metadata-text-should-not-show
• 4458-nara-workaround-iiif
• 4458-v3-image-info-tilesource
• 4463-page-transcription-json
• 4464-article-docset-performance
• 4466-rtl-page-navigations
• 4473-works-list-performance
• 4475-tei-export-child-categories
• 4479-remove-works-with-restrict-scribes-as-candidate-for-next-untranscribed-page-calculation
• 4483-work-added-deed-has-duplicate-info-in-template
• 4486-js-served-in-assets-path-not-working
• 4490-broken-osd-iiif-info-quartext
• 4494-slider-image-top
• 4499-cdm-sync
• 4512-findaproject-lists-orgs-with-no-public-documents
• 4516-fix-page-settings-image-picker
• 4518-escape-square-braces
• 4522-delete-notes-on-work-page-or-collection-delete
• 4523-image-pdf-fix
• 4528-add-linebreak-after-table
• 4529-italicized-text-in-tables-doesnt-get-italics-formatting-in-pdf
• 4540-cdm-single-image-item-not-being-imported-via-iiif
• 4551-footers-in-site-search
• 4555-can-transcribe
• 4557-fix-staff-access-for-search
• 4557-staff-access-try-two
• 4557-work-owner-in-es
• 4559-page-reviewed-count-double-counts-fix
• 4562-improve-es-test-coverage
• 4566-missing-collection-images-showing-up-in-browse-tags
• 4567-fix-elasticsearch-user-query
• 4569-fix-error-on-nested-inserts-in-strikethrough-pdf-export
• 4570-error-when-saving-markdown-table
• 4582-cleanup-es-implementation
• 4583-missing-search-key-fix
• 4584-inline-table-csv-export
• 4585-inline-tables-break-plaintext-export
• 4591-4267-support-bold-and-ins-tags
• 4595-restrict-completed-works-for-document-sets
• 4601-disable-public-deed-list
• 4604-new-project-listings-collections-should-contain-works
• 4605-update-page-thumbnail-orientation
• 4607-add-text-help-configuration-on-collection-settings
• 4609-cwgk-subject-enhancements
• 4615-pdf-deletion-nested-in-underline
• 4619-transcribers-with-no-activity-should-redirect-to-findaproject
• 4625-ban-account-creation-from-users-with-spammy-domains
• 4633-add-featured-date-to-collections-and-document-sets
• 4634-upgrade-to-ruby-3.3.5
• 4639-4641-cwgk-importer
• 4640-rename-disambiguator
• 4642-tei-table-export-logic
• 4644-collection-data-export-task
• 4650-add-handling-for-nested-<strike>-tags
• 4654-subject-autocomplete-performance-hotfix
• 4657-works-list-problems
• 4662-background-long-running-subject-name-updates
• 4662-temporary-fix-to-buggy-jobs
• 4670-type-or-rend-hr
• 4672-remove-pretty-formatting
• 4680-add-messageboards-in-import-and-export
• 4688-remove-article-debugger-lines
• 4690-translate-codemirror-height-fix
• 4694-nil-tag
• 4700-create-honeypot-traps
• 4702-contentdm-push-retry
• 4703-include-article-categories-link-in-database-export
• 4705-cwgk-migration-graph
• 4705-fix-rs-graph
• 4721-inefficient-stats-recalculation-per-work
• 4725-fix-wrong-filtering-of-public-collections-on-owner-profile
• 4734-article-rename-race-condition-fix
• 4751-improve-collaborators-page-speed
• 4757-uploaded-metadata-should-update-additional-metadata-attributes
• 4759-metadata-refresh-send-email-and-improve-logs
• 4760-integrate-delayed-job-for-job-monitoring
• 4772-es-updates-should-be-asynchronous
• 4774-es-rake-task-to-catch-up
• 4779-restricted-collection-pages-meaningful
• 4800-subjects-elasticsearch-architecture
• 4803-enhanced-es-search-specs-per-model
• 4805-thread-safe-current-user
• 4823-fix-api-bulk-export-random-ci-fail
• 4826-specs-improvement-pr
• 4832-integrate-solid-queue
• 4840-refactor-mark-as-blank-logic-in-transcribe-page
• 4844-dockerize-ci-heavy-dependencies
• 4851-landing-route
• 4857-require-rubocop-step-in-ci
• 4859-refactor-needs-review-logic
• 4861-embed-coverage-in-readme
• 4863-remove-oink-gem
• 4865-organize-gemfiles
• 4870-when-contents-of-files-matching-image-base_name-is-empty-work-is-still-considered-workocr_correction-true
• 4872-integrate-active-storage-for-document-uploads
• 4880-latex-export-refactor
• 4883-markdown-table-formatting-issues-with-single-apostrophes
• 4884-active-storage-direct-upload
• 4901-extract-head-from-p-in-tei
• 4914-cdm-import-does-not-reindex-properly
• 4919-bulk-export-spec-random-fail-fix
• 4919-fix-bulk-export-random-ci-failure
• 4924-handle-subject-links-inside-table
• 4939-solid-queue-worker-service
• 4941-oprhaned-records-should-not-be-indexed
• 4943-activerecorddeadlocked-mysql2error-on-rename_job
• 4945-refactor-transcribe-preview-action
• 4948-remediate-failed-article-rename-jobs
• 4953-refactor-save-branch-for-transcribe-controller
• 4958-solid-queue-tweaks-and-documentation
• 4959-import-csv-tempfile-fix
• 4965-subject-counts-are-negative
• 4967-update-collection-elasticsearch-rake-task
• 4971-recurring-job-to-delete-old-printouts
• 4973-blank-lines-in-spreadsheet-cells
• 4976-subject-upload-should-populate-all-attributes-of-article-records
• 4979-add-permission-check-on-subjects-upload
• 4984-fix-failing-vcr-specs
• 4985-flash-alert-bug-on-landing-page
• 4986-new-collaborators-duplicate
• 4988-add-cookies-warning-to-ftp
• 4997-ui-and-implementation-for-subject-search
• 4998-collection-block-bug
• 5000-ocr-change-causes-innaccurate-work-statistics
• 5006-missing-param-page
• 5008-metadata-refresh-logs-include-503-errors
• 5009-bulk-cdm-import-es-index
• 5022-intermittent-test-failure-metadata-spec-fix
• 5032-optimize-subjects-page
• 5033-add-search-in-subjects-view
• 5036-flash-message-unhandled-nil
• 5040-seed-privacy-preference-to-hide-cookies-banner
• 5042-underline-within-insertion
• 5051-subject-rename-and-deletion-causes-mysql-lock-timeout-error
• 5078-owner-dashboard-discrepancies-quick-fix
• 5079-refactor-statistics-module-for-owner
• 5081-record-when-a-transcriber-uses-ai
• 5095-fine-tune-gemini-prompt
• 5096-expose-prompt-file-to-gemini-transcribe-task
• 5100-alert-bento-after-registration-when-current-user-is-unset
• 5115-hide-bulk-export-page-under-admin
• 5116-spreadsheet-js-is-broken
• 5120-display-gemini-reasoning-on-ai-tab
• 5121-configure-starting-rows-on-handsontable
• 5124-handle-csv-parsing-with-undefined-characters
• 5124-work-metadata-upload-better-job-logging
• 5136-missing-owner-es-search-bug
• 5140-suspicious-behavior-model-and-large-paste-flagging
• 5142-single-page-gemini
• 5144-owner-level-suspicious-behavior-dashboard-and-controls
• 5150-fix-missing-gemini-reasoning
• 5151-fix-alto-migration
• 5165-let-project-owners-run-gemini-on-a-collection-that-already-exists
• 5176-add-subject-search-in-other-search-contexts
• 5xmx36-codex/add-internationalized-text-note-to-page
• 710-file-upload-flash-message
• 866-incomplete-status
• 975-email-logo
• a11y-updates
• accessibility-fixes
• add-confirm-blank-collection
• add-document-set-handling-for-gemini-rake
• add-metadata
• additional-metadata-date-input-mask
• admin-progress-page
• better_login
• blank-model-validation-error-fix
• broken-subject-export
• bulk-export-pdf-docx
• bump-nokogiri-development
• callapa1-2528-change-search-default-text
• cdm_update_transcript
• change_will_paginate
• changes-to-splash-software
• cleanup-docs
• codex/add-hours-spent-statistic-to-dashboard
• codex/add-import_gri-rake-task
• codex/add-internationalized-text-note-to-page
• codex/add-method-for-alto-xml-generation
• codex/add-spec-tests-for-admin-controller
• codex/add-tests-for-article_controller#relationship_graph
• codex/enable-github-copilot-agent-for-tests-and-linter
• codex/explain-cors-error-message
• codex/find-and-fix-a-bug-in-the-codebase
• codex/fix-duplicate-slug-issue-in-collection/document-set
• codex/fix-warning-for-already-initialized-constants
• codex/investigate-handsontable-json-update-issue
• codex/research-and-fix-issue-#4679
• codex/update-last-seen-date-on-profiles
• codex/update-omniauth-gem-to-2.0
• codex/xml-escape-ampersands-in-tei-template
• copilot/add-accuracy-statistics-ai-tab
• copilot/add-ai-draft-text-option
• copilot/add-ai-tab-for-owners
• copilot/add-disable-validation-parameter
• copilot/add-gemini-htr-to-pricing-page
• copilot/add-gemini-text-fetcher
• copilot/add-gemini-text-fetcher-will
• copilot/add-page-details-csv-export
• copilot/add-sso-for-dartmouth
• copilot/add-work-identifier-json
• copilot/fix-07c778ac-0926-4ecb-a8e5-88d2488bb0f7
• copilot/fix-1178
• copilot/fix-1197
• copilot/fix-1335
• copilot/fix-1487
• copilot/fix-1498
• copilot/fix-1517
• copilot/fix-1518
• copilot/fix-1537
• copilot/fix-1920
• copilot/fix-1962
• copilot/fix-2077
• copilot/fix-2183
• copilot/fix-2440
• copilot/fix-3190
• copilot/fix-3882d04d-ee20-4715-a5bb-d78565cc7c1a
• copilot/fix-3efb1b6f-4873-4091-b95c-d88e970c13a4
• copilot/fix-4745
• copilot/fix-4754
• copilot/fix-4846
• copilot/fix-4847
• copilot/fix-4867
• copilot/fix-4873
• copilot/fix-4874
• copilot/fix-4889
• copilot/fix-4893
• copilot/fix-4898
• copilot/fix-4901
• copilot/fix-4903
• copilot/fix-4908
• copilot/fix-632
• copilot/fix-694
• copilot/fix-7f9bb1fa-82ad-41c0-aba0-c0003b0df32c
• copilot/fix-856
• copilot/fix-882ad318-f892-4c2c-a0b9-6b30c31ff974
• copilot/fix-932
• copilot/fix-9cece620-a52d-4bc1-9d39-d950148f8036
• copilot/fix-ai-draft-placeholder-emojis
• copilot/fix-article-combine-source-text
• copilot/fix-b3dd61bf-da38-4b37-bfdb-fa1f0dfca1d8
• copilot/fix-bd6cbde9-d438-42eb-87ca-2be57a73adca
• copilot/fix-bots-in-metadata-facets
• copilot/fix-clean-bulk-export-task
• copilot/fix-cursor-position-in-text-box
• copilot/fix-d537533f-e3d1-471c-98a2-313c6da4a4d4
• copilot/fix-missing-tooltip-translation
• copilot/fix-start-new-topic-button
• copilot/fix-v3-collection-manifest
• copilot/fix-weekly-trial-report
• copilot/fix-wrong-redirect-organization-signup
• copilot/fix-zip-file-permissions
• copilot/handle-429-rate-limit-responses
• copilot/improve-accessibility-issues
• copilot/log-ai-draft-usage
• copilot/sub-pr-4696
• copilot/suppress-carousel-for-one-collection
• copilot/update-dartmouth-labels
• copilot/update-file-upload-guidelines
• copilot/update-gri-rake-task-headers
• copilot/url-encode-image-filenames
• copy-collection-task
• cwgk-subject-enhancements
• decouple_intercom
• dependabot/bundler/activerecord-7.2.2.2
• dependabot/bundler/addressable-2.8.0
• dependabot/bundler/carrierwave-2.1.1
• dependabot/bundler/devise-4.7.1
• dependabot/bundler/devise_masquerade-1.3.1
• dependabot/bundler/geocoder-1.6.3
• dependabot/bundler/image_processing-1.12.2
• dependabot/bundler/nokogiri-1.10.4
• dependabot/bundler/nokogiri-1.10.8
• dependabot/bundler/nokogiri-1.11.0
• dependabot/bundler/nokogiri-1.11.4
• dependabot/bundler/nokogiri-1.13.2
• dependabot/bundler/nokogiri-1.13.4
• dependabot/bundler/nokogiri-1.13.5
• dependabot/bundler/nokogiri-1.13.6
• dependabot/bundler/omniauth-2.0.0
• dependabot/bundler/puma-5.3.1
• dependabot/bundler/puma-5.5.1
• dependabot/bundler/puma-5.6.2
• dependabot/bundler/puma-5.6.4
• dependabot/bundler/puma-5.6.7
• dependabot/bundler/rack-2.2.19
• dependabot/bundler/rack-2.2.20
• dependabot/bundler/rack-2.2.3.1
• derevert-es
• development
• di8uwl-codex/limit-versions-tab-to-logged-in-users
• es-search-fix-highlight-terms
• export-debug-timestamps
• fix-alto-transcription-mismatch
• fix-annotations
• fix-markup-reversion
• fix-terser-gem-groupings
• fix-vcr-specs
• fix/conditional-mixpanel
• fix_ai_migration
• gcv-task
• gri-2026
• ignore-lib-tasks-in-coverage
• patch-3
• revert-4504-4129-new-findaproject-performance-part-2
• revert-5028-fix-annotations
• revert-ES-revert
• revert_duplicate_methods
• rubocop-lint-remove-array-whitespaces
• search-branch
• search_test
• sync/2025-10-07-dev-to-main
• update-gemfile
• update_gemini_prompt
• upgrade-omniauth-saml
• upgrade-savon
• upload-subdomain-for-uploads

Build # 16307810716

Build Type

Pull #4756

github

Committed by web-flow

Commit Message

Merge a31a6a8fd into b7a37bc1a

Pull Request Pull Request #4756: 4751 - SQL optimizations

Run Details

1624 of 3268 branches covered (49.69%)

Branch coverage included in aggregate %.

2 of 2 new or added lines in 1 file covered. (100.0%)

7468 of 11680 relevant lines covered (63.94%)

78.52 hits per line