GitHub user hansva added a comment to the discussion: Use of variables or 
dynamic date on MongoDB Input

Our table input also does not support this pattern, they are created to do a 
"bulk fetch" with potentially some parameters. They are not made to do 
row-by-row lookups. We should create a MongoDB Lookup transform for this use 
case the same pattern we have for tables. I am guessing this is your use case?

If your goal is to fetch things for the last X days or something like that it 
should be possible with 
`"$date": new Date(new Date()-5).toISOString()` or something like that (I'm no 
mongo expert)

GitHub link: 
https://github.com/apache/hop/discussions/5666#discussioncomment-14306778

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to