get_statistics_for_stream_by_date_range(p_stream_id integer, p_start_date timestamp without time zone, p_end_date timestamp without time zone, p_limit integer DEFAULT NULL::integer, p_offset integer DEFAULT 0)


Description

Retrieves statistic entries for a specific stream within a date range, including type name and description, ordered by timepoint descending. Supports pagination with limit and offset parameters.

Parameters

Name Type Mode
p_stream_id integer IN
p_start_date timestamp without time zone IN
p_end_date timestamp without time zone IN
p_limit integer IN
p_offset integer IN
statistic_in_time_id integer TABLE
stream_id integer TABLE
stream_statistic_type_id integer TABLE
statistic_type_name text TABLE
statistic_type_description text TABLE
value integer TABLE
timepoint timestamp without time zone TABLE

Definition