OLE DB Query Syntax - trillium_discovery - trillium_quality - 17.1

Trillium Reporting Adapter for Excel Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Reporting Adapter for Excel Guide
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2012

The following is an example of the syntax used when you add Trillium parameters to an OLE DB query:

show_all_br?eid=1&columns=ENTITY_ID%20STATUS&show_disabled

where

  • ? separates the query from the parameters

  • & separates parameters

  • %20 adds a space between parameter items in a list