Feature request: endswith for string searches

markp · April 14, 2025, 4:08pm

Currently in queries, there is the ability to use the “Starts With” operator on strings. It would be nice if there was also the option to search on “Ends With”.

I believe it would be just be a slight modification of what has already been done for starts with.

github.com/specify/specify7

specifyweb/stored_queries/query_ops.py

166447978


      
          def op_startswith(self, field, value):
              if self.uiformatter is not None and isinstance(self.uiformatter.fields[0], CNNField) and len(self.uiformatter.fields) == 1:
                  value = value.lstrip('0')
                  return field.op('REGEXP')("^0*" + value)
              else:
                  return field.like(value + "%")

I can also take this on as a PR if it would help, seems quite limited in scope (just adding the logic and then the option on the frontend) and easy to test.

nfshoobs · April 14, 2025, 5:51pm

Motion seconded! This would be really useful for us at OSUM.

markp · April 14, 2025, 10:47pm

Okay I’ve got a PR ready to go, will wait to see if the feature request is accepted first before creating on GitHub.

Topic		Replies	Views
Determination: Taxon search "contains" instead of "starts with"? Get Help Solved	2	271	September 30, 2022
Not found results from queries New Feature Requests	5	357	July 8, 2024
Simple Search Query Building Specify-7 , Specify-6	0	531	January 3, 2025
Search across collections Get Help	4	53	January 10, 2025
Wildcard Get Help	4	70	January 27, 2025

Feature request: endswith for string searches

Related topics