WISHING YOU A HAPPY 2018!

We would like to wish you a sweet start to 2018, may it be a year filled
with successful partnerships and alliances! Happy partnering!

The Inova Team

Hello! How can we help?

Cortellis Advanced Query

With D&A, you can query Clarivate Analytics' Cortellis database and import one or more assets with the associated company information, facilitating data entry. 

The option to search Cortellis and import a single asset based on a match to its name or a synonym is explained here. The information below focuses on advanced querying, which lets you search for drugs across multiple criteria and then import multiple products at a time. 

What you search is what you get

When you import a record from Cortellis:

  • A new asset will be created. Its fields will be populated with whatever data is contained in Cortellis. The exact fields are listed in the steps below.
  • If they already exist in your Inova system, the associated Company and Licensee / Partner will be automatically linked to the asset. If those companies don't yet exist in your Inova system, the tool will import them and link them to the asset. To learn more about querying Thomson for company information, see this article.

Cortellis content is created and maintained by the companies entering it in that database. Inova does not create or manage this data. There is a chance that a company entering information in Cortellis will enter their company name in a slightly different way than how you have entered it in your Inova platform. If this happens, a duplicate company record would be created. Click here to learn about removing duplicate companies from your Inova system. Otherwise, if you notice any errors or discrepancies in the imported data, contact your Clarivate Analytics rep. 

Activating this feature requires a special license from Clarivate that is separate from your Inova license. You will need to contact Clarivate directly to obtain this special license, configure the query options in administration, then update your user profile as well as the main menu.

Running an advanced query

  1. To perform a search in Cortellis, click Search in Cortellis. The query screen will appear:

    advq.png

  2. Use the criteria in the form to search for assets. Query options are described below:

Search Criteria

Definition

Field Type

Drug Name

The primary name of the drug

-          Use of "*" and "?" for wildcards

-          Use of AND, OR or NOT as operator

Current Development Status

Refine your search with 'AND', 'OR' or 'NOT' targeting the current development status

 

Indications

Indications of the drug

Tree list

Status

Development Phase of the drug

-          Dropdown box

-          Link to highest status: limit the query to criteria associated with a specific highest development status, as opposed to 'any status'.

Company

Company developing the drug

Use of "*" and "?" for wildcards

Country

Country targeted

Dropdown box

Date

Timeframe considered

Dates

Originator company

The company that discovered the drug

-          Autocomplete

-          Use of "*"

Active companies

Companies currently developing the drug

-          Autocomplete

-          Use of "*"

Inactive companies

Companies currently not developing the drug

-          Autocomplete

-          Use of "*"

Active Indications

Indications that are currently under development

Tree list

Inactive Indications

Indications that have been researched but are not currently under development

Tree list

Highest Phase

The highest development phase obtained for  any country and indication  

Dropdown box

Any Actions

Actions specific to the targeted disease(s)

Tree list

Technologies

Technologies involved in development

Tree list

Add Date

The date the report was added

Dates

Drug ID

Drug ID from Thomson Reuters

Free text

  1. Tree list fields in the query form allow you to browse through and select options from the Cortellis biopharmaceutical ontology. To display optional values in a tree list, click the field. The system will display the first level values. Click the plus sign next to a category to expand a list of subcategories.

    Click the category to add it to your search criteria. Note that if you select a category with a plus next to it, the feature will search on all the subcategories as well. In the example screenshot above, if the user selects "bleeding," the query will include "brain hemorrhage," "contusion," and "epistaxis," and all the other categories under the category of "bleeding."  

    A tree list also includes the typeahead feature, allowing you to search for a category by typing in the first few characters into the field and then selecting from the results.

Data in the imported assets will follow Cortellis ontologies. As described above, tree lists allow you to search by browsing and selecting from these ontologies, rather than typing them in manually and perhaps misspelling or misnaming a category ("cardiology" vs "cardiovascular disorder," for example). Tree lists improve search results and help keep list value data clean.
  1. Once you've entered all the search criteria, click Search. Depending upon your query criteria and the number of matches that the query tool locates, it may take some time for the system to display the results. You can use the "Click here" link to cancel the query, then rerun it with modified criteria to narrow down the results. Otherwise, the results screen will appear as follows:

    results.png

    Records that have never been imported (1) and don't yet exist in your Inova platform are differentiated from ones that have been imported by the refresh icon (2). 

  2. Check the box next to each asset you want to import. If you select an asset that was imported previously into your Inova system, the feature will update that asset with the current data in Cortellis.
  3. To view the exact details that would be imported for an asset, click its Cortellis ID. A preview popup will appear as follows:

    impprev.png
    From this popup, you can click Select to import the details or Close to return to the query results. 

  4. Once you've made your selections, click Import. The system will display a confirmation popup as shown:
    impconf.png

  5. Click Import. The system will import the data and display a confirmation screen once the import is complete. 
    importdone.png
    Once imported, you can find your imported assets by searching the assets list and sorting by Created Date descending.

Competitive Intelligence

The Cortellis Advanced Query feature is helpful for users who want to proactively scout strategic assets and build a corporate memory of this information. Some companies have a dedicated competitive intelligence department, while others have scouts who work with the business development team on this effort. 

There are two general processes that D&A supports for the competitive intelligence use case: 

I want to research the marketplace for drugs within a certain criteria so my company can take action on as many in-licensing opportunities as possible.
  1. Define your serach criteria (TA:X and Development Phase:Y).
  2. Import all assets returned in the search results.
  3. In your assets list, filter the list to display the imported records (Source of Referral = Cortellis, Created Date = today's date).
  4. Quickly evaluate each asset. Use the Review feature to ask your colleagues for their expertise. 
  5. Update the status on each asset to Pursue for those that are of interest, or Decline or On Hold for those that are not.
  6. Create an in-licensing opportunity for each Pursued asset and assign it to your BD colleague.
  7. Watch each On Hold asset to receive alerts when details in Cortellis are updated by the related company, e.g. when the development phase is modified.
I want to research the marketplace for drugs competing against my company's drug; I want my drug to be more competitive.
  1. Define your serach criteria (in this scenario, the criteria could include a specific company you are competing against in the marketplace).
  2. Import all assets returned in the search results.
  3. In your assets list, filter the list to display the imported records (Source of Referral = Cortellis, Created Date = today's date).
  4. Update the status on each asset to Monitor.
  5. Watch each asset to receive alerts when details in Cortellis are updated by the related company, e.g. when the development phase is modified.
If you want to apply these use cases but your menu configuration is not set up to display the assets list, talk to your Inova application administrator to have the menu changed.
Was this article helpful?
0 out of 0 found this helpful