Auto-Queries in Watch My Domains Desktop

Domain auto-query filters are a set of predefined SQL queries designed to display domains of interest. These filters are accessible under the "Auto" tab in the left pane.

Users can create, edit, or delete these filters as needed. The simplest way to add an auto filter is by entering a query string after clicking the "Add" button in the footer.

For example, the auto-query entry below will list all domains that have an empty domain status.

(d.domain_status IS NULL OR d.domain_status='')

You can store auto-queries using the Categories > Save Autoqueries menu option, ensuring that the auto-queries from your current document become the default for all newly created documents.

Query for a Specific Category/Folder

Queries can be limited to a single Category/Folder, but this requires using the database Category ID.

If you know the Category ID, you can filter domains assigned to that category using an IN clause against the category mapping table.

Example

If the Business Domains category has an ID of 2, you can use an Auto Query like:

domainid IN (
  SELECT DISTINCT domainid
  FROM domaintocat
  WHERE categoryid = ?
)

Supply 2 as the parameter value to return only domains assigned to that category.

Finding the Category ID

To find the Category ID, follow these steps:

Step 1: Export the categories

Use Categories > Save Categories to export the category list.

Step 2: Open the categories file

Open the following file in a text editor to view the categories and their IDs:

• Windows: %APPDATA%\Watch My Domains Desktop\assets\categories.json
• macOS: ~/Library/Application Support/Watch My Domains Desktop/assets/categories.json