Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to pass variable while filtering Mongodb INPUT

  1. #1
    Join Date
    Oct 2014
    Posts
    8

    Default How to pass variable while filtering Mongodb INPUT

    { created_at : { $gte : { $date : "2014-12-31T00:00:00.000Z" } } }

    Instead of "2014-12-31T00:00:00.000Z" -> today's date in same format "2014-12-31T00:00:00.000Z"

    How can I replace the value with todays date via variable

    SOMETHING LIKE BELOW
    { created_at : { $gte : { $date : "$TODAY-DATE" } } }

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You'll need a transformation to pick up the current date (Get System Info) and make it a variable (Set Variables).
    MongoDB Input can then refer to the variable like ${TODAY-DATE}
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.