How to apply dynamic filter condition in tPOP advanced setting>filter

One Star

How to apply dynamic filter condition in tPOP advanced setting>filter

Hi all,
I am very new on Talend, I am facing a problem on tPOP filter.
What I want is to make the tPOP filter as Dynamic filter condition.
Like using other table data in filter condition. Is it possible? and How can we do it?
and Talend version is Version: 5.2.2
Thanks !
Geet
Moderator

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi,
What kind of dynamic filter do you want to get using tPOP? Could you please elaborate your case with an example with input and expected output values?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi xdshi,
What i want is to change the filter condition without changing source code.
what even change in the refering table I want to reflect in the condition.
e.g
In tPOP:
Filter item pattern
subject column_name_subject
i want get pattern from table column which will have single row.
my table will be like:
col_from col_to column_name_subject col_dated
xyz abc "talend example" "23-apr-2013" .
get the pattern from the above table.
Thanks in advance.
Moderator

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi,
I think the workflow can be: tMysqlInput--main--tFlowToIterate--iterate--tPop
In the advanced settings of tPOP, if you want to filter the mail on subject item, set the pattern as row1.pattern,
//pattern is a column name of tMysqlInput.
Best regards
Sabirna
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

hi,
I am using Oracle table as control table like
tOracleInput_1--main--fFlowToIterate--iterate---tPop
In the advanced setting of tPop, i have made filter on subject and set the pattern as row1.column_name_subject,
column_name_subject is my column name which contain pattern of subject filter.
But its showing error : column_name_subject cannot be resolved or its not a field.
Is there a way to use a Query?
with regards
Geetchandra
Moderator

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi,
I don't get compile error with this job design, can you upload a screenshot of your job? There might be some wrong in your job.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi all,
I would like to import email using the tpop component
my question is :
what parameter used in tpop to filter unread emails
thanks!
Fares
Moderator

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi fboaudaxis,
For your requirement, it is only available when you choose "imap" protocol.
See the related bug https://jira.talendforge.org/browse/TDI-15537.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi Sabrina,
I've chosen imap as my access protocol for my gmail account, but I'm still can no t figure out how to get only unread messages. Can you please help me with that?
Kind regards, Konstantin
Moderator

Re: How to apply dynamic filter condition in tPOP advanced setting>filter

Hi,
Here is a related forum .
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.