Issue with Query Condition of Implicit Context Load

Talend Version 6.3.1

Summary

Query Condition field displays red when a value is entered.
Additional Versions 6.2.1
Product Data Integration
Component Studio
Problem Description

When configuring Implicit Context Load from the database, the Query Condition field displays red when a value is entered.

Setting a value, such as "WHERE OPT = 'opt2'", produces the error:

Value is invalid.
Problem root cause

Two issues:

  • Red banner: this is a known minor defect
  • Query Condition: includes “WHERE"
Solution or Workaround

Red banner: This was fixed in version 6.4.1.

Query Condition: Do not include "WHERE". Studio automatically includes it when building the final query. Your query condition should be set to something like "OPT = 'opt2'".

JIRA ticket number TUP-17428
Version history
Revision #:
3 of 3
Last update:
‎06-11-2018 02:17 PM
Updated by:
 
Contributors