Creating a Property Data Query - Honeywell DOC4000 - 7.3 - Help - Intergraph

You can use a property data query to search for objects and their property values. You can specify the criteria to define object types, properties and their values, and more.

To create and save a property data query:

1. Click Queries > Create/Edit Queries in the left navigation bar.

2. In Asset, select an asset for which you want to create the query. If you are creating a query for more than one asset of a specific type, select one asset of that type. The query will be listed for the asset you select.

3. Click Create Query. The new query settings and criteria options are displayed in the right pane.

4. In Query Type in the right pane, select Properties.

5. In For Objects of Type in the right pane, select the type of objects you want to include in the query.

6. If the object type includes subtypes, click the Subtypes link to select which subtypes to include. If the Subtypes link is available and you do not select any subtypes, DOC4000 includes all subtypes in the query.

7. If you want to run this query against a list of assets in addition to the asset you selected, complete the following steps:

   1. Click From Asset(s). The Assets window is displayed.

   2. In Available Assets, select the assets you want to include in the query, and then click >. The selected assets are listed in Included Assets.

   3. Close the Assets window.

8. If you want to select the properties to include in the query results, complete the following steps. If you do not select any properties, DOC4000 includes all common properties as columns in the results and sorts the results by object name. If the object type has no common properties, DOC4000 includes all properties in the results.

   If you selected multiple assets in From Asset(s), the Property Names list displays only the properties common to the object type for all selected assets. If the object type for any selected asset is missing a property, that property is not listed.

   1. Click Property Names. The Property Names window is displayed.

   2. In Property names, select each property you want to include in the results, and then click on the right arrow (>) to add the property to the Included in results list.

      You can use the Show Properties list at the bottom of the Property Names window to change which properties are listed. You can also select a property and click the Add item to common properties or Remove item from common properties links to change which properties are common for the selected object type. Common properties apply to all objects of that type for the selected asset.

   3. In Included in results, use the up and down arrow buttons below the list to set the order of the columns in the query results.

   4. If you want to modify the sort order, click each property in Included in results you want to use to sort the results, and then click the right arrow (>) to add the property to the Sort By list. By default, DOC4000 sorts the results by object name.

   5. In Sort By, use the up and down arrow buttons below the list to set the sort order for the query results.

   6. Close the Property Names window.

9. If you want to send the results of the query to a subquery, complete the following steps:

   1. Click the plus sign (+) button in the bottom right of the right pane options area.

   2. Click the type of subquery to add.

   3. Specify the settings and options for the selected subquery.

10. If you want to add more filters based on properties, complete the following steps:

    You can add filters based on properties and a selection list that defines a list of objects.

    1. Click Search Criteria.

    2. Click Select from properties.

    

    1. In the Property names list, select a property. You can use the Show Properties field to change which properties are listed.

    2. In the Operator list, select an operator to use to compare the property value with the text you specify in the Value field. You can also choose to compare whether a property exists.

    3. In Value, type a value or choose one of the values displayed in the list.

    4. Click ADD NEW.

    5. If you want to add more filter criteria expressions, repeat steps c-f as many times as needed. By default, DOC4000 uses AND to combine and evaluate all the criteria expressions. You can select expressions and then click GROUP AND or GROUP OR to change how expressions are evaluated together.

    6. When you are done specifying the parameter-based filter criteria you want, close the Search Criteria window.

11. If you want to add more filters based on a list of objects, complete the following steps:

    1. Click Search Criteria.

    2. Click Use selection list. The Available objects list includes all the objects you can select.

    3. If you want to create a saved list of objects that you can reuse, in Select list name, click Add New, and then type the new selection list name. In Available objects, select the objects you want, and click the right arrow (>) to add them to List details. Then, click Save List.

    4. If you want to use an existing saved list of objects, in Select list name, click the name of the selection list you want.

    5. If you want to modify an existing saved list of objects, in Select list name, click the name of the selection list you want. Modify the list as needed, and then click Save List to overwrite the saved list.

    6. If you want to add a typed list of objects to the List details field, copy a list of object names you want separated by spaces, commas, semicolons, or the pipe (|) character to the Windows clipboard, then click the clipboard icon at the top right of the List details field.

    7. If you want to search for the objects you want, type a search string using wildcard characters, such as *24*, in the Available objects field, and then click the magnifying glass icon to display a list of matching objects.

    8. If your search does not provide the results you want, delete the text in the Available objects field or type a new value and click the magnifying glass icon again.

    9. Select one or more objects from the Available objects list, and then click the right arrow (>) to move the selected objects to the List details field.

    10. Click Add Criteria to add the list of objects to the search criteria. If a list was previously added the criteria, or if you make additional changes, click Update Criteria.

    11. When you are done specifying the selection list-based filter criteria you want, close the Search Criteria window.

12. Click Run, and then review the results to make sure the query provides the results you want.

13. Click Save As. The Save Query pane is displayed.

14. In Enter a query name, type the name of the new query.

15. Select whether to make the query Public or Private.

16. If you want the query to be available for all assets of this type, check Save with Asset Model.

17. Click OK.

18. Click OK on the confirmation message.

Now you can run the query or use it as a basis for a report. For more information, see Running a Query.