Entries fieldtype in select mode should show all results

[jasonvarga]

Bug Description

The entries fieldtype (and similar relationship fieldtypes like taxonomy), when using mode: select currently grabs the first paginated page, which is only 15 results. (We should probably bump that up too, but that's another story)

Pagination is fine for the default and typeahead modes.

The select mode should show all results. Even if that means its a ridiculous amount. You should get what you ask for.

How to Reproduce

• Have more than 15 entries.
• Add a field to your blueprint:

  fields:
    -
      handle: myfield
      field:
        type: entries
        mode: select

• See only 15 results

Environment

Statamic version: 3.0.0.-beta.27
PHP version: 7.4

[derekjones]

Just commenting that particularly in the case of Taxonomies, this can cause content creators to accidentally create new taxonomies from a slightly different spelling or phrasing, which leads to poor normalization and poor visitor experience when said taxonomies are a forefront of the front end.

[Krzemo]

So this (for taxonomies on sidebar) seems to be 2 fold:

1. vendor/statamic/cms/src/Query/Builder.php has defaultPerPageSize() hardcoded to return 15 per page. (quick and ugly fix to show all terms would be to change this value to hight number)
2. Dropdown RelationshipSelectField component searches only entries returned by QueryBuilder while there should be an API call made to run LIKE '%%' query.