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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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