Group 65
Go to Trevor.io
All Collections
Finding specific records
Finding specific records
You can use Trevor.io to look up records (e.g. customers or transactions) in your database
8 articles in this collection
Written by
Harry
Identify and explore your Users table
Written by
Harry
Updated over a week ago
Identify and explore your Transactions table
Get to know the table containing transactions / orders, bookings / reservations / sales etc.
Written by
Harry
Updated over a week ago
Look up a specific customer or user
How to find a specific customer in your database
Written by
Harry
Updated over a week ago
Look up sales associated with a particular customer or user
Find transactions associated with a specific customer
Written by
Harry
Updated over a week ago
Look up cancelled sales / orders
Identify orders / transactions / sales / bookings etc that have been cancelled
Written by
Harry
Updated over a week ago
Look up a customer's first, or most recent, transaction
Find the earlier, or latest, transaction / booking / order etc made by a customer.
Written by
Harry
Updated over a week ago
Look up transactions that occurred on specific dates
Find transactions that occurred in the last X days, between two dates, or before or after a specific date.
Written by
Harry
Updated over a week ago
Look up yesterday's results
How to create a rolling filter that always returns results from yesterday (e.g. total sales yesterday)
Written by
Harry
Updated over a week ago