i am working with temporal controller for just a cluple of days - before i've been using time manager. right now i am searching for a way to display the last/latest/most recent feature within a time interval which is defined by the "Frame" settings of the "Temporal Controller" GUI.
finally it should look like img_01 (see below): the yellow trace is implemented already and works fine. but the red dot is the thing i am asking for ...
within my time frame of 15min the temporal manager returns a set of 3 (sometimes 4) points. and i would like to implement kind of a selection algorithm that returns just this one point, which is the last one within the frame i.e. the one with the MIN value of an expression that could look like
@map_end_time - "points_time"
i have been trying differnet things but
- i could not find out how to get a collection/set of geometries within an QGIS expression by using "geometry generator"
- and even if i could find out how to get that collection i would not be able to select the one last point with the max-value of the time-field
- i've tried to use the temporal controller variables @map_start_time and @map_end_time in QGIS Query Builder to select features on the layer level - but i could not find a way to get along with the syntax for handling date and time SELECTs on geopackage-data within the Query Builder-environment
e.g. how a select of
to_datetime(@map_start_time + '2 Hour')could be translated into QGIS Query Builder syntax ? (the expamle works fine in QGIS expressions -> see labels/last line out of 4 in img_02)