Forum Academy Marketplace Showcase Pricing Features

Data API "text contains" limitations

Hi

So it seems pretty clear that the search constraint “text contains” only works for whole words and doesn’t do partial word matches.

  1. Can the general world of knowledge confirm this? (Or is there some super trick one can do to get partial word matches?)

  2. Is there a reasons for this (performance, …) - I would have thought this was doable (I don’t know what database lies under bubble but it isn’t rocket science) but perhaps the issue is potential performance hits.

I ask because I strongly suspect that a filter will stuff up my pagination - the pagination being on the query side and the filter being on the results of the query.

Anyone have a solution to this?