You can use SQL to customise rules and recognitions. Enter custom SQL rules to cater for member selection that is outside the predefined rules criteria.
Important: Creating customised SQL queries is for advanced users as it requires knowledge of the database structure. The following section will outline some examples of custom SQL that can be used.
- Custom SQL for accumulate in a recognition will enable the Total Available field to be recalculated for qualifying members during the recalculation jobs. See Custom SQL for accumulate for details.
- Custom SQL for post routine in a recognition will run a script once the recognition has been used by the member. For example, updating a member's expiry date after purchasing a Renewal recognition. Contact Vista Support for other routines.
- Custom SQL validation in a recognition can be developed to validate a recognition that cannot be managed with the predefined recognition criteria.
Custom SQL for accumulate
Custom SQL can be entered when defining the type of recognition in Section 1 of the Add/Modify Recognition page. This SQL will define a customised way to accumulate balance type points for the recognition instead of using a fixed value.
The limit per visit value is still used.
CAST(Isnull(membershipRecognition_numberOfRedemptions,0) as Integer) + 1