Extracting data

Last updated:

    Overview

    This section shows you how to extract data from the information held about a job in the application.

    Extracting data

    In this example, a telephone number is extracted from General > Addresses > Numbers.  Form HR1 requires the telephone number of the company to be provided:

    File:test/insolvency/230_21+PDF+templates/090_Additional+Steps/010_Extracting+data/PDF_ExtractData.png

    The following listing shows an example script to extract this information:

    INSERT  INTO @Data
    SELECT  'Employers telephone number', n.Number
    FROM    Admin_Number an 
            INNER JOIN Number n ON an.NumberID = n.NumberID 
            INNER JOIN NumberType nt ON n.NumberTypeID = nt.NumberTypeID
    WHERE   (nt.NumberTypeID = 1) AND (an.AdminID = @AdminID)