Get data for Current date on a particualr time

[joe86]

Hi All,

I want to get the records generated (from MongoDB Collection) for current date while time is 10pm. I dont want files that was generated greater or less than 10pm for the current date. Can someone please help me?

[fdenis]

with tFileList you are boint to iterate throw files
link it with tFileProperties you will get mtime modified date

[joe86]

Sorry, i did not get you. Can you please explain it?

[joe86]

Sorry, it was my bad. They are not files, but records generated in MongoDB through Talend.

[fdenis]

on mongoBd it's better to get only the data(json document) you need not all datas.
so add a filter on your data query.
did you have any timestamp into your data model?

[joe86]

Yes we do. But the filter used in the query will not be accepted by the talend. So we are trying to filter the date through talend component.

[fdenis]

on tMap you can add filter to all output.
you can also add tFilterrow.
question is how your request is not accepted by talend?