Filter
Rad 11: | Rad 11: | ||
<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> | <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> | '''22 Uthyrningar/konsert med restaurang''' <br> | ||
− | <nowiki>(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>’’ AND ADATES.L_LOGIC_1= 1.000) </nowiki> <br> |
'''23 Uthyrningar/konsert utan restaurang''' <br> | '''23 Uthyrningar/konsert utan restaurang''' <br> | ||
− | <nowiki>(ADATES.PLANNINGLEVEL= | + | <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> | '''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> | <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> | '''32 Uthyrningar/konferens med restaurang''' <br> | ||
− | <nowiki>(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>’’ AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))</nowiki><br> |
'''33 Uthyrningar/konferens utan restaurang''' <br> | '''33 Uthyrningar/konferens utan restaurang''' <br> | ||
− | <nowiki>(ADATES.PLANNINGLEVEL= | + | <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> | '''41 Händelser med restaurang'''<br> | ||
<nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM > '')</nowiki><br> | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM > '')</nowiki><br> |
Versionen från 30 oktober 2011 kl. 22.56
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 Alla kommande 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))
51 Händelser med garderob
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'')
52 Uthyrningar 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 Uthyrningar 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))