Paginated query executing twice

export default function NewProductPage() {
  const result = usePaginatedQuery(
    api.admin.listOwnPendingProducts,
    {},
    { initialNumItems: 10 }
  );      

  useEffect(() => {
    console.log('Query state changed:', {
      status: result.status,
      productsLength: result.results?.length,
      isLoading: result.isLoading,
      results: result.results
    });
  }, [result]);

  return null;
}

export default function NewProductPage() {
  const result = usePaginatedQuery(
    api.admin.listOwnPendingProducts,
    {},
    { initialNumItems: 10 }
  );      

  useEffect(() => {
    console.log('Query state changed:', {
      status: result.status,
      productsLength: result.results?.length,
      isLoading: result.isLoading,
      results: result.results
    });
  }, [result]);

  return null;
}

Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}

Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}

can someone explain probably please why paginated query is executing 2 times on first execution even it is exhausted?

Convex Community•14mo ago

Starlord

Paginated query executing twice

export default function NewProductPage() {
  const result = usePaginatedQuery(
    api.admin.listOwnPendingProducts,
    {},
    { initialNumItems: 10 }
  );      

  useEffect(() => {
    console.log('Query state changed:', {
      status: result.status,
      productsLength: result.results?.length,
      isLoading: result.isLoading,
      results: result.results
    });
  }, [result]);

  return null;
}

export default function NewProductPage() {
  const result = usePaginatedQuery(
    api.admin.listOwnPendingProducts,
    {},
    { initialNumItems: 10 }
  );      

  useEffect(() => {
    console.log('Query state changed:', {
      status: result.status,
      productsLength: result.results?.length,
      isLoading: result.isLoading,
      results: result.results
    });
  }, [result]);

  return null;
}

Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}

Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
Query state changed: {status: 'LoadingFirstPage', productsLength: 0, isLoading: true, results: Array(0)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}
eruda.js?v=374bd0d1:3361 [CONVEX Q(admin:listOwnPendingProducts)] [LOG] 'listOwnPendingProducts executed on backend'
Query state changed: {status: 'Exhausted', productsLength: 1, isLoading: false, results: Array(1)}

can someone explain probably please why paginated query is executing 2 times on first execution even it is exhausted?

Paginated query executing twice

Similar Threads

Paginated query executing twice

Similar Threads

Similar Threads

Similar Threads