LiQL limited size of query

No problems, always there to help :) 

Hi VarunGrazitti

Does that mean that if I want to get all records where I don't know how many records there are, there isn't any way for me to do this, and the best I can do is to guess a ceiling and then do something like this:

SELECT author.id FROM messages WHERE board.name = 'wireless' LIMIT 1000 OFFSET 0
SELECT author.id FROM messages WHERE board.name = 'wireless' LIMIT 1000 OFFSET 1000
SELECT author.id FROM messages WHERE board.name = 'wireless' LIMIT 1000 OFFSET 2000

VarunGrazitti

The code I've copied was just an example from the documentation. I'm actually trying get kudos by user. Kudos doesn't support count(*). So there's no way to get count.

I can't use kudos_received from the user, because the reason I'm doing this is because we know that kudos_received isn't giving us the correct value, and we're trying to find out why.

Hi Liam_M  Here is the way to get the kudos count.
Given

SELECT kudos_given.sum(weight) FROM users WHERE id = '31'

Received

SELECT kudos_received.sum(weight) FROM users WHERE id = '31'

I can't use kudos_received from the user, because the reason I'm doing this is because we know that kudos_received isn't giving us the correct value, and we're trying to find out why.