l00ker

PostsComments

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

🤣

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

You can count on me! 🤣

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

Thanks again Zach!

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

Just wanted to make sure I was on the same page

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

Ahh

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

So you fixed the count for the modify_query? Or the original Ash query?

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

I think the error was about duplicate selects.

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

IIRC I got results fine but when I tried to add the pagination it tossed an error

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

I couldn't get pagination to work using manual but I could with modify_query

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

But the count being off was a no go there.

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

I see that you've been busy optimizing things but I the meantime that's why I decided to try the modify_query

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

I'm sure there are many things to be considered for sure. I figured there are reasons that DISTINCT was used. That's why I was wondering if there was a way to remove it I hadn't found.

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

And back to the query times for a moment. If used in a LiveView, those queries are run 2x. Once for the initial page load and again in the mount.

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

In that case, yes

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

If they are removed from the list query there are gaps

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

The list is in descending order by air date so as a viewer pages back in time the episodes will continue to be displayed in the proper order that they 'aired'

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

The other way out was to just do the query from the AirDates resource. That does duplicate and avoids the aggregate.

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

I want the duplicate rows

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

Yeah... it is

107 replies

AEAsh Elixir

•Created by l00ker on 2/17/2023 in #support

Pagination 'count' is not accurate if the SQL query result contains duplicate id's

The modify_query escape hatch was giving me exactly what I needed and I wanted to have Ash manage the pagination but the count was off.

107 replies