How to find the version of the product I have installed

Whenever you apply a patch from Applaud, we record the version number on your database. We will often ask for this information if you raise a Service Request.

To find out your patch version, run the following SQL:

SELECT   max(patch_name)
        ,patch_description
FROM     xxas_com_applied_patches
GROUP BY patch_description
ORDER BY patch_description;

The version number is contained in the patch_name and will be unique for each product patch you apply.