Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sql query in tJavaRow

hello ,
how to query metadata stored in talend to his request of a component TjavaRow.
thank you in advance .
Labels (3)
5 Replies
Anonymous
Not applicable
Author

Hi
Sorry, I don't fully understand what you want to do? Do you want to execute a query which have been defined in Metadata?
Shong
Anonymous
Not applicable
Author

Hi ,
Yes, I want to execute a query that was defined in the metadata but inside tJavaRow.
Anonymous
Not applicable
Author

tJavaRow is not a general DB component, you are unable to use a repository query on tJavaRow, you have to input manually the query. For better management of your query, you can define a context variable for the query and use the context variable on tJavaRow, if the query changes, you just need to modify the context variable.
Shong
Anonymous
Not applicable
Author

Why using tJavaRow to execute a query? You can use your query stored in the metadata in a much better way in any t<DB>Input component by using a repository based query instead of build-in query.
Anonymous
Not applicable
Author

Hi ,
thank you shong and jlolling for responding and for the interest you have shown in my problem. and for your suggestion I will try to implement it.