Defining queries
Define a query or edit existing queries in the Query Editor. Once you've defined the query, you can test it before actually running it on a site or group of files. Queries you create and save are listed in the Filename section of the Queries window, and are stored in the Queries folder in the Extras tab of the site window. Structuring a query in the Query Editor.
To define a query: - Choose Edit > Run Query.
Note: To create an application-wide query, don't open a site before opening the Query Editor. - Click the New Query button.
- If desired, type a description of the query in the Description field in the Query Editor.
- Choose an option from the Find What menu (see Query options), and then set options in the Settings pane.
- To add more criteria to the query, click the arrow to the right of the Find What menu and choose an add, or, or not item:
- Choose And to specify that all criteria must be satisfied. For example, if you select this option and define a query to show files that were created over two weeks ago and contain external links, the query shows only those files created over two weeks ago that contain external links.
- Choose Or to specify that any, but not all, of the criteria must be satisfied. For example, if you select this option and define a query to show files that were created over two weeks ago or contain external links, the query shows the files created over two weeks ago with or without external links, and the files that contain external links regardless of when they were created.
- Choose Not to specify that the first set of criteria must be satisfied but the second set of criteria must not be satisfied. For example, if you select this option and define a query to show files that were created over two weeks ago and do not contain external links, the query shows only those files created over two weeks ago that do not contain external links.
- Continue to define query criteria using the Find What menus and add, or, or not items. You can drag and drop query criteria above, beneath, or next to other query criteria (as you drag, black bars appear next to the existing criteria, indicating the location of the new criteria).
- Delete criteria by choosing Delete from the menu to the right of the Find What menu.
- To test the query, click Test Query.
- Close the Query Editor to save the query. Enter a name for the query in the Save Query File dialog box (the .aglq extension is provided automatically), and then click Save.
To edit an existing query: - Choose Edit > Run Query.
- Select the query you want to edit and click Edit Query.
- Make changes to the query as detailed in Defining queries.
- Close the Query Editor and click Yes when prompted to save changes.
|