Highlighted
karakan Absent Member.
Absent Member.
507 views

Collector's parameter in SqlQuery (JDBC connector)


Hello,

is it possible to inject value of any collector's parameter into query
defined in sqlquery.base?
If not , any suggestions when and how to create SqlQuery without using
sqlquery.base but form scratch (from String) just in release.js would be
appreciated.

Or if I put something like '###parameter_name###' into sqlquery.base
where then is the good place in release.js to replace this pattern with
the correct value?

Example: source behavior "from the beginning" not neccesarily must mean
the first record in terms of offset. It might mean the specific date
(e.g. last New Year). Esp. if database contains tones of records since
last 20 years and using 'event_date' as offset is not impossible for
some reasons.

So, "ROWNUM > %s and AND event_date > {this.CONFIG.params.start_date}"
(or as above: event_date > ###param###) in "WHERE" clause would help
it.

Regards, Darek


--
karakan
------------------------------------------------------------------------
karakan's Profile: https://forums.netiq.com/member.php?userid=10087
View this thread: https://forums.netiq.com/showthread.php?t=55137

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.