[resolved] Prompt Context Variable?

Highlighted
One Star

[resolved] Prompt Context Variable?

Hi,
I am wondering how can we supply the value to the context variable during runtime?
I created a context.process_date and imported into the job. In the query, I entered:
"SELECT * FROM rating WHERE added_date = "+context.process_date+"and added_date < '1971-01-01"
When I executed the job, it didn't prompt me to supply the value to context.process_date. Is there way I can supply the value during runtime?
Any help is really appreciated!
Thanks in advance!!!

Accepted Solutions
Community Manager

Re: [resolved] Prompt Context Variable?

Hello
Check the 'promt' box of context var.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] Prompt Context Variable?

Hello
Check the 'promt' box of context var.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: [resolved] Prompt Context Variable?

Hi @shong,

How to we get prompt, after we deployed the talend build in linux server?

Is there any way, please help me.

 

Regards,

Abhi529

Four Stars

Re: [resolved] Prompt Context Variable?

It's not possible. Provide the parameters via --context_param.

See here: https://community.talend.com/t5/Design-and-Development/Problem-with-context-prompt-params/td-p/61319

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.