Action disabled: source

Administration: Omnidex Features

Omnidex Segments

Querying Segments

Omnidex Segments can be referenced as criteria in a future query using the $SEGMENT function. The $SEGMENT function references the object name for any segment previously created in the same connection. Since Omnidex Segments already contain index pointers, they are incorporated into a search with very high performance.

The following example shows several segments that were created in the previous page being referenced in a query using the $SEGMENT function:

> ; Fulfill the query based on the final segment;
> select        INDIVIDUAL,
>>               BIRTHDATE,
>>               CITY,
>>               STATE
>>   from        INDIVIDUALS
>>   join        HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD
>>   where       INDIVIDUAL in ($segment(PART_1), $segment(PART_2)) and
>>               INDIVIDUAL = $segment(PART_3);

INDIVIDUAL    BIRTHDATE     CITY                          ST
------------  ------------  ----------------------------  --
000400191550  1996-04-26    PHOENIX                       AZ
000400575367  1996-11-19    PHOENIX                       AZ
000400575366  1995-09-26    PHOENIX                       AZ
000400575369  2005-06-29    PHOENIX                       AZ
000400575368  2004-07-30    PHOENIX                       AZ
000403467439  1994-08-28    PHOENIX                       AZ
000403467441  2003-04-19    PHOENIX                       AZ
000403467440  1997-02-28    PHOENIX                       AZ
000800345452  1998-08-31    DENVER                        CO
000800345453  2003-12-25    DENVER                        CO
000801610627  2004-03-17    DENVER                        CO
000802420583  1990-03-18    DENVER                        CO
000802420584  1993-10-06    DENVER                        CO
000803400688  1990-06-16    DENVER                        CO
000803400689  1990-10-25    DENVER                        CO
000803760388  2006-07-30    DENVER                        CO
000803760386  1995-12-09    DENVER                        CO
000803760387  1997-09-24    DENVER                        CO

18 rows returned

Additional Resources

See also:

 
Back to top
admin/features/segments/querying.txt ยท Last modified: 2016/06/28 22:38 (external edit)