Versions Compared

Old Version 1

changes.mady.by.user Robert Allaway

Saved on

compared with

New Version 2

changes.mady.by.user Robert Allaway

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


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

actual results

what I was looking for

actual results

ipNF

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

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

cagg

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

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

corielle (this is a typo)

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

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

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

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

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