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