Group 65Go 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

Harry avatar
8 articles in this collection
Written by Harry

Identify and explore your Users table

Harry avatar
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.
Harry avatar
Written by Harry
Updated over a week ago

Look up a specific customer or user

How to find a specific customer in your database
Harry avatar
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
Harry avatar
Written by Harry
Updated over a week ago

Look up cancelled sales / orders

Identify orders / transactions / sales / bookings etc that have been cancelled
Harry avatar
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.
Harry avatar
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.
Harry avatar
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)
Harry avatar
Written by Harry
Updated over a week ago