Permissions: Queries can be created based on the configuration of Data Central. The Queries panel is only available for studies with Query data imported into elluminate. If a study does not have query data available, the Queries panel will not display.

Queries are questions or concerns raised about a record that can be imported into or created within elluminate, and depending on configuration with a bi-directional EDC system can be actioned within elluminate to update the EDC system as well.

Create Queries

Users can create a single query from a listing by right-clicking in a cell, from the Details view, or create multiple queries at one time from an Exception listing. Once queries are created they can be accessed and managed from the Queries panel.

Note: Queries created in elluminate for studies using Rave, InForm, or Veeva EDC systems will be in the Open status. Opening a Candidate query is currently not supported.

Create a Single Query from the Details View

1. Open a record in Details view from a listing.
2. Click the field to add the query.
3. Click the Create icon (the plus sign) in the panel toolbar, or right click.
   
4. Select Create Query from the drop-down menu. The Create Query window opens.
   

   Tip: This window can be moved by dragging it elsewhere on the screen, allowing visibility of dialog behind the window.

   
5. Enter the Query Text.
6. Select Notification Group from the drop-down arrow.
   

   Note: This may not be available for all EDC systems.

7. Select Query Category from the drop-down arrow.
8. Check Mark as Requery to mark this query as a requery.
9. Click Save, or click Cancel to cancel your actions.

Note: When Veeva-integrated query actions fail due to locked or frozen Veeva data, users receive a detailed error message.

Important: Depending on how the study was configured, the system may prompt for an EDC system userid and password, which is required in order to send the query or query action to the EDC.

Create a Query on a Cell in a Listing

A query can be created by right-clicking on a cell in a listing.

1. From a domain listing, right-click a cell.
   
2. Mouse over Create, and select Create Query on Cell.
   
3. Enter the Query Text.
4. Select Notification Group from the drop-down arrow.
   

   Note: This may not be available for all EDC systems.

5. Select Query Category from the drop-down arrow.
6. Check Mark as Requery to mark this query as a requery.
7. Click Save, or click Cancel to cancel your actions.

Create Multiple Queries

Multiple queries can be created at one time from an Exception Listing. If the listing has the field 'QueryText', that query text will be pre-populated in the Query Text field of the queries being created. The query text for each record is sent to the EDC.

1. Select the records by checking the box(es) at the left.
   
2. Click the Create icon (the plus sign) in the panel toolbar.
3. Click Create Query.
   The Create Query for undefined on name of listing window opens.
   
4. The Query Text field is auto-populated with the text from the QueryText field in the Exception Listing.
5. Select Notification Group from the drop-down arrow.
   

   Note: This may not be available for all EDC systems.

6. Select Query Category from the drop-down arrow.
7. Click Save, or click Cancel to cancel your actions.

Access Queries Panel

The Queries panel is accessed from the left navigation. By default, the Queries panel lists all Opened and Answered queries. Use the filters to identify which queries to display. 

Important: Use the Queries panel to action or edit existing queries. Queries cannot be created from this view.

Tip: To view queries for records on domains marked as critical or as a requery, scroll to the right of the window and view the Criticality and Requery columns.

Filter Query Panel Results

Filters are available for all columns in the Queries listing. A numbered badge in the header indicates whether filters are applied to the panel. Filtered columns display a filter icon in the header. 

The Queries panel defaults to Status=Open and Answered filters. To view other statuses, clear existing filters and apply desired filters.

Tip: Data Managers can filter to see answered queries and then take action by closing or re-querying them.

Note: For more details on using panel and column filters, check out the article regarding Filters in Data Central.

Open Query Details View

From the Queries panel or the Related Queries section of a Record Details panel, there are multiple ways to open the query details view:

• Highlight a record and click the Details icon in the panel toolbar.
• Right-click a record and select Details.
• Double-click a record.

The panel toolbar displays a set of icons that allow you to navigate forward and backward through the queries listing, action queries, create issues, view history, dock the panel, maximize/restore the panel, or close the panel.

Use the scrollbar on the right to see more of the panel. The panel displays query details, followed by Related Form Data, and finally Comments and Related Issues. Comments and Related issues can be expanded to see existing or add new.

Action Queries

Queries can be managed individually by working in the Details panel, in groups from the Queries panel, or from the Related Queries section of a Record Details panel. Available actions depend on which actions are used by the relevant EDC system, the Status of the query, the Role Query Action settings as specified in the Data Central configuration for the study, and the user’s reviewer role. Actioning a query is available for studies with 2-way integration, such as Rave, Veeva, and InForm. Actions vary depending on the EDC system and may include answer, close, cancel, or requery.  

Other actions include:

• View or Add Comments - In the Comments section, click the expand arrow to see existing comments and add new comments to an open, answered, closed, or cancelled query.
• Add Issue - Click the Create Issue icon in the panel toolbar to enter details in the Create Issue window and click Save.
• View Field History - Click the Field History icon in the panel toolbar to view the activity on this query: action, user, date and time.

Important: The Close Query, Cancel Query, and Requery actions for each status may be configured differently in different studies. For EDC systems with 2-way query integration, these actions are passed through to the corresponding EDC queries. For queries from EDC systems that do not have 2-way query integration, the action and status stay within elluminate. View Field History may or may not be available depending on the EDC system for the study.

Action a Single Query

1. Open the Query Details View for a record. A separate panel opens.
   

   Note: Action the query in the open window or dock the panel to the sheet.

2. Use the panel toolbar icons to perform actions on the record.
3. Optionally, access and expand the Comments section to view or add comments.
4. Optionally, access and expand the Related Issues section to view related issues or create new ones using the Create Issue icon in the toolbar.
   

   Tip: Creating an issue within a query is useful if clarification is needed before closing it.

Action Multiple Queries

Filtering the query listing by status can streamline the process of managing multiple queries, This step is optional.

1. Select the desired record(s) in the Queries panel by checking the checkbox to the left of each record.
2. Click the Action icon (or right-click) and select the action.
   
   

   Note: Actions that are unavailable are grayed out. In the screenshot above, the listing was filtered to Answered queries, therefore, the only action available is Close Query.
   

   Tip: It may be helpful to maximize the window to see more of the details within the Queries panel.