Is it possible to get paginated data and filter it...

# supabase-kt

[mohamed rejeb]

Is it possible to get paginated data and filter it or sort it using a foreign key? I was trying it, it works without pagination but as soon as I add pagination it stops working.

[Jan]

Can you share your code?

[mohamed rejeb]

I have something similar to this, supabase.getAll is something custom that I have to make things easier.
This call works without pagination but with pagination I can't use filter or sort with the populated data.

// Dto
@Serializable
data class SampleDto(
    val id: String,
    @SerialName("other_id_data")
    val other: OtherDto? = null,
)

// Call
fun getColumns() =
    Columns.raw(COLUMNS_VALUE)
const val COLUMNS_VALUE = "*, other_id_data: other_id(*)"

supabase.getAll(
    page = page,
    limit = limit,
    columns = SampleDto.getColumns(),
) {
    filter {
        gte(
            "other_id_data.date",
            Clock.System.now().toLocalDateTime(TimeZone.UTC).date,
        )
    }
}

[Jan]

How does the getAll method look?

[mohamed rejeb]

Hmmm maybe having filter after range can fix this? Did you manage to reproduce it

suspend inline fun <reified T : Any> SupabaseDataSource<T>.getAll(
    page: Long,
    limit: Int = 10,
    columns: Columns = Columns.ALL,
    crossinline filter: @PostgrestFilterDSL PostgrestRequestBuilder.() -> Unit = {},
) = handleErrors {
    postgrestBuilder
        .select(
            columns = columns,
            request = {
                filter()

                val from = (page - 1) * limit
                val to = page * limit - 1

                range(
                    from = from,
                    to = to,
                )
            },
        )
        .decodeList<T>()
}

[Jan]

I just tried something similar with a filter including a foreign key and it works as expected. Do you get no data at all when using range?

[mohamed rejeb]

That's the error that I get:

'proposal' is not an embedded resource in this request (Verify that 'proposal' is included in the 'select' query parameter.)
URL: https://key.supabase.co/rest/v1/itinerary?owner_id=eq.52d9f0d3-9f2d-4dd2-a02c-394a326d2054&proposal.order=from_date.asc.nullslast&offset=0&limit=10&select=%2A%2Cproposal_id_data%3Aproposal_id%28%2A%2Ctravel_agent_data%3Atravel_agent%28%2A%29%29