To Define a Flat Search

1. In the Infrastructure Administrator, do one of the following:
   • Click Enterprise and connect to the enterprise industry model. Open a project.
   • Click File and open an industry model drawing or template.
2. Expand the Industry Model node and click Feature Search Administrator.
3. Click Create to define a new search.
   • Enter a name, such as Streets - Flat.
   • For Type, select Flat Search.
4. Click OK.
5. In the Feature Search Administrator, click the Settings tab and specify the search query, using options as shown in the following table:

   Basic	Defines a data source. Define a view or select a table containing all data. This data source must contain a Key Attribute (primary key), a Geometry Attribute, and at least one input attribute (Attribute 1). Note: Because a data source that has not been normalized is very slow, optimize the data with indices and compute the statistics. Optionally, you can specify a sort attribute to order the result rows. The data in this table or view is normally in the first normal form (also called 1NF). Note: First normal form (1NF) is used in database normalization. A relational database table that adheres to 1NF ensures that the table is a faithful representation of a relation and that it is free of repeating groups.
   Search Attributes	The description appears when you execute the search.
   Additional Where Clause	Adds a WHERE clause to the automatically composed select statement.
   Validate	Validates the select statement.

   Here is an example of a flat search that finds a parcel marking by point number, marker, surveyor, reliability or dossier:

   Name	Parcel Markings
   Table Name	LM_BORDERPOINT (This table stores all filter attributes. If they are stored in different tables, you can create a view containing the attributes.)
   Attribute 1 Description	Point Number
   Attribute 1	BORDER_POINT_NUMBER
   Attribute 2 Description	Marker
   Attribute 2	ID_BORDER_POINT_TYPE
   Attribute 3 Description	Dossier
   Attribute 3	DOSSIER
   Key Attribute	FID
   Geometry Attribute	GEOM
   Sort Attribute	BORDER_POINT_NUMBER

For more information, see Feature Search: Flat Search.