Advanced keyword search options
To provide indexing and querying capabilities Beacon utilizes Azure Cognitive Search– a native component of the Microsoft Azure Cloud Platform. This entire functionality is housed within the Keyword field on Beacon.
At Beacon we are utilizing two types of querying; Lucene search query and OData filter querying. Please note that these two query syntaxes cannot be combined within the same search.
The value in using advanced keyword searches is to search the Beacon platform in unique ways. This includes (and is not limited to) searching with field names, ranges, wildcards, Boolean operators and grouping.
By default, all keyword searches are applied using Lucene search querying. To specifically filter by filterable fields these must be converted to OData filter queries using the $filter syntax.
Examples
Search by field names
- Filter by specifically searchable information
UpdateMessage:”2020 Publication added”
TrialStatus/Name:”Expanded Access (Approved for marketing)”
`$filter=TrialStatus/Name eq ‘Expanded Access (Approved for marketing)’
Search by ranges
- Searches within or after a given date/date range
$filter=TrialLastRevisionDate gt 2021-08-09T00:00:00Z and TrialLastRevisionDate lt 2021-08-15T23:59:59Z
Search by wildcards
- ? replaces a single character
- * replaces zero or more characters
TrialStatus/Name:”Expanded Access*”
Search by boolean operators + Search by grouping
- All Boolean operators are available to bring complexity to your search.
“2020 Publication added”+(“Active not recruiting”|”Completed”)
Useful Links
The above is not exhaustive and we encourage you to learn more about Cognitive searching:
https://docs.microsoft.com/en-us/azure/search/query-lucene-syntax
https://docs.microsoft.com/en-us/azure/search/search-query-odata-filter
About Beacon Targeted Therapies
We are a clinical trial and pipeline database solution, designed in partnership with pharmaceutical professionals. We track targeted therapies to provide accurate, in-depth and real-time information in the rapidly evolving landscape of drug development.
