Creating Custom Izenda Views

Creating Custom Izenda Views


 

To add additional Izenda views that the standard printIQ Izenda view doesn’t cover, you will need to be a self-hosted site with access to your database server, and some skill in using SQL.

 

Note: Custom views aren’t covered by support, and may require maintenance as printIQ is updated.

/*                         Creating a Custom View                                                                                 */
/*                                Recommended naming convention is VW_[YourBusinessName]_[Subject]                                  */

/*                                1: Drop existing view if it exists                                                              */
IF OBJECT_ID('VW_CustomerName_UserNames') IS NOT NULL
BEGIN
   DROP VIEW VW_CustomerName_UserNames;
END;
GO

/*                                2: Create your view                                                                             */
CREATE VIEW VW_CustomerName_UserNames
AS
       SELECT  UserId [User ID],
                     UserName [User Name]
       FROM   aspnet_Users
GO

/*                                3: Insert a record into tblIzenda_Object                                                         */
/*                                   This is so Izenda can recognise your view                                                    */
IF NOT EXISTS(SELECT * FROM tblIzenda_Object WHERE IOName = N'VW_CustomerName_UserNames')
BEGIN
       INSERT INTO tblIzenda_Object(IOName, IOActive, IOCustom, IOPrimaryKey, IOIsRestricted)
       VALUES (N'VW_CustomerName_UserNames', 1, 1, 'User ID', 0)
END
GO

/*            (OPTIONAL)    4: Reset IIS                                                                                           */
/*                                              The Izenda cache can take a while to clear itself                                  */
/*                                              Your view won't show until this has happened                                      */
/*                                              The easiest way to do this is to reset Internet Information Services (IIS)        */

 

 


    • Related Articles

    • Reports - Designing a Report

      If your system is licensed for IQanalytics Report Writer, you may design your own reports. For a more comprehensive guide on how to design Izenda report, please scroll down to the end of the article to download the attachment. *All credit to the ...
    • Syllabus IQanalytics Report Writing (Izenda)

      Download the attached PDF file for full list of fields
    • Reports - Data Sources (Views / Tables)

      If your system is licensed for IQanalytics Report Writer, you may design your own reports. In order to design reports, please refer to Knowledge Base Article here. Designing reports requires an understanding of the available data sources and their ...
    • IQ Standard Reports

      A brief walkthrough and explanation of standard reports included with IQ... Customer \ Customer Activity in Selected Period This report provides a list of ALL of your active customers showing Job activity in the selected date range. The sorting logic ...
    • Reports - Designing a Dashboard

      Dashboards Once a number of reports and charts have been created, you can place different charts onto a single Dashboard for high level views of printIQ’s database. These dashboards have their unique sharing permissions and may be set as default for ...