topic Re: How to pass variables to tsalesforce input ? in Talend Studio

How to pass variables to tsalesforce input ?

Anonymous — Sat, 16 Nov 2024 07:04:44 GMT

Hi,

I have a requirement to parameterize the value of createdDate field of my tsalesforce input manual query.

The createdDate should be as below for different iteration:

1 iteration: createdDate >= systemdate and createdDate < (systemdate-2== ie 10th dec 2018-2 days = 8th dec 2018)

2 iteration : 8th dec 2018 -2 = 6th dec 2018 ie createdDate >= 8th dec 2018 and createdDate <6th dec 2018

Any suggestions to achieve this will be a great help.

Thanks in advance.

TRF — Tue, 11 Dec 2018 07:18:33 GMT

Use literals such as LAST_N_DAYS:n and TODAY

TRF — Sun, 16 Dec 2018 09:20:54 GMT

Did this help?
If so, thank's to mark your case as solved (Kudo also accepted as a bonus)