Filter

Från opas
Hoppa till: navigering, sök

Det går att använda variabler i filter.
GETDATE() returnerar dagens datum.

Fönster "Händelser"

11 Uthyrningar:
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%')
12 Uthyrningar med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM>’’')
13 Uthyrningar utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (NOT ADATES.TICKET_SYSTEM>’’ OR ADATES.TICKET_SYSTEM IS NULL))

21 Uthyrningar/konsert
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.L_LOGIC_1= 1.000)
22 Uthyrningar/konsert med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM>’’ AND ADATES.L_LOGIC_1= 1.000)
23 Uthyrningar/konsert utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (NOT ADATES.TICKET_SYSTEM>’’ OR ADATES.TICKET_SYSTEM IS NULL) AND ADATES.L_LOGIC_1= 1.000)

31 Uthyrningar/konferens
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))
32 Uthyrningar/konferens med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM>’’ AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))
33 Uthyrningar/konferens utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (NOT ADATES.TICKET_SYSTEM>’’ OR ADATES.TICKET_SYSTEM IS NULL) AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))

41 Händelser med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM > '')
42 Händelser utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_> (GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL))
43 Händelser en vecka bakåt, tre framåt
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_> (GETDATE()-9) AND ADATES.DATE_< (GETDATE()+23))

51 Händelser med garderob
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'')
52 Uthyrning med garderob
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.PROGRAMTITLE>'')
53 Uthyrning utan garderob
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (NOT ADATES.PROGRAMTITLE>'' OR ADATES.PROGRAMTITLE IS NULL))

61 Orkester = GSO med mat
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM>'' AND ORCHESTRAS.NAME1 LIKE 'GSO%')
62 Orkester = GSO utan mat
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL) AND ORCHESTRAS.NAME1 LIKE 'GSO%')
63 Orkester = GSO 2011/12
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SSEASONS.CODE LIKE '2011/12%' AND ORCHESTRAS.NAME1 LIKE 'GSO%')

Personliga verktyg
Namnrymder
Varianter
Åtgärder
Navigering
Verktygslåda