CDD Vault Update (March 2019): Searching Across Numeric & Date Batch Fields; Molecule ID Range Queries; API Calls to Delete Runs & Imports

CDD Vault Update Logo
March 10, 2019

While Spring doesn't officially start for a few weeks, the CDD Development team has already planted a set of new features that are sure to please.

  • "1" list icon for CDD Vault ELN Blog Posts

    Keyword Search Using Number and Date Operators

    In a recent CDD Vault ELN release, additional search parameters for querying across text Batch fields were added. With this release, we have now focused on the ability to perform advanced queries over numeric and date Batch Fields.

    To take advantage of all of these new Keyword searching operators, users should:

    • Click the "Any field" drop-down within the "Keywords" section of the main Search menu
    • Select a numeric or a date Batch field
    • Choose your desired query operator: Has, From, Not, or No Value
    • Type or paste your query string into the adjacent box (Special note for date Batch fields – dates must be typed in the YYYY-MM-DD format and there is now a calendar tool to allow you to select your date query terms)
    • Click the green "Search" button

    Helpful Hint: CDD Vault users may set their individual time zone by navigating to the Settings > User > Preferences tab and clicking the “Edit account preferences” pencil icon. Setting your correct time zone may impact your searching over date Batch fields.

     

    Keyword Search in CDD Vault ELN using number and date operators

    Search CDD Vault using number and date operators

     

     

  • "2" list icon for CDD Vault ELN Blog Posts

    Molecule Name Range Searching

    Searching for a range of Molecule IDs has been a popular request that’s now implemented.

    In the Explore Data > Search tab, use the Keyword query box to execute your Molecule ID range query.  

    Simply:

    • Click the "Any field" drop-down within the "Keywords" section of the main Search menu
    • Select the “Molecule name” field
    • Choose the “From” query operator
    • Enter your starting and ending IDs
    • Click the green "Search" button
    Molecule name range search has been added to CDD Vault

    The often requested ability to search for a range of Molecule IDs has now been added to the CDD Vault

  • "3" list icon for CDD Vault ELN Blog Posts

    Delete Runs of Protocol Data via the CDD Vault API

    The CDD Vault API has been enhanced to allow more access to and control of your Runs of Protocol data. It is now possible to retrieve and delete specific Runs of Protocol data via CDD Vault API calls.

    To retrieve a single run:
    GET /api/v1/vaults/<vault_id>/runs/<id>

    To delete a single run:
    DELETE /api/v1/vaults/<vault_id>/runs/<id>

    Additionally, it is now possible to delete all Runs of Protocol data that were created by a specified data import process (affectionately known as a “slurp”).

    Delete runs associated with a single slurp:
    DELETE /api/v1/vaults/<vault_id>/runs?slurp=<slurp_id>

    Delete Runs of Protocol Data via the CDD Vault API