Q: With the SQL Source is there a way to access the RecordCount as variable? Would be nice to include it in the subject line of an email Destination. Many thanks!
A: We added two new parameters in version v2022.3.18.0.
- %QDC = Query Destination record Count, when using SQL as Destination
- %QSC = Query Source record Count, when using SQL as Source
You can use %QDC and %QSC within your email or at other positions where parameters can be used. Some screenshots to get you started.
4. In the email setup we used our new %QSC parameter so the RecordCount will be displayed.
4. Received Email:
If you need any info about this ‘RecordCount as variable’ option, please let us know.