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

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

Anonymous — Wed, 24 Apr 2013 09:13:11 GMT

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

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

Anonymous — Wed, 24 Apr 2013 09:19:31 GMT

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

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

Anonymous — Wed, 24 Apr 2013 09:27:04 GMT

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.

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

Anonymous — Wed, 24 Apr 2013 09:54:23 GMT

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

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

Anonymous — Wed, 24 Apr 2013 10:46:10 GMT

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

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

Anonymous — Thu, 25 Apr 2013 04:51:55 GMT

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

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

Anonymous — Tue, 09 Jul 2013 09:50:54 GMT

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

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

Anonymous — Tue, 09 Jul 2013 10:53:15 GMT

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

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

Anonymous — Thu, 19 Sep 2013 12:27:36 GMT

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

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

Anonymous — Thu, 20 Mar 2014 02:36:09 GMT

Hi,
Here is a related forum https://community.talend.com/t5/Design-and-Development/resolved-Unable-to-extract-emails-from-mail-boxes-other-than/td-p/78839.
Best regards
Sabrina