Articles tagged with 'TrialGrid'

Searching Rave Studies

If you've ever wanted to quickly search through all your Rave study and library drafts, we now have that feature!

At any point in the TrialGrid application you can enter some terms in the search box and instantly see objects which contain that text. We search all projects and libraries you have access to, and search all of the text in forms and their fields, folders, data and unit dictionaries, edit check and derivations and custom functions.


As an example, lets search for objects containing the word "position". Here we see the top 10 matches, a data dictionary which has been used in different libraries and projects:


If we want to search within a project we can add the project name to the search terms, and now we see objects within project "B100", the data dictionaries again and also some forms:


We can click on one the search results and go directly to that object. Here's one of the forms - it was displayed in the search results because there's a field on the form with a label "Position of the Subject":


If you only want to search forms you can filter the results to only show forms (or any other object types):


And if you want to go further you can create more complex searches - this one will find forms containing "position" but not "blood":


All parts of Edit Checks, including query messages, are searched - here's a search showing edit checks which open a query containing the words "start time":


Similarly you can search the source code of all Custom Functions. Suppose I want to find a custom function which does something with MedDRA codes - here it is:


In all these examples, the search is fast - typically you'll see the results in less than 0.2 seconds.

We also search the TrialGrid tools for team communication and workflow, so if you have information in Project wiki pages you can quickly find them through searching.

So if you've ever wanted to find a custom function, or an edit check, or a form, etc but struggled to remember exactly which project or library its in, now you can track it down quickly and easily!

Medidata Rave is the market leading EDC system. The TrialGrid application is designed to help Study Builders make the most of Medidata Rave by speeding study development, managing library compliance and automating quality checks. If you want to see what TrialGrid can do for your team, Contact us

Faster Rave Edit Check Building and Diagnostic Fixes

Summer is usually a quiet time in our industry with people taking vacations but at TrialGrid we're busier than ever working with our clients to get the most from Medidata Rave and the TrialGrid application.

Medidata Webinar / Fix-All Diagnostics

The good news is we are continuing to make improvements and release new features. This month, in a joint Webinar with Medidata, we presented our Diagnostic "Fix All" functionality. This is particularly important to Medidata Rave customers as they adopt Rave 2018.1.0 or above. In these new versions of Rave, Medidata has taken a best practice (always set RecordPosition=0 for Standard Fields) and made it a requirement with the result that many ongoing Rave studies will need to be updated.

Long-term this change will be a great benefit to Rave users because not adhering to this best practice can cause edit checks to not work as expected - but in the short term it will be extra work. We know of one group that spent two
days of effort updating a single study. In the webinar we showcased our Diagnostic for RecordPosition and its automatic "Fix All" capability. Using this Diagnostic could have resolved this issue in 10 minutes - a saving of 15 hours and 50 minutes or 96% less effort.

Updates to CQL

Two years ago we introduced CQL, the Clinical Query Language, an alternative way of specifying Edit Checks. Rave Architect provides two ways of authoring Edit Checks: a point-and-click Edit Check builder and the powerful (but cryptic) QuickEdit text format. Both are based on postfix notation which can be difficult to learn. Here's a simple mathematical expression in postfix format:

2 2 + 4 =

CQL provides a more familiar infix notation:

2 + 2 = 4

Last week we upgraded our Edit Check editor with a new version of CQL and even better auto-complete helpers. This makes writing Edit Checks even faster.

Here's me starting an edit check. Notice how the editor offers me a listing of Folders or the Folder wildcard:

Folder Wildcard

I choose the wildcard option (any folder) and now I'm choosing a Form:

Form Choice

I choose the AE form and now I'm choosing the Field:

Field Choice

Notice that TrialGrid is giving you much more here than just the Field OID that Rave requires for an Edit Check. We're also seeing the Field Label, whether it is a log Field, it's data type and any associated Data Dictionary. This extra context makes it much easier to select the correct Field without having to look up an annotate or have the Form editor open.

If I select a Field which has an associated dictionary and I ask for the CodedValue then typing a # gives me a listing of all the possible values from that Dictionary:

Dictionary Value

In each of these helper listings, typing a few more characters will filter the list of choices further. And this brings me to possibly my favorite feature of this upgraded editor, the Field search.

