I am trying to understand what a TRIGGER does
Is this correct?
The trigger is the starting point for searching for the Indexing parameters
Once a trigger is found it will look for your 1st, 2dn, 3rd index fields and so on.
OnDemand breaks up reports using the trigger when Index parameters change
For example: Branch, report names, customer numbers
Lets say you had a report which looked like this, and I only used name as a Index
John Smith 12345 12/31/2006 Page 1
Tub 1000 ea Page 2
John Smith 32461 12/31/2006 Page 1
Faucet 1000 ea Page 2
Frank Smith 12345 12/31/2006 Page 1
Tub 1000 ea Page 2
I would use Page 1 as a Trigger
Once the trigger is found the indexing would start looking for the name field
Every time Page 1 is found OnDemand will start the Indexing again
In the search criteria you would see
John Smith
Frank Smith
Here is another example using F101 as the TRIGGER
John Smith 33345 12/31/2006 F101
Tub 1000 ea
John Smith 32861 12/31/2006 F101
Faucet 1000 ea
Frank Smith 34565 12/31/2006 F201
Tub 1000 ea
You would see in the search criteria
John Smith
F101 was only found for John Smith so Frank Smith would not be broken out into another search field
Is this correct or does a report get broken up by the Indexes changing.
