Find all articles ordered +-300s from the first article_id bigger or equal certain value

I have a big databases of orders(1 order may have many articles bought), Order table contains the following ellements: -Article_id -Order_Id -Time(Timestamp datatype)

I have to find all articles ordered within a specifc period -+300s from the first Article_id bigger than or equal a givven value.

More clearly:

Suppose we have only 1 order that containes 255 articles with article ID is between 0 and 254. each article is bought at a specific time t,
Suppose the value we are looking for is 66.5
-1st we have to get the first value greater than 66.5 (here it is 67)
-2nd we take the timestamp of the found value (67) t, and we filter by it so we get all articles bought within -/+ 300s within this timestamp t

***I use : Sparklyr (Spark with R)

Im new to this, Thanks
This what I tried:

order_tbl %>%
   group_by(order_id) %>%
   arrange(time) %>%
   filter(first(Article_id)>=66.5) %>%
   filter(between(time, TIME_FOUND_VALUE - 300,  TIME_FOUND_VALUE + 300))

Data look like this:

2567, 1112, 2019-01-16 20:40:00.0
2670, 1117, 2019-01-16 21:40:00.0
2569, 1112, 2019-01-16 20:45:00.0

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.