This article helps our Volunteer Squad keep the database clean and consistent! It pertains to members who have the Contributor role and above. If you're interested in getting involved, read more about joining the Squad here. We'd love to have you aboard!
The Manage Database Items page is one of our most powerful tools, helping Volunteer Squad members find Database Items that are missing data or otherwise need work. Because Manage Database Items is such a powerful tool, it's also somewhat complex, so this article is a detailed explanation of all the options available. If you have any questions, please reach out via the green "Contact hobbyDB" button at the top right.
TABLE OF CONTENTS
You can access Manage Database Items from anywhere on hobbyDB. Just open the Curation menu at the top of the page, then click Manage Database Items.
When you first access the page, it will show a table listing the most recently added Database Items. Filters (more info below) can be used to narrow down the items listed. Each row is an individual Database Item, and the table has several columns showing details about each item. Some of the column headers have a blue arrow icon next to the name, indicating that you can click it to sort the table based on the data in that column.
Here's an explanation of each column, from left to right:
- Selection Toggle - Each row has a gray toggle slider, allowing you to select multiple items to perform a Batch Action on (more on Batch Actions below). Clicking the slider in the header row will select all items on the current page.
- Id1 shows the HDBID for each item. Each Database Item has a unique HDBID which can be used to quickly find a specific entry.
- Main Photo shows the item's Main Photo.
- Name1 shows the Item Name.
- Estimated Value1 shows the item's Estimated Value, or a link to add a Member Estimate if the item doesn't yet have an EV.
- Variants count - Subvariants count shows the item's numbers of Variants and Subvariants. Clicking either of those numbers will set the filters to only show the Variants or Subvariants of that item.
- Database Item Type links to a database search showing all items with that type.
- Brand, Series, Related Subjects lists, in that order, all the Subjects associated with the item.
- Search Fields shows other miscellaneous item attributes that are treated as search keywords.
- The last column shows a link to Edit Database Item Type. This functionality is only available to Squad members with the Champion role and above.
1 Clicking this header will sort the table by the data in that column.
By default, 30 items are shown at a time. At the bottom of the page there is a drop-down menu to change the setting to show anywhere from 5 to 50 items per page. You can also navigate between pages and see how many total items match the current combination of filters and scope.
Scopes are a quick way to find Database Items that need work. At the top of the Manage Database Items page you will see a silver bar with four buttons — All, No Images, No Estimated Value, and No Upc. Clicking one of these Scope buttons will limit the items displayed to those matching that criterion, preserving any filters that are currently set. This is a great way to quickly find things you can help with that make a big impact or find items to work on as part of a Quest.
There are many filter options in a column on the right side of the Manage Database Items page to help you find the exact items you're looking for.
You can use multiple filters at once to narrow down the results.
When you are ready to apply the filters, click the blue Filter button at the bottom of the filter list, or press the return/enter key with one of the text filters selected.
If filters have already been set, you will see this box above the filter list:
Clicking the red Clear Filters button will reset all filters to their default state for a fresh search.
- All Keywords returns results just like the main database search, finding the text you enter among all the items' keywords.
- Name Only2 filters by the Item Name. The Alternative Name is not included in this search.
- Description Only2 finds text in item descriptions.
- Brand filters by Subjects (Brand type only) that are in Database Items' "Brand" field. Type the name of the Brand you're looking for and any Brands containing the name entered will show in the list.
- Series functions the same as the Brand filter, but instead finds Subjects (Series type only) in Database Items' "Series" field.
- Related Subjects filters by Subjects in Database Items' "Related Subjects" field. All Subject types will display in this filter.
- Autographed By filters by Subjects in Database Items' "Autographed By" field.
- Production Status2 finds items with a Production Status matching the text entered.
- Scale is a drop-down menu with all the scale options that are available on the New and Edit Database Item forms. Items' scales are also shown in the "Search Fields" column.
- Database Item Type is a searchable drop-down menu where you can select one of the many Database Item Types.
- Have Release Date is a drop-down menu with the option to select "Any" (default), "Yes", or "No".
- HDBID3 finds specific items based on their unique hobbyDB Identifier number.
- Master Subvariant3 finds items connected as Subvariants to the item with the HDBID entered (must be the Subvariant set as Master Subvariant)
- Added By filters for items created by the specified hobbyDB.
- Last Verified By filters for items that were most recently verified by the specified Curator.
- Ever Revised By filters for items that have ever been edited by the specified member.
- Ever Verified filters for items that have been Verified or not. If set to "Yes" it shows items that have been Verified at some point, and if set to "No" it will show items which have never been verified. The default option is "All", which shows item regardless of their verification status.
- Subvariant Title2 filters for items which have a Subvariant Title matching the text entered.
- Created At is a date filter with From and To fields, used to find Database Items that were added within the specified date range. Clicking in one of the fields will bring up a calendar date picker that can be clicked to set the date, or a date can be manually entered in the format YYYY-MM-DD.
- Updated At functions the same as "Created At" above but instead filters for items that were last edited within the specified date range.
2 This filter has options in a drop-down menu to specify if the field being filtered Contains (default), Equals, Starts with, or Ends with the filter term.
3 This filter has options in a drop-down menu to specify if the filter results should include results that Equals (default), are Greater Than, or are Less Than the number entered.
As mentioned above, each row (Database Item) has a gray toggle slider in its first column. Clicking one of these toggles will "slide" the switch to the right, its background will turn green, and the row will be highlighted a light yellow, all indicating that the item has been selected for Batch Actions. Clicking the toggle slider in the header row at the top of the table will select all items shown on the current page.
To perform a Batch Action, click the blue Batch Actions button above the table, then click the action you want to perform. The actions displayed here will depend on your Squad role.
Note: It may take a few minutes for the Batch Actions to process.
Each Batch Action is described below:
- Create Variants (Creator and above) - Link the selected items as Variants. Any number of items can be selected.
- Create Subvariants (Creator and above) - Link the selected items as Subvariants.
Note: More details on how to link Variants and Subvariants can be found here.
- Merge (Coordinator only) - Merge the selected Database Items (must select exactly two). Merging is irreversible, so please read the help page on merging items before performing this action.
- Unlink Variants (Creator and above) - Break the Variant connection between the selected items. This does not break Subvariant connections.
- Unlink Subvariants (Creator and above) - Break the Subvariant connection between the selected items. This does not break Variant connections.