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.
![Limagito File Mover SQL as Source](https://limagito.com/wp-content/uploads/XFM.SQL_.RecordCount.01.png)
![Limagito File Mover Rule Events](https://limagito.com/wp-content/uploads/XFM.SQL_.RecordCount.02.png)
4. In the email setup we used our new %QSC parameter so the RecordCount will be displayed.
4. Received Email:
#SQL #Filetransfer
If you need any info about this ‘RecordCount as variable’ option, please let us know.
Best regards,
Limagito Team