Scopes with v5

[yarapolana]

Has anyone tried to do scopes with v5?

I was trying this code that gives nearby profiles but was unsuccessful.

static scopeNearBy(query, latitude, longitude, distance) {
    const haversine = `(6371 * acos(cos(radians(${latitude}))
      * cos(radians(latitude))
      * cos(radians(longitude)
      - radians(${longitude}))
      + sin(radians(${latitude}))
      * sin(radians(latitude))))`

    return query
      .select('*', Database.raw(`round(${haversine}) as distance`))
      .whereRaw(`${haversine} < ${distance}`)
  }

[thetutlage]

I recommend reading the docs https://preview.adonisjs.com/guides/models/query-scopes. v5 is not identical to v4

[yarapolana]

Ah I missed that one. Thank you again.