Skip to main content

Function: verseRangeOverlapsRange()

verseRangeOverlapsRange(startCol, endCol, startVerseId, endVerseId): object

Defined in: Data/Core/VerseRangeQuery.ts:36

Match rows whose [start, end] range overlaps with a given [start, end] range. Catches all three overlap cases: start inside range, end inside range, or range fully enclosed.

SQL: ((startCol BETWEEN ? AND ?) OR (endCol BETWEEN ? AND ?) OR (startCol <= ? AND endCol >= ?)) Params: [startVerseId, endVerseId, startVerseId, endVerseId, startVerseId, endVerseId]

Parameters​

startCol​

string

endCol​

string

startVerseId​

number

endVerseId​

number

Returns​

object

params​

params: number[]

sql​

sql: string