Skip to content

SQLQuery

export interface SQLQuery {

Constrains a log query by date range, sort order, and record count.

Pass to Logger.getLog, Logger.emailLog, or Logger.uploadLog to filter which log entries are included.

const Logger = BackgroundGeolocation.logger;

// Date range
const log = await Logger.getLog({
  start: Date.parse("2019-10-21 13:00"),
  end:   Date.parse("2019-10-22")
});

// First 100 records ascending
await Logger.emailLog("foo@bar.com", {
  order: SQLQueryOrder.Asc,
  limit: 100
});

// Upload a specific time window
await Logger.uploadLog("https://my.server.com/users/123/logs", {
  start: Date.parse("2019-10-20 09:00"),
  end:   Date.parse("2019-10-20 11:59")
});

Members

end

end?: number;

End of the query window (unix timestamp in milliseconds).

limit

limit?: number;

Maximum number of records to return.

offset

offset?: number;

Number of matching records to skip before returning results (for paging).

order

order?:SQLQueryOrder;

Sort order for results: SQLQueryOrder.Asc (oldest first) or SQLQueryOrder.Desc (newest first).

start

start?: number;

Start of the query window (unix timestamp in milliseconds).