paginate

paginate copied to clipboard

is it possible to limit max page size by server-side? like i don't want to let user query data such as `?size=100000000`

ArtifactyNight

@morkid 👍 🍻

pedrofurtado

Request for Change: query.Offset = p.Page * p.Size to query.Offset = (p.Page - 1) * p.Size

1

Hello dear friend, According to the GORM documentation, the offset should be configured as follows: https://gorm.io/docs/scopes.html#Pagination `offset := (page - 1) * pageSize` However, in your code, you have set...

thisismz

Markdown, add gorm config queryfields note

1

Set gorm.Config.QueryFields must be **false** Because it can be causes some errors on showing data, the selector will be like this ` SELECT "s"."id","s"."sort","s"."status","s"."created_at","s"."updated_at","s"."deleted_at","s"."creator_id","s"."modifier_id","s"."integration_partner_id","s"."payment_gateway_id","s"."merchant_id","s"."terminal_id","s"."channel_code","s"."currency_id","s"."transaction_url","s"."notification_url","s"."client_key","s"."server_key","s"."bank_id","s"."virtual_account_number","s"."convenience_store_code" FROM `

imampri100

1. Add preloading 2. Response can be array

imampri100

add multi-like filter (mlike)

1

- mlike filter allows to search using like in many fields - example http://localhost:3000/?filters=["name,summart,title","mlike","john"] ```sql SELECT * FROM user WHERE name LIKE '%john%' OR summary LIKE '%john%' OR title LIKE...

gipsh