Search & Filtering - TLOGic Help

Quick Access

Press Ctrl+F (or Cmd+F on Mac) to instantly open the search panel from any page. Use the icon in the search panel for quick reference.

Search Basics

TLOGic's search system allows you to filter transactions based on multiple criteria using a simple but powerful query language. Search queries consist of field specifiers and values, combined with logical operators.

Search Field Keywords

Use these keywords to search specific transaction fields:

key or k	Transaction Key - The transaction type identifier
txn or tx	Transaction Number - Sequential transaction ID
t or term	Terminal - Register/terminal number
op or oper	Operator - Operator/cashier ID
off or offset	File Offset - Byte position in file
size	Record Size - Transaction size in bytes
dt or datetime	Date/Time - Transaction timestamp
tt or type	Transaction Type - Sale, return, void, etc.

Logical Operators

OR Logic (Comma)

Use commas , to match any of the specified values (OR logic).

t:1,2,3

Transactions from terminals 1, 2, OR 3

op:5,10,15

Transactions by operators 5, 10, OR 15

AND Logic (Semicolon)

Use semicolons ; to require all conditions to match (AND logic).

t:1;op:5

Transactions from terminal 1 AND operator 5

key:10;tt:1

Transactions with key 10 AND transaction type 1

Combining OR and AND

Combine both operators for complex queries. The system processes each criterion independently.

t:1,2;op:5,6

Terminals (1 OR 2) AND Operators (5 OR 6)

key:10,20,30;tt:1;t:1

Keys (10 OR 20 OR 30) AND type 1 AND terminal 1

Numeric Comparisons

Comparison Operators

Use standard comparison operators for numeric fields:

`=`	Equal to
`>`	Greater than
`>=`	Greater than or equal to
`<`	Less than
`<=`	Less than or equal to

txn:>=1000

Transactions numbered 1000 or higher

size:>256

Transactions larger than 256 bytes

op:>=10;<=20

Operators between 10 and 20 (inclusive)

Range Notation

Use the double-dot .. operator for inclusive ranges:

txn:100..500

Transactions 100 through 500 (inclusive)

off:1000..5000

Transactions at file offsets 1000-5000 bytes

t:1,2 txn:500..1000

Terminals 1 or 2, transactions 500-1000

Date & Time Searches

Date Formats

TLOGic accepts flexible date/time formats:

YYYY-MM-DD - ISO date format (e.g., 2024-03-15)
MM/DD/YYYY - US date format (e.g., 03/15/2024)
YYYY-MM-DD HH:MM - Date with time (e.g., 2024-03-15 14:30)
YYYY-MM-DD HH:MM:SS - Full timestamp

dt:2024-03-15

All transactions on March 15, 2024

dt:>=2024-03-01;<2024-04-01

All transactions in March 2024

dt:2024-03-15 14:00..2024-03-15 16:00

Transactions between 2:00 PM and 4:00 PM on March 15

Date Range Tip: Date searches are rounded to the minute. A search for a specific date includes all transactions from midnight to 11:59 PM that day.

Transaction Type Searches

Common Transaction Types

Use the tt: or type: keywords to filter by transaction type:

tt:1

Sale transactions only

tt:2

Return transactions only

tt:3

Void transactions only

tt:1,2

Sales and returns (excluding voids)

Note: Transaction type codes may vary based on your POS system configuration. Check your TLOG metadata or documentation for specific type codes.

Practical Search Examples

Operator Analysis

Find all transactions for a specific operator on a specific day:

op:5;dt:2024-03-15

Compare two operators' transactions:

op:5,10;tt:1

Sale transactions by operators 5 or 10

Find training transactions:

tt:4

Training mode transactions

Troubleshooting Transactions

Find large transactions (potential data issues):

size:>1024

Transactions larger than 1KB

Find void transactions in a specific time range:

tt:3;dt:>=2024-03-15 08:00;<=2024-03-15 17:00

Voids during business hours on March 15

Analyze terminal-specific issues:

t:3;tt:2,3

Returns and voids from terminal 3

Business Analysis

Morning rush analysis:

dt:2024-03-15 07:00..2024-03-15 09:00;tt:1

Sales during morning hours

Multi-terminal comparison:

t:1,2,3;tt:1;dt:2024-03-15

Sales from terminals 1-3 on March 15

High-transaction-number analysis:

txn:>=5000

Transactions after #5000 (busier period)

Deep Field Filtering

Advanced Feature

Deep field filtering allows you to search within the internal structure of transactions, accessing nested fields and specific data elements. This is useful for advanced users who need to filter by specific field codes or values within the transaction record.

Using Deep Filters

Access the Deep Filters panel from the search controls to add field-specific criteria:

Click "Deep Filters" in the search controls section
Click "Add Filter" to create a new criterion
Enter the field path (e.g., amount, department_id)
Choose an operator (equals, contains, greater than, etc.)
Enter the value to match
Click "Apply" to filter transactions

Common deep filter fields:

amount - Transaction amount
tender_type - Payment method
department_id - Department number
item_code - Product SKU
customer_id - Customer identifier

Performance Tip: Deep field filtering uses high-performance WASM processing but may take longer on very large files. Use basic filters first to narrow down results, then apply deep filters for precision.

Search Tips & Best Practices

Do This

Start with broad searches, then narrow down
Use range notation for numeric sequences
Combine criteria to create precise filters
Save complex queries as notes for reuse
Use date ranges for period analysis

Avoid This

Don't use spaces in field values
Avoid overly complex nested queries
Don't forget the field specifier (e.g., txn:)
Don't mix date formats in one query
Avoid searching without criteria (slow)

Keyboard Shortcuts

`Ctrl/Cmd + F`	Open/close search panel
`Enter`	Execute search query
`Esc`	Clear search and show all transactions
`?`	Show search help (when search is focused)