topic Re: Get data for Current date on a particualr time in Talend Studio

Get data for Current date on a particualr time

joe86 — Thu, 20 Sep 2018 12:31:52 GMT

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?

Re: Get data for Current date on a particualr time

fdenis — Thu, 20 Sep 2018 12:41:47 GMT

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

Re: Get data for Current date on a particualr time

joe86 — Thu, 20 Sep 2018 13:31:35 GMT

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

Re: Get data for Current date on a particualr time

joe86 — Thu, 20 Sep 2018 13:33:55 GMT

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

Re: Get data for Current date on a particualr time

fdenis — Thu, 20 Sep 2018 13:37:08 GMT

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?

Re: Get data for Current date on a particualr time

joe86 — Thu, 20 Sep 2018 14:00:51 GMT

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.

Re: Get data for Current date on a particualr time

fdenis — Thu, 20 Sep 2018 14:14:51 GMT

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