Previous Topic: SP ImplementationNext Topic: Database Views


SP Naming Conventions

The SP name must include a suffix defining the SP version. This must be in the format _Vx_y, for example MyEmailSearch_V2_1.

where:

x

Is the major version number. The major version is updated when a significant change is made to the function or procedure that requires an updated search definition. Existing customized searches will not use this new version.

y

Is the minor version. The minor version is updated when the procedure or functions is changed but the interface with the search definition stays the same. That is, the parameter and results definitions remain the same. This ensures that there is change control, but users' customized searches continue to function.