https://umherb11024-issue-1959.test.specifysystems.org/specify/query/1196/
User is csiro, herbarium_catalog collection

I don't see the list of table formats/aggregation to choose from in the query when there is only one format defined. If there is only one format, it should just show one item in the list.

When there are multiple formats, I see two arrows before the format:

The arrow is misleading, the user will think it's a specific field or value.

If we made it so the list was in a small menu like in the WB:

Almost perfect. Thank you for your patience!

Issues:

1. The gear has no background but it should have a white background, and it also isn't the same height as the query item:
   issue-1959:
   

   See how it should look in the WorkBench (link):
   

2. Adding a new (formatted) field makes the gear yellow even without any customization. It should only be highlighted if a specific format is selected
   Query URL as HerbAdmin in herbarium_catalog collection

   Screen.Recording.2024-03-08.at.3.16.43.PM.mov

   In this case, it should be gray since it should be using the default format

   When the selection is "blank", it uses the default formatter. Because of this, I think that if this is blank it should not be highlighted, but if any format is selected it should be highlighted.
   

3. Hovering over the gear should not make it orange, it should remain black.

   

4. The hover text says "Choose fromatter", but it should say "Choose formatter"

5. Instead of automatically hiding the custom selected table format, can we have it display until the next time the user loads the page? It can always be hidden by default, but it should show after the user sets it to a value so they can verify the change

   Screen.Recording.2024-03-08.at.3.22.59.PM.mov

Not an issue:

Basic queries also work with this feature, neat! 😊

Otherwise, we're almost there. Thank you @CarolineDenis for your hard work on this!

Testing instructions

• Navigate to the Query Builder (QB).

• Select a table that you know has one or several formatters (To check, go to app resources, navigate to Record Formatter, choose the table, and verify the list of formatter names available).

• Choose "formatted."

• Verify that in the query line, after selecting the "formatted" field box, a drop-down appears with a list of formatter choices (corresponding to the list in app resources).

• Verify that changing the formatter changes the way the field is displayed in the results table.

Great work adding this back (and much better than before)

Testing instructions

• Navigate to the Query Builder (QB).

• Select a table that you know has one or several formatters (To check, go to app resources, navigate to Record Formatter, choose the table, and verify the list of formatter names available).

• Choose "formatted."

• Verify that in the query line, after selecting the "formatted" field box, a drop-down appears with a list of formatter choices (corresponding to the list in app resources).

• Verify that changing the formatter changes the way the field is displayed in the results table.

When query line is selected and you click the gear, the picklist for selecting a format is hidden except for the little ⌄ arrow. This field should display the same as the other fields in the query line when highlighted.

Also, once the gear is highlighted brown, it doesn't revert back even if format is unselected and it's set to the blank default option.

Other than those two things, adding a tool tip for the gear button that says "select format" or something would be great

I'm excited for this feature!

Testing instructions

• Navigate to the Query Builder (QB).

• Select a table that you know has one or several formatters (To check, go to app resources, navigate to Record Formatter, choose the table, and verify the list of formatter names available).

• Choose "formatted."

• Verify that in the query line, after selecting the "formatted" field box, a drop-down appears with a list of formatter choices (corresponding to the list in app resources).

• Verify that changing the formatter changes the way the field is displayed in the results table.

• Select a table that you know has one or several aggregators (To check, go to app resources, navigate to Record Aggregators, choose the table, and verify the list of aggregators names available).

• Choose "aggregated"

• Verify that in the query line, after selecting the "aggregated" field box, a drop-down appears with a list of aggregated choices (corresponding to the list in app resources).

• Verify that changing the aggregator changes the way the field is displayed in the results table.

Wow. Even better. It looks great & works great. Tested using an older version of Specify 7 and it didn't break the queries either. 💯 Thank you!

Testing instructions

• Navigate to the Query Builder (QB).

• Select a table that you know has one or several formatters (To check, go to app resources, navigate to Record Formatter, choose the table, and verify the list of formatter names available).

• Choose "formatted."

• Verify that in the query line, after selecting the "formatted" field box, a drop-down appears with a list of formatter choices (corresponding to the list in app resources).

• Verify that changing the formatter changes the way the field is displayed in the results table.

• Select a table that you know has one or several aggregators (To check, go to app resources, navigate to Record Aggregators, choose the table, and verify the list of aggregators names available).

• Choose "aggregated"

• Verify that in the query line, after selecting the "aggregated" field box, a drop-down appears with a list of aggregated choices (corresponding to the list in app resources).

• Verify that changing the aggregator changes the way the field is displayed in the results table.

Can select the different aggregations but both give the result of the default format.

Testing instructions

• Navigate to the Query Builder (QB).

• Select a table that you know has one or several formatters (To check, go to app resources, navigate to Record Formatter, choose the table, and verify the list of formatter names available).

• Choose "formatted."

• Verify that in the query line, after selecting the "formatted" field box, a drop-down appears with a list of formatter choices (corresponding to the list in app resources).

• Verify that changing the formatter changes the way the field is displayed in the results table.
  Looks good!

sorry, I got distracted and forgot to submit my review comments before this PR got merged

my comments don't have anything major, just small refactoring. @CarolineDenis could you please incorporate these small changes in some other PR or a small follow-up PR?
thanks)