This is an automated email from the ASF dual-hosted git repository.
pvillard pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/nifi.git
The following commit(s) were added to refs/heads/main by this push:
new d7b14c0c45 NIFI-11033: Update QueryNiFiReportingTask additionalDetails
page to include Flow Config History table
d7b14c0c45 is described below
commit d7b14c0c4555435d4f25a715ec04d45f8c76177c
Author: Matthew Burgess <[email protected]>
AuthorDate: Wed Jan 18 12:30:07 2023 -0500
NIFI-11033: Update QueryNiFiReportingTask additionalDetails page to include
Flow Config History table
Signed-off-by: Pierre Villard <[email protected]>
This closes #6856.
---
.../additionalDetails.html | 31 ++++++++++++++++++++++
1 file changed, 31 insertions(+)
diff --git
a/nifi-nar-bundles/nifi-sql-reporting-bundle/nifi-sql-reporting-tasks/src/main/resources/docs/org.apache.nifi.reporting.sql.QueryNiFiReportingTask/additionalDetails.html
b/nifi-nar-bundles/nifi-sql-reporting-bundle/nifi-sql-reporting-tasks/src/main/resources/docs/org.apache.nifi.reporting.sql.QueryNiFiReportingTask/additionalDetails.html
index 346834c317..079c328eee 100644
---
a/nifi-nar-bundles/nifi-sql-reporting-bundle/nifi-sql-reporting-tasks/src/main/resources/docs/org.apache.nifi.reporting.sql.QueryNiFiReportingTask/additionalDetails.html
+++
b/nifi-nar-bundles/nifi-sql-reporting-bundle/nifi-sql-reporting-tasks/src/main/resources/docs/org.apache.nifi.reporting.sql.QueryNiFiReportingTask/additionalDetails.html
@@ -210,6 +210,33 @@
<tr><td>remoteIdentifier</td><td>String</td></tr>
<tr><td>alternateIdentifier</td><td>String</td></tr>
</table>
+<br/>
+<h3>FLOW_CONFIG_HISTORY</h3>
+<table title="FLOW_CONFIG_HISTORY" border="1" width="500">
+ <tr><th>Column</th><th>Data Type</th></tr>
+ <tr><td>actionId</td><td>int</td></tr>
+ <tr><td>actionTimestamp</td><td>long</td></tr>
+ <tr><td>actionUserIdentity</td><td>String</td></tr>
+ <tr><td>actionSourceId</td><td>String</td></tr>
+ <tr><td>actionSourceName</td><td>String</td></tr>
+ <tr><td>actionSourceType</td><td>String</td></tr>
+ <tr><td>actionOperation</td><td>String</td></tr>
+ <tr><td>configureDetailsName</td><td>String</td></tr>
+ <tr><td>configureDetailsPreviousValue</td><td>String</td></tr>
+ <tr><td>configureDetailsValue</td><td>String</td></tr>
+ <tr><td>connectionSourceId</td><td>String</td></tr>
+ <tr><td>connectionSourceName</td><td>String</td></tr>
+ <tr><td>connectionSourceType</td><td>String</td></tr>
+ <tr><td>connectionDestinationId</td><td>String</td></tr>
+ <tr><td>connectionDestinationName</td><td>String</td></tr>
+ <tr><td>connectionDestinationType</td><td>String</td></tr>
+ <tr><td>connectionRelationship</td><td>String</td></tr>
+ <tr><td>moveGroup</td><td>String</td></tr>
+ <tr><td>moveGroupId</td><td>String</td></tr>
+ <tr><td>movePreviousGroup</td><td>String</td></tr>
+ <tr><td>movePreviousGroupId</td><td>String</td></tr>
+ <tr><td>purgeEndDate</td><td>long</td></tr>
+</table>
<br/><br/>
<h2>SQL Query Examples</h2>
<p>
@@ -234,6 +261,10 @@
<b>Example:</b> Select all fields from the <code>PROVENANCE</code> table
with time window:<br/>
<pre>SELECT * from PROVENANCE where timestampMillis > $provenanceStartTime and
timestampMillis <= $provenanceEndTime</pre>
</p>
+<p>
+ <b>Example:</b> Select connection-related fields from the
<code>FLOW_CONFIG_HISTORY</code> table:<br/>
+<pre>SELECT connectionSourceName, connectionDestinationName,
connectionRelationship from FLOW_CONFIG_HISTORY</pre>
+</p>
<br/>
</body>
</html>
\ No newline at end of file
