Skip to main content
Benchling Help Center home page
Go to Benchling Learning Labs Community Contact Support
  1. Benchling
  2. Troubleshooting Articles
  3. Insights
  4. SQL Query FAQ

SQL Query FAQ

  • How to Display Numbers in Scientific Notation in Dashboard
  • 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”?
  • SQL basics video series
  • 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”?
Go to Benchling
Powered by Zendesk