Skip to main content
Benchling Help Center home page
Go to Benchling Learning Labs Community Contact Support
  1. Benchling
  2. Product Documentation
  3. Insights
  4. Querying FAQ

Querying FAQ

  • How do I convert row_index and column_index to well positions?
  • How do I join data from different Benchling Applications?
  • How do I aggregate data across different organizations?
  • How and when should I use schema specific tables or the single “registry_entity” table?
  • How do I make a date range for a time series with parameters?
  • How do I add timezones to my Datetime values?
  • How come my division yields wrong numbers?
  • How do I query over multi-select JSONB arrays like ["seq_D3fZa648", "seq_bVWwI73e"]?
  • How do I change the order of query results of alphanumeric values?
  • How is “PARTITION BY” different from “GROUP BY”?
  • How do I make my parameter work when it is a null value?
  • What is the difference between tables that are suffixed with $raw vs. not?
  • How do I search for multiple values in a parameter?
  • How do I set up partial text matching for Parameters?
  • How do I extract the date/timestamp from values such as “2020-06-19T21:23:26.990971”?
  • Insights FAQ
Go to Benchling
Powered by Zendesk