14.2 Searching, Advanced Filters, Saved Views & Page Inspection

14.2 Searching, Advanced Filters, Saved Views & Page Inspection

Quick Summary: Efficient data location and system diagnostics in Dynamics 365 Business Central rely on five core capabilities: Tell Me (Alt+Q) for feature and action navigation, Quick Search (F3) for multi-column list queries, The Filter Pane (Shift+F3) for combined record filters and FlowFilters, Saved Views for persisting tailored list configurations, and Page Inspection (Ctrl+Alt+F1) for inspecting underlying Page IDs, Table IDs, extension ownership, and unexposed field values. To trace transactions across tables, Find Entries traverses the database to display all ledger entries and documents sharing a common Document Number and Posting Date.

---

Search Capabilities: Quick Search vs. Tell Me

Users often confuse navigation searching with record querying. Business Central provides two foundational search tools that operate on completely distinct data boundaries.

Search Boundaries in Business Central:

[Tell Me: Alt+Q]      ──► Global Feature Discovery (Pages, Tasks, Reports, Documentation, Actions)
                          Does NOT search individual record rows or table values.

[Quick Search: F3]    ──► List Data Query (Searches all visible columns on the active list page)
                          Queries record rows using full-text substring matching.

1. Tell Me (What do you want to do? / Alt+Q)

Located in the top application banner (or launched via Alt+Q), Tell Me serves as the universal navigation engine. It matches user search terms across:

• Pages and Tasks: Direct links to list pages, card pages, setup pages, and journals.
• Reports and Analysis: Direct links to standard RDLC, Word, Excel, and Power BI reports.
• Current Page Actions: Discovers and triggers action bar buttons on the active page without requiring manual menu navigation.
• Documentation & AppSource: External links to Microsoft Learn articles and third-party AppSource apps.

2. Quick Search (Search List / F3)

Located in the top right corner of every list page (or activated via F3), Quick Search executes an immediate full-text query across all visible columns of the active dataset. Entering London filters the list to show any record containing "London" in the Name, Address, City, or Contact columns. It does not evaluate columns that are currently hidden.

---

Advanced Filtering & The Filter Pane (Shift+F3)

For precise data analysis, users expand the Filter Pane by clicking the filter funnel icon or pressing Shift+F3. The Filter Pane exposes two fundamentally different filtering tiers:

Filter Pane Architecture (Shift+F3):

┌─────────────────────────────────────────────────────────────┐
│ FILTER PANE                                                 │
│                                                             │
│  ▼ Filter list by...          <-- Record Filters            │
│     No. : 10000..20000            (Evaluates static data    │
│     Blocked : ' '                  stored in Table 18)      │
│                                                             │
│  ▼ Filter totals by...        <-- FlowFilters               │
│     Date Filter : 01/01/26..03/31/26 (Calculates FlowFields │
│     Global Dimension 1 : ADMIN     like Net Change/Balance) │
└─────────────────────────────────────────────────────────────┘

Record Filters ("Filter list by...")

Record filters evaluate static data stored in specific table columns. Records are excluded from the view if their static field values do not satisfy the criteria (e.g., City = Atlanta).

FlowFilters ("Filter totals by...")

FlowFilters are specialized virtual filter fields that do not filter out master records. Instead, they provide calculation parameters to FlowFields (dynamically computed formula fields derived from underlying ledger entry tables).

The Critical Difference in Master Data

Consider the Chart of Accounts (G/L Accounts) or the Customer List:

• If an accountant filters the Chart of Accounts using Filter list by... Posting Date = 01/01/26..03/31/26, the system throws an error or returns nothing because the G/L Account table does not possess a static field named "Posting Date".
• Instead, the accountant expands Filter totals by... and enters 01/01/26..03/31/26 into the Date Filter FlowFilter.
• Result: Every G/L Account remains visible in the list, but calculated FlowFields (such as Net Change and Balance at Date) dynamically recalculate to reflect transactions posted strictly within that date window.
• Master tables support several standard FlowFilters:
  • Date Filter: Restricts the date calculation window for ledger aggregations.
  • Global Dimension 1 / 2 Filter: Restricts calculation to specific department or project codes.
  • Location Filter: Restricts inventory calculations on Item cards to specific warehouse facilities.
  • Currency Filter: Filters customer or vendor balances by transactional foreign currency.

---

Business Central Filter Syntax & Operators

Business Central features a powerful filter expression syntax that supports complex Boolean logic, ranges, wildcards, and date formulas.

Standard Date Formulas in Filters

When filtering date fields, Business Central recognizes dynamic system date codes:

• t or T: Evaluates to Today's date (system clock).
• w or W: Evaluates to the current Work Date configured under My Settings.
• cm or CM: Current Month (e.g., 01/01/26..cm filters from Jan 1 through the end of January).
• cy or CY: Current Year (e.g., 01/01/26..cy filters through Dec 31).
• Relative Date Formulas: -1M..t (past month through today), t..+1W (today through one week ahead).

