Building a Board-Based Search Query

Building a Board-Based Search Query
 

📌 Summary

This article explains how to build an Advanced Search query for Boards in Ontraccr. Unlike form queries, board-based searches are built around card templates and allow you to filter across one or many boards that share the same card design.


📍 Where to Start

  1. Go to the Advanced Search interface.
  2. Click the Boards tab on the left.
  3. Click Open Search to launch the right-hand search slider.

🧠 How Board Search Works

In Ontraccr, boards are structured using card designs.

A card design defines the layout and fields for cards used on one or more boards.

Board-based search allows you to:

  • Select a card design
  • Choose which boards using that card design to include in the search
  • Apply filters using standard and custom card fields

🛠 Step-by-Step: Building a Board Query

1. Select a Card Type

  • Choose the card design (e.g. “Project Tracker”, “Service Tracker”).
  • This determines what fields will be available for filtering.

2. Choose Which Boards to Search

  • Default is “All” boards using that card design.
  • Optionally, select specific boards from the dropdown list.

3. Choose Filter Logic

  • Like form search, you’ll be asked:
    • Match all conditions (AND logic), or
    • Match any condition (OR logic)

4. Add Conditions

Click Add Condition to filter by available fields.


📦 Default Card Fields (Available for All Card Designs)

These are always available regardless of card design:

  • Title
  • Status
  • Card Number
  • Created At
  • Last Updated
  • Linked Customer
  • Linked Project
  • Linked Equipment
  • Linked Material
  • Linked User

🧷 Custom Fields (Design-Specific)

After the default fields, you’ll see any additional fields defined in the selected card design.

Example: If the card template includes “Customer Name” or “Date Stamped”, those will appear as options.


🔧 Filtering Operators

Operators vary by field type. Examples include:

  • Equals, Does Not Equal
  • Includes (for partial matches, e.g. “ABC Inc.”)
  • Date filters: Before, After, Within

🧪 Example Query

To find all active service tickets for “ABC Inc.”:

  • Card Type: Service Tracker
  • Field: Customer Name
  • Operator: Includes
  • Value: ABC Inc.

🧯 Notes

  • The filter panel behaves almost identically to the Forms tab but is driven by card design, not form templates.
  • Results may vary depending on field availability per card.

Was this article helpful?