InfluxDB composite query

Question

Why this function don't bring the results? In influxdb.

select * from items.movement
  where time > now() - 7d
    and oldContainerId='aaaaaa'
    and newContainerId='aaaaaaa'

Thanks.

Answer 1

I solved with this:

select * from series
  where time > now() - 7d
    and newContainerId = 'aaaa'
  limit 100;
select * from series
  where time > now() - 7d
    and oldContainerId = 'aaaa'
  limit 100