Trillium - Frequently used fields for querying Instances
Purpose:
for performance improvement purposes, we need to identify which Instance record fields would be most frequently used for querying in the Bulk Edit and Lists apps. This will help us evaluate and test potential indexing for those fields. Could you share some of the examples of queries you would commonly use? (Note: This is about fields used to build queries, not the fields being edited.)
Dates of survey: December 3 - 16, 2025
Participation:
22 unique users responded to the google form (no additional data was gathered about participants)
Results:
Field | Count | Related Jira | |
|---|---|---|---|
| 1 | Instance — Created date | 15 | |
| 2 | Instance — Flag for deletion | 13 | |
| 3 | Instance — Notes — Note | 13 | |
| 4 | Instance — Resource title | 13 | |
| 5 | Instance — Staff suppress | 13 | |
| 6 | Instance — Cataloged date | 12 | |
| 7 | Instance — Instance HRID | 12 | |
| 8 | Instance — Notes — Staff only | 12 | |
| 9 | Instance — Subjects — Subject headings | 12 | |
| 10 | Instance — Suppress from discovery | 11 | |
| 11 | Instance — Updated date | 10 | |
| 12 | Instance — Classifications — Classification | 9 | |
| 13 | Instance — Identifiers — Identifier | 9 | |
| 14 | Instance — Instance UUID | 9 | N/A (already uses an index) |
| 15 | Instance — Publications — Publication date | 9 | |
| 16 | Instance — Resource type | 9 |
|
| 17 | Instance created by — Username | 9 |
|
| 18 | Instance — Administrative notes | 8 | |
| 19 | Instance — Publications — Publisher | 8 |
|
| 20 | Instance — Statistical codes | 8 | |
| 21 | Instance — Contributors — Primary | 7 | |
| 22 | Instance — Contributors — Contributor name | 7 | |
| 23 | Instance — Date 1 | 7 |
|
| 24 | Instance — Identifiers — Identifier type | 7 |
|
| 25 | Instance — Notes — Note type | 7 | |
| 26 | Instance — Series | 7 | |
| 27 | Instance updated by — Username | 7 |
|
| 28 | Instance — Date 2 | 6 |
|
| 29 | Instance — Electronic access — URI | 6 | |
| 30 | Instance — Electronic access — Link text | 6 | |
| 31 | Instance status — Term | 6 |
|
| 32 | Instance — Subjects — Subject type | 5 |
|
| 33 | Instance — Alternative titles — Alternative title | 4 |
|
| 34 | Instance — Format names | 4 |
|
| 35 | Instance — Index title | 4 |
|
| 36 | Instance — Languages | 4 |
|
| 37 | Instance — Subjects — Subject source | 4 |
|
| 38 | Instance status — Code | 4 |
|
| 39 | Instance created by — Last name, first name | 4 |
|
| 40 | Instance updated by — Last name, first name | 4 |
|
| 41 | Instance — Classifications — Classification identifier type | 3 |
|
| 42 | Instance — Physical descriptions | 3 |
|
| 43 | Instance — Publications — Place of publication | 3 |
|
| 44 | Instance — Source | 3 |
|
| 45 | Instance — Tags | 3 |
|
| 46 | Instance created by — Email | 3 |
|
| 47 | Instance updated by — Email | 3 |
|
| 48 | Instance — Electronic access — Material specified | 2 |
|
| 49 | Instance — Electronic access — URL public note | 2 |
|
| 50 | Instance — Instance source URI | 2 |
|
| 51 | Instance — Nature of content | 2 |
|
| 52 | Instance — Publication range | 2 |
|
| 53 | Instance date type — Name | 2 |
|
| 54 | Instance — Contributors — Contributor type | 1 |
|
| 55 | Instance — Editions | 1 |
|
| 56 | Instance — Electronic access — URL relationship | 1 |
|
| 57 | Instance — Mode of issuance | 1 |
|
| 58 | Instance — Previously held | 1 |
|
| 59 | Instance — Publications — Publisher role | 1 |
|
| 60 | Instance — Alternative titles — Alternative title type | 0 |
|
| 61 | Instance — Contributors — Contributor type, free text | 0 |
|
| 62 | Instance — Contributors — Contributor name type | 0 |
|
| 63 | Instance — Publication frequency | 0 |
|
| 64 | Instance — Record version | 0 |
|