text: **14.1.1 What documents are needed**
  
  In our example, we identified our documents as the customer statements. How do you identify 
  the customer report that you need from the hundreds of thousands of documents that are 
  stored in Content Manager OnDemand? Certain customers might receive multiple monthly 
  statements. 
  
  In general, you identify the documents by creating an SQL query that uses index fields and 
  values that uniquely identify the documents that you want to retrieve when they are loaded. 
  You can then define the distribution to include multiple report bundles with different SQL 
  queries for each bundle. If the SQL must retrieve the document that is the same except for a 
  value that identifies the recipient, a single distribution can be used with a recipient list. In this 
  case, the SQL specifies a wildcard value. When processing, ODF fills in the recipient ID in the 
  SQL statement. For example, a recipient list contains recipients 100001, 100002, and 100003 
  and an SQL statement of “Where branch_id = '$ODF_RECIPIENT'”. When this recipient list is 
  processed, ODF creates a distribution for recipient 100001 with all reports where branch_id = 
  '100001', recipient 100002 will receive a distribution that contains all reports where branch_id 
  = '100002', and so on. 