Field Search

Let's say you have the specification for a simple Edit Check:

AE Start Date cannot be later than AE End Date

You have to translate that into something you can create as an Edit Check:

AE Folder, AE Form, AESTDAT > AE Folder, AE Form, AEENDAT

Which means that you have to know the OID of the AE Folder and the AE Form and the Field OIDs for these Fields. In the new CQL editor you can simply type:


To see a listing of all the Fields which contain (in their Question text or OID) the word "End":


Writing Edit Checks with CQL is fast, really fast but how does it compare to the Rave Edit Check point-and-click builder and to QuickEdit?

CQL Point And Click QuickEdit*
Style Infix Postfix Postfix
Speed Fast Slow Fast
Select OIDs Yes Yes No
Field Search Yes No No
Dictionary Search Yes No No
Field Context Yes No No
Auto set RecordPosition for standard Fields Yes No No

*Note that TrialGrid shows QuickEdit and CQL side-by-side and editing in one automatically updates the other so if you're productive with QuickEdit those skills are directly transferable to TrialGrid.

Medidata Rave is the market leading EDC system. The TrialGrid application is designed to help Study Builders make the most of Medidata Rave by speeding study development, managing library compliance and automating quality checks. If you want to see what TrialGrid can do for your team, Contact us

Do you really need an MDR?

I started working with Medidata Rave in 2008 and I remember being impressed by the scope of the Rave product. Compared to other EDC systems it seemed to have everything: EDC, data migrations and versioning, double-key data entry, PDF generation, customizable workflow, non-programming edit checking, data export generation and reporting, library management, APIs for data import and export.. the list went on.

One thing that has always been missing however, is the ability to manage custom metadata alongside the metadata that Rave needs to function.

For example, Rave Forms have a number of attributes but in Architect there is no facility to add the SDTM domain or copyright information regarding the Form if it represents a validated instrument. Similarly, for the Fields in a Form there is no way to add additional metadata regarding the mapping of that Field to IxRS transfer specifications, SDTM generation or anything else, except by the use of naming conventions.

This omission has become more acutely felt as companies embrace the CDISC SDTM standard and work to make their study build processes repeatable. In order to plan a study from protocol design through to analysis many organizations have started to explore Metadata Repositories (MDR). These systems are designed to be highly configurable to different kinds of metadata and the mappings between them and to provide sophisticated tools for impact analysis and governance of that metadata.

MDRs promise much, but honestly I am yet to hear of an MDR project that was considered simple by anyone involved in it. They take time and a great deal of planning in order to deliver on their promise.

So what if you are an organization using Medidata Rave and you want to capture additional metadata on Rave Forms and Fields so that you can streamline your SDTM generation process? Chances are you are using a spreadsheet to capture that information and you have a process that looks like this:

Excel Management

This works but the mapping document and the study design can easily get out of sync, versioning is problematic and the Statistican has two Excel spreadsheets to merge and manage.

This is exactly the challenge our friends at BioForum faced when working with Medidata Rave. They have built a framework for the generation of SDTM from the Rave standard outputs which is driven by a mapping between Rave fields and Forms and the SDTM. Managing the mapping in the same tool where the Standard Libaries are maintained and where studies are built and quality checked would be so much more convenient:

TrialGrid Management

To facililate this we built a simple mechanism into TrialGrid which allows users to define custom properties for their studies. These can be associated either with Form or with Field objects and users can decide whether to include these properties in object listings (e.g. to show the custom property alongside the Form OID in the list of Forms).

Managing Properties

These properties then appear in the Form editor just like other attributes of the Form and Fields where changes to them are audit trailed.

Editing Properties

These additional properties are exported from TrialGrid into the output ALS spreadsheet in their own custom sheets. You can load this file direct into Rave Architect since Architect ignores sheets it does not recognize. TrialGrid will load this metadata if it is present so if you do have an MDR and want to include additional metadata in the ALS file then TrialGrid can upload it.

Combined with our Library Management features, TrialGrid offers a simple way to manage compliance to library standards and an environment that unifies Rave study design and essential metadata management in a single solution which can be licensed on a per-study or per-user basis at a fraction of the cost of a full-blown MDR.

Please contact us for more information about the Standards and Metadata Management features of TrialGrid.