Filter
(64 mellanliggande versioner av en användare visas inte) | |||
Rad 2: | Rad 2: | ||
GETDATE() returnerar dagens datum.<br><br> | GETDATE() returnerar dagens datum.<br><br> | ||
'''Fönster "Händelser"'''<br><br> | '''Fönster "Händelser"'''<br><br> | ||
− | + | '''11 Uthyrningar:''' <br> | |
− | (ADATES.PLANNINGLEVEL= | + | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%') </nowiki> <br> |
− | + | '''12 Uthyrningar med restaurang'''<br> | |
− | (ADATES.PLANNINGLEVEL= | + | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM>’’') </nowiki> <br> |
− | + | '''13 Uthyrningar utan restaurang'''<br> | |
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '% | + | <nowiki>(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))</nowiki><br><br> |
+ | '''21 Uthyrningar/konsert''' <br> | ||
+ | <nowiki>(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) </nowiki><br> | ||
+ | '''22 Uthyrningar/konsert med restaurang''' <br> | ||
+ | <nowiki>(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) </nowiki> <br> | ||
+ | '''23 Uthyrningar/konsert utan restaurang''' <br> | ||
+ | <nowiki>(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) </nowiki><br><br> | ||
+ | '''31 Uthyrningar/konferens''' <br> | ||
+ | <nowiki>(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))</nowiki> <br> | ||
+ | '''32 Uthyrningar/konferens med restaurang''' <br> | ||
+ | <nowiki>(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))</nowiki><br> | ||
+ | '''33 Uthyrningar/konferens utan restaurang''' <br> | ||
+ | <nowiki>(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))</nowiki><br><br> | ||
+ | '''41 Händelser med restaurang'''<br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM > '')</nowiki><br> | ||
+ | '''42 Händelser utan restaurang'''<br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_> (GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL))</nowiki><br> | ||
+ | '''43 Händelser en vecka bakåt, tre framåt'''<br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_> (GETDATE()-9) AND ADATES.DATE_< (GETDATE()+23))</nowiki><br><br> | ||
+ | '''51 Händelser med garderob''' <br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'') </nowiki> <br> | ||
+ | '''52 Uthyrning med garderob''' <br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.PROGRAMTITLE>'') </nowiki> <br> | ||
+ | '''53 Uthyrning utan garderob''' <br> | ||
+ | <nowiki>(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)) </nowiki> <br><br> | ||
+ | '''61 Orkester = GSO med mat''' <br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM>'' AND ORCHESTRAS.NAME1 LIKE 'GSO%')</nowiki> <br> | ||
+ | '''62 Orkester = GSO utan mat''' <br> | ||
+ | <nowiki>(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%')</nowiki> <br> | ||
+ | '''63 Orkester = GSO 2011/12''' <br> | ||
+ | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SSEASONS.CODE LIKE '2011/12%' AND ORCHESTRAS.NAME1 LIKE 'GSO%')</nowiki> |
Nuvarande version från 8 november 2011 kl. 03.54
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%')