SQL strings enable the application of advanced filters within SAP2000. The SQL string entered into SAP2000 corresponds to the portion of the full SQL Select Statement which follows the SQL Where Clause.

On this page:

Examples

Example 1 - Verification Example 1-024

To demonstrate, advanced filtering will be applied, using SQL strings, to the Joint Coordinates table of Verification Example 1-024 as follows:

Report 1 - select joints with X coordinate greater than 1

Report 1 selects all joints where the X coordinate is greater than 0, then sorts the data in order of XorR, Y, and Z coordinates using the SQL string which follows:

XorR > 0 ORDER BY XorR, Y, Z

The application of this advanced filter SQL string is shown in Figure 1:

Figure 1 - Advanced filter SQL string

Data is organized accordingly in the Joint Coordinates table, as shown in Figure 2:

Figure 2 - Joint Coordinates table

Report 2 - select joints with z coordinate greater than 12 and smaller than 14

Report 2 selects all joints with a Z coordinate between 12 and 14, then sorts the data by XorR, Y, and Z coordinates using the SQL string which follows:

Z > 12 AND Z < 14 ORDER BY XorR, Y, Z

The application of this advanced filter SQL string is shown in Figure 3:

Figure 3 - Advanced filter SQL string

Data is organized accordingly in the Joint Coordinates table, as shown in Figure 4:

Figure 4 - Joint Coordinates table

Example 2 - select only frame elements with specified labels

The following SQL string can be used to select only frame elements 1 and 2, report results for station 0 and only for load case DEAD (the filters are applied to a model created from scratch using the "3D Frames" template):

(Frame LIKE '1' OR Frame LIKE '2') AND Station = 0 AND OutputCase LIKE 'DEAD'

Note that operator LIKE is used for textual fields (Frame and OutputCase), while operation = is used for numerical fields (Station). See Figure 5.

Figure 5 - Filter by frame labels

External Links

• SQL Where Clause

• SQL tutorial by w3schools.com