home

Contracts

Adobe Sign ServicesAdvantage Platform AdministrationApprovals for Advantage PlatformApprovals for SalesforceBilling for Advantage PlatformBilling for SalesforceCLM for Advantage PlatformCLM for SalesforceContracts for SalesforceCollaborateComposer for Advantage PlatformComposer for SalesforceContractsConga for Google DocsConga Upgrade ProgramContract Intelligence (Standalone)CPQ for Advantage PlatformCPQ for SalesforceDeal MaximizerDigital Commerce for Advantage PlatformDigital Commerce for SalesforceDiscovery AI for Advantage PlatformDiscovery AI for SalesforceDocusign ServiceseSignature Integration with Advantage PlatformGridInvoice GenerationMix FormsOrchestrateOrder Management for Advantage PlatformOrder Management for SalesforcePartner Commerce for Advantage PlatformPartner Commerce for SalesforceQuote GenerationSign for Advantage PlatformSign for SalesforceSmart SearchTurboEnginesX-Author for Contracts 1.0 (Classic)X-Author for ContractsX-Author for Contracts Advanced for Advantage PlatformX-Author for Contracts Advanced for SalesforceX-Author for ExcelX-Author for Migration ManagerRelease NotesGeneral
Adobe Sign ServicesAdvantage Platform AdministrationApprovals for Advantage PlatformApprovals for SalesforceBilling for Advantage PlatformBilling for SalesforceCLM for Advantage PlatformCLM for SalesforceContracts for SalesforceCollaborateComposer for Advantage PlatformComposer for SalesforceContractsConga for Google DocsConga Upgrade ProgramContract Intelligence (Standalone)CPQ for Advantage PlatformCPQ for SalesforceDeal MaximizerDigital Commerce for Advantage PlatformDigital Commerce for SalesforceDiscovery AI for Advantage PlatformDiscovery AI for SalesforceDocusign ServiceseSignature Integration with Advantage PlatformGridInvoice GenerationMix FormsOrchestrateOrder Management for Advantage PlatformOrder Management for SalesforcePartner Commerce for Advantage PlatformPartner Commerce for SalesforceQuote GenerationSign for Advantage PlatformSign for SalesforceSmart SearchTurboEnginesX-Author for Contracts 1.0 (Classic)X-Author for ContractsX-Author for Contracts Advanced for Advantage PlatformX-Author for Contracts Advanced for SalesforceX-Author for ExcelX-Author for Migration ManagerRelease NotesGeneral

Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Show Contents

Show Page Sections

Contracts

Search

download

Creating a Search Query

Search Query is a robust feature that allows you define a set of criteria to search the populated fields in a Contract, Company, or Project Profile. This feature is useful in locating very specific information about the companies, contracts, and projects stored in Conga Contracts. You can also use a set of criteria to search for contract requests and the clauses stored in the Clause Library.

Search queries can also be performed to locate associated information, such as company relationships and specific messages sent and received in Conga Contracts. Currently, most of the stored data can be searched and reported upon, including the documents uploaded to individual Company and Contract Profiles using either an elastic search or the classic search.

The search query below will locate all the Supplier contracts with an Individual Agreement Type that are set to expire one year from the date on which the search is run.

  1. Click Search in the Navigation Toolbar, and select the Search Query link in the menu.
  2. In the Query Info view of the screen, clic kNew in the toolbar.
    Tip:

    Review the search queries you have already saved by clicking on individual links in the Recent Searches section since updating a search query might be more efficient than creating a new query. To view a complete list of all your saved searches, as well as the global searches that have been shared by other users, click Load in the toolbar at the bottom of the screen.

  3. When the screen refreshes, set up the Company→Contract→Document hierarchy as the data set for the search:
    • Click in the field list to display the hierarchy, and click the arrow icon to the left of the Company folder to expand the folder list.
    • Scroll down past the alphabetical listing of fields in the Company Profile, and click the arrow icon to the left of the Contract folder.
    • Scroll down past the alphabetical listing of fields in the Contract Profile, and click the Document folder.
  4. Use the All Top Entity Records check box to expand or limit your search results:
    • Select the check box to include results in each category listed in the Result Type hierarchy, which include Company records, Contract records, and Document records in this example.
    • Clear the check box to limit search results to the records in the second (and lower) levels, which include Contract records and Document records in this example.
  5. In the Criteria section, define the criteria for the search:
    • Identify the company as a supplier:
    • Click in the field list to display the hierarchy, click the arrow icon to the left of the Company folder, and click the Company Type folder.
    • Click in the inclusion list and select In.
    • Click in the value list and select Supplier.
    • Click And to provide additional criteria and limit search results. (Click Execute in the bottom left corner to expand search results.)
    • Identify the agreement type for the expiring contract:
    • Click in the field list, scroll past the fields in the Company Profile to the Contract folder and click its arrow icon, and then click the Agreement Type folder.
    • Click in the inclusion list and select In.
    • Click in the value list and select Individual.
    • Click And to provide additional criteria.
    • Identify the document type of the expiring contract:
    • Click in the field list, scroll down past the fields in the Company and Contract folders to the Document folder and click its arrow icon, and then scroll down and click the Document Type folder.
    • Click in the inclusion list and select In.
    • In the value list and select both Executed Contract and Final Word Version to cover the possible options for the final version of the contract.
    • Click And to provide additional criteria.
    • Identify the timeframe for the contract document:
    • Click in the field list, scroll down past the fields in the Company and Contract folders to the Document folder, locate the Document Current Expiration Date folder, and click it to select it.
    • Click in the inclusion list and select After: today plus (x) days to ensure the search is based on the current date.
    • Click in the value field and enter 365 to search for contracts expiring within one year.

      The Not Empty, Null, and Not Null operators in the inclusion list do not require a value.

  6. Click Execute in the toolbar to run the query.
  7. When the Results view of the screen displays, review the search results.(Optional) Click a search record to be directed to its Contract, Company, or Project Profile.
    Tip:

    To redisplay the criteria for the search, click the Query Info header at the top of the screen. To redisplay the results, click the Results header at the bottom of the screen.

  8. (Optional) Customize the display of the search results:
    • Hover over a column heading until the down arrow displays, and click on it to open the Sort/Column menu. Click Columns to display a list of available fields, and select the fields you want displayed by clicking in the check box to the left of the field.
    • Sort the information in a column in ascending or descending order by clicking (toggling) on the column heading.
    • Resize a column by hovering over the right or left border of the column heading until the resize icon appears. Then, click and drag the border to the desired width.
    • Move a column to a different location in the Results screen by clicking on the column heading and dragging it to the left or right, dropping it in the desired location. When the green tick icon displays, you are successfully moving the column.
  9. (Optional) Export the data in the Results screen:
    • Click Export to Excel to generate an Excel spreadsheet showing the information displayed in the screen.
    • Click Bulk Download Documents to export the results to a zip file that is downloaded to your PC. Open the zip file to extract the individual documents.
    • Click Run Advanced Report to run an advanced report for the search results.
  10. (Optional) Click Save Query in the toolbar to save the search query for future use.
    • In the Save Search Query prompt:
    • Enter a name for the search in the Filter Name field.
    • Enter a comprehensive description of the search in the Description field.
    • Click Save.

Criteria Record Fields

A criteria record includes a field list, and inclusion list, and a value list or field. The table below summarizes the options for the fields that comprise a criteria record.

Field List

Inclusion List

Value List or Field

Use the expand (down arrow) icons to drill down and select the field for a criteria record.

  • If the criteria is a text field, the options are:
  • In - selection(s) in the value list appear in the search results.
  • Not In - everything except selection(s) in the Value list appear in the search results.
  • Is Null - displays search results where the field has a zero (0) value or is empty.
  • Is Not Null - displays search results where the field has a numeric value or is populated.
  • If the criteria is a value field, the options are:
  • Equals - search results are returned for number entered in the value field.
  • Greater Than - search results are returned for numbers larger than the one entered in the value field.
  • Less Than - search results are returned for numbers smaller than the one entered in the value field.
  • If the criteria is a date field, the options are:
  • Before - search results are returned for all dates before the date entered in the value field.
  • On - search results are returned for the date entered in the value field.
  • After - search results are returned for all dates after the date entered in the value field.
  • Null - search results are returned for all records whose date field is not populated.
  • Not Null - search results are returned for all records whose date field contains any date.
  • Four ways to pinpoint a specific date:
    • After: today minus (x) days
    • After: today plus (x) days
    • Before: today minus (x) days
    • Before: today plus (x) days)

For example, if today is January 1, 2018 and you want to search for contracts that expire prior to January 1, 2019, you would set up two criteria inclusion lists to establish the time frame by clicking on And. In the first inclusion list, select the Before: today plus (x) days operator and enter 365 in the value field. In the second inclusion list, select the After: today plys (x) days operator and enter 0 in the value field.

  • Value list includes text options
  • Value field can accommodate a number or date

A search query can be run to locate the clauses that have been revised by selecting Clause in the Result Type list, and then selecting Clause Revision as the search field in the Criteria record. Using an operator (Equals, Greater Than, or Less Than) and entering the appropriate number in the value field will generate the desired results. For example, to locate all clauses that have been revised more than once, select Greater Than as the operator and enter "1" in the value field.

User Guide
Contracts

January 2, 2025