---

Saved Views: Preserving Customized List Perspectives

A Saved View allows users to preserve a customized combination of filters, FlowFilters, column layouts, and sorting orders as a dedicated, reusable tab on a list page.

Saved View Structure on List Pages:

Customer List Page
  ├── [All]              (Standard unfiltered baseline)
  ├── [Overdue Domestic] (Filter: Balance Due > 0 & Country = US | Saved View Tab)
  └── [EU Wholesale]     (Filter: Gen. Bus. = EU & Price Group = WHOLESALE | Saved View Tab)

Creating and Managing Saved Views

1. Open any list page (e.g., Customer Ledger Entries).
2. Expand the Filter Pane (Shift+F3) and define record filters (e.g., Open = Yes, Due Date = <t).
3. Click the Save view as floppy-disk icon at the top of the Filter Pane.
4. Enter a descriptive title (e.g., Overdue Open Entries).
5. The saved view is immediately pinned as a distinct tab at the top of the list grid.
6. Scope: Saved views created by end users are stored per-user. However, administrators configuring pages via Profile Customization can create saved views that are permanently deployed to every user assigned to that profile.

---

Page Inspection (Ctrl+Alt+F1): The Diagnostic Hub

Page Inspection (Ctrl+Alt+F1 or Help & Support > Inspect pages and data) is the most essential troubleshooting and diagnostic tool available to functional consultants and administrators.

Page Inspection Slide-out Pane (Ctrl+Alt+F1):

┌─────────────────────────────────────────────────────────────┐
│ PAGE INSPECTION                                             │
│                                                             │
│ Page: Customer Card (21)                                    │
│ Source Table: Customer (18)                                 │
│ Extension: Base Application by Microsoft (24.0.0.0)         │
│                                                             │
│ ▼ Page Filters                                              │
│   No. is '10000'                                            │
│                                                             │
│ ▼ Table Fields (Inspects all 120+ table fields)             │
│   Field No. | Field Name          | Value                   │
│   1         | No.                 | 10000                   │
│   2         | Name                | Adatum Corporation      │
│   102       | E-Mail              | contact@adatum.com      │
│   2000000   | SystemId            | 4f2e8b1a-9c2d-4e8f...   │
│   2000001   | SystemCreatedAt     | 2026-01-15 08:30:12     │
└─────────────────────────────────────────────────────────────┘

Key Metadata Elements Exposed by Page Inspection

1. Page Identification: Displays the exact Page Name, Page ID (e.g., Page 21), and Page Type (Card, List, Worksheet, Document).
2. Source Table Identification: Displays the underlying database Table Name and Table ID (e.g., Table 18 Customer).
3. Extension Ownership: Identifies which extension contributed the page, as well as which extensions introduced specific controls or fields. If an error is caused by a third-party AppSource app, Page Inspection reveals the owning extension.
4. Unexposed Table Fields & Raw Values: Displays every single field in the underlying table record—even fields completely absent from the UI, hidden technical flags, calculated FlowFields, and system audit fields (SystemId, SystemCreatedAt, SystemModifiedAt).
5. Active Filters: Shows all filters currently applied to the record set, including user-defined UI filters, page view filters, and system-enforced AL TableFilter or SecurityFilter constraints.

[!NOTE] Page Inspection is strictly a read-only diagnostic viewer. It cannot be used to modify field values or alter table schemas.

---

Find Entries (Formerly Navigate): Transactional Audit Tracing

When investigating posted financial or operational activities, consultants use Find Entries (historically named Navigate in older Dynamics NAV / BC versions). It traces all ledger entries, registers, and posted documents created by a single business transaction.

Find Entries Relational Trace:

[Transaction Identifier: Document No. 'INV-102001' + Posting Date '03/15/2026']
       │
       ├──► G/L Entry (6 records)          -> Debits Receivables, Credits Sales & VAT
       ├──► Cust. Ledger Entry (1 record)  -> Customer subledger open balance
       ├──► Detailed Cust. Ledg. Entry (1) -> Initial transaction amount
       ├──► Item Ledger Entry (2 records)  -> Relieves inventory quantity on hand
       ├──► Value Entry (2 records)        -> Relieves inventory asset valuation
       ├──► VAT Entry (1 record)           -> Tax ledger reporting
       ├──► G/L Register (1 record)        -> Audit trail batch identifier
       └──► Posted Sales Invoice (1 doc)   -> Historical printed document header

How Find Entries Works

• Access: Click Find entries on any posted document header, ledger entry line, or search via Tell Me (Alt+Q -> type Find Entries).
• Matching Criteria: Automatically populates the Document No. and Posting Date of the active record. Users can also search by Business Contact Type/No. or External Document No.
• Execution: Business Central queries every ledger table, subledger table, register table, and posted document header table in the database.
• Results Grid: Summarizes all related tables with a No. of Records count. Users click any count to drill directly into the underlying ledger entries or view the original posted document.