:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { useActions, useValues } from 'kea'
import { useMemo } from 'react'
import { TZLabel } from 'lib/components/TZLabel'
import { LemonButton } from 'lib/lemon-ui/LemonButton'
import { humanFriendlyNumber } from 'lib/utils/numbers'
import { dataNodeLogic } from '~/queries/nodes/DataNode/dataNodeLogic'
import { isDataVisualizationNode, isHogQLQuery } from '~/queries/schema/node-guards'
import { DataNode } from '~/queries/schema/schema-general'
import { DEFAULT_PAGE_SIZE } from '../DataVisualization/Components/Table'
interface LoadNextProps {
query: DataNode
nouns?: [string, string]
expectedTotalRows?: number
}
export function LoadNext({ query, nouns = ['entry', 'entries'], expectedTotalRows }: LoadNextProps): JSX.Element {
const { canLoadNextData, nextDataLoading, numberOfRows, hasMoreData, dataLimit } = useValues(dataNodeLogic)
const { loadNextData } = useActions(dataNodeLogic)
const text = useMemo(() => {
// if hogql based viz, show a different text
if (isDataVisualizationNode(query) && isHogQLQuery(query.source)) {
// No data limit means the user is controlling the pagination
if (!dataLimit) {
if (numberOfRows && numberOfRows <= DEFAULT_PAGE_SIZE) {
return `Showing ${numberOfRows === 1 ? '' : 'all'} ${numberOfRows === 1 ? 'one' : numberOfRows} ${
numberOfRows === 1 ? 'entry' : 'entries'
}`
}
// If the number of rows is greater than the default page size, it's handled by pagination component
return ''
}
if (numberOfRows && numberOfRows < dataLimit) {
return `Showing ${numberOfRows === 1 ? '' : 'all'} ${numberOfRows === 1 ? 'one' : numberOfRows} ${
numberOfRows === 1 ? 'entry' : 'entries'
}`
}
return `Default limit of ${dataLimit} rows reached`
} else if (isHogQLQuery(query) && !canLoadNextData && hasMoreData && dataLimit) {
return `Default limit of ${dataLimit} rows reached. Try adding a LIMIT clause to adjust.`
}
if (!canLoadNextData && !hasMoreData && numberOfRows && expectedTotalRows && numberOfRows < expectedTotalRows) {
return `Showing ${humanFriendlyNumber(numberOfRows)} of ${humanFriendlyNumber(expectedTotalRows)} ${nouns[1]}`
}
const noun = numberOfRows === 1 ? nouns[0] : nouns[1]
let result = `Showing ${
hasMoreData && (numberOfRows ?? 0) > 1 ? 'first ' : canLoadNextData || numberOfRows === 1 ? '' : 'all '
}${numberOfRows === 1 ? 'one' : humanFriendlyNumber(numberOfRows)} ${noun}`
if (canLoadNextData) {
result += nextDataLoading ? ' – loading more…' : ' – click to load more'
} else if (hasMoreData) {
result += ' – reached the end of results'
}
return result
}, [query, dataLimit, numberOfRows, canLoadNextData, nextDataLoading, hasMoreData, nouns, expectedTotalRows])
// pagination component exists
if (
isDataVisualizationNode(query) &&
isHogQLQuery(query.source) &&
!dataLimit &&
(!numberOfRows || numberOfRows > DEFAULT_PAGE_SIZE)
) {
return <></>
}
return (
<div className="m-2 flex items-center">
<LemonButton onClick={loadNextData} loading={nextDataLoading} fullWidth center disabled={!canLoadNextData}>
{text}
</LemonButton>
</div>
)
}
export function LoadPreviewText({ localResponse }: { localResponse?: Record<string, any> | null }): JSX.Element {
const { response: dataNodeResponse, hasMoreData, responseLoading } = useValues(dataNodeLogic)
const response = dataNodeResponse ?? localResponse
if (responseLoading) {
return <div />
}
const resultCount = response && 'results' in response ? (response.results?.length ?? 0) : 0
const isSingleEntry = resultCount === 1
const showFirstPrefix = hasMoreData && resultCount > 1
const lastRefreshTimeUtc: string | null | undefined =
response && 'last_refresh' in response ? response['last_refresh'] : null
return (
<>
<span>
{showFirstPrefix ? 'Limited to the first ' : 'Showing '}
{isSingleEntry ? 'one row' : `${resultCount} rows`}
</span>
{lastRefreshTimeUtc && (
<>
<span className="ml-2 mr-2">|</span>
<TZLabel noStyles time={lastRefreshTimeUtc} />
</>
)}
</>
)
}