Is it possible to have a query refetch X ms only when successful?

[neilff]

I have a query configured like this:

export const useGetData = (
  id: string,
  options?: UseQueryOptions<{ data: Response | null }, Error>,
) => {
  return useQuery<{ data: Response | null }, Error>({
    queryKey: [QUERY_KEY, id],
    queryFn: async () => {
      const client = getStoreClient();

      return client.entities
        .get({ id })
        .go();
    },
    retry: false,
    refetchInterval: 5000,
    refetchOnWindowFocus: false,
    ...options,
  });
};

Expected behavior

If the query fails, stop refetching it.
If the query is successful, refetch it every 5 seconds.

Actual behavior

The query keeps refetching every 5 seconds regardless of whether it was successful or failed.

[TkDodo]

refetchInterval: (_data, query) => query.state.status === 'success' ? 5000 : false