Skip to end of banner
Go to start of banner

Examples of Limitations of Table Search

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

The purpose of this article is to provide examples “failed” search terms in table search as of late 2024, focusing on a MySQL FTS-backed service. In these cases, we know there is a target result we know exists and want to find.


I’m doing table queries here to show my desired results, but in reality, the users would be working on the data portal and only have “search” surfaced to them - they wouldn’t be working with the table directly.

search term

what I was looking for

actual results

ipNF

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclaXBuZiUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiaXBuZiJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

cagg

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclY2FnZyUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY2FnZyJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

corielle (this is a typo)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY29yaWVsbCJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY29yaWVsbGUifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0=

biobank (the summary mentions “biospecimen and xenograft bank”)

https://www.synapse.org/Synapse:syn52694652/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUyNjk0NjUyIHdoZXJlIHN0dWR5SWQgPSAnc3luNDkzOTkwMiciLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9

https://www.synapse.org/Synapse:syn52694652/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUyNjk0NjUyIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiYmlvYmFuayJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

lambda (note, λ also doesn’t work because it’s too short)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ==

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoibGFtYmRhIn1dLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9

90-8 (also tried 90.8)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclOTAtOCUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ==

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiOTAtOCJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ==

NF1+/R1947X pigs (technically in the results, but nowhere near the top) or minipigs (no results)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiTmYxcEFyZzE5NDdtcDEifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0

https://www.synapse.org/Synapse:syn51730943/tables

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoibWluaXBpZ3MifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0

  • No labels