Versions Compared

Old Version 4

changes.mady.by.user Unknown User (mloosli)

Saved on

compared with

New Version 5

changes.mady.by.user Unknown User (mloosli)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This is the home of the QuickLine space.

To help you on your way, we've inserted some of our favourite macros on this home page. As you start creating pages, blogging and commenting you'll see the macros below fill up with all the activity in your space.

Recently Updated
typespage,comment,mail

Navigate space

Page Tree Search

Page Tree

 

Wiki Markup{cache:refresh=4h|checkAttachments=false} {chart:type=bar|stacked=false|width=350|attachmentVersion=replace|attachment=QL:Home^order.png} {sql:dataSource=QMC} SET DATEFIRST 1 SELECT cast(week as varchar(29)) + '/' + cast([year] as varchar(20)), SUM (CASE WHEN fldServiceReportName = 'Internet Dienst' THEN Anzahl ELSE 0 END) AS Internet, SUM (CASE WHEN fldServiceReportName = 'Festnetz Dienst' THEN Anzahl ELSE 0 END) AS Fixnet, SUM (CASE WHEN fldServiceReportName = 'MOBIL Dienst' THEN Anzahl ELSE 0 END) AS Mobil, SUM (CASE WHEN fldServiceReportName = 'DTV Dienst' THEN Anzahl ELSE 0 END) AS DTV, SUM (CASE WHEN fldServiceReportName = 'DTV Dienst Verte!' THEN Anzahl ELSE 0 END) AS Verte FROM [QMC].[dbo].[vw_Report_RequestService] GROUP BY [year],Week ORDER BY [Year], Week {sql} {chart} {cache}