Content-Range when there is association, counts the inner object as well.

[zivchen]

Hi
I have 2 object, Test and Step.
Test has many Steps.
I have 4 Tests and 200 steps.
model definition:
endpoints.testResource = epilogue.resource({
model: models.Test,
endpoints: ['/admin/api/tests', '/admin/api/tests/:id'],
associations: true
});

when doing get-> /tests i get content range 0-4/ 204.
so my admin shows pagination when there are none.
if i remove the association its great.
thanks.

Ziv

[xtr0]

@zivchen
As a workaround you can try the following:

endpoints.testResource.list.fetch.before = function (req, res, context) {
    context.options = context.options || {};
    context.options.distinct = true;
    
    return context.continue;
}

At least it works for me

[zlatinejc]

Distinct could be set as default and mentioned in the docs.

[kvanbere]

This workaround isn't working for me, here's what I did:

	let accounts = epilogue.resource({
		model: models.Account,
		endpoints: ['/accounts', '/accounts/:id'],
		associations: true
	});
	accounts.list.fetch.before = function (req, res, context) {
		context.options = context.options || {};
		context.options.distinct = true;
		
		return context.continue;
	};

Request is i.e. accounts?offset=70&count=10

I'm getting a response Content-Range:items 70-79/153 but there are only 111 rows.

[edrpls]

@kvanberendonck it didn't work for me either, I think it's also a bug in sequelize, at least with mysql, I ended up doing two queries and merging the associations.

[kvanbere]

I made it work ! I'll share solution when I get off lunch

[kvanbere]

@edrpls

	let fixPagination = (endpoint) => {
		endpoint.use({ list: { fetch: { before: function(req, res, context) {
			context.options = context.options || {};
			context.options.distinct = true;
			return context.continue;
		}}}});
	};

//...

	let foo = epilogue.resource({
		model: models.Foo,
		endpoints: ['/foo', '/foo/:id'],
		associations: true
	});
	fixPagination(foo);

Using foo.list.fetch.before for example wasn't actually working as a hook. Need to use .use() for some reason.