Filter
Rad 3: | Rad 3: | ||
'''Fönster "Händelser"'''<br><br> | '''Fönster "Händelser"'''<br><br> | ||
'''Alla kommande uthyrningar:''' <br> | '''Alla kommande uthyrningar:''' <br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%') <br> | + | <nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%')</nowiki> <br> |
'''Alla kommande uthyrningar med restaurang'''<br> | '''Alla kommande uthyrningar med restaurang'''<br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM LIKE '%`%') <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 LIKE '%`%')</nowiki> <br> |
'''Alla kommande uthyrningar utan restaurang'''<br> | '''Alla kommande uthyrningar utan restaurang'''<br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL))<br><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 NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL))</nowiki><br><br> |
− | + | ||
'''Alla kommande uthyrningar/konsert''' <br> | '''Alla kommande uthyrningar/konsert''' <br> | ||
− | (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) <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> |
'''Alla kommande uthyrningar/konsert med restaurang''' <br> | '''Alla kommande uthyrningar/konsert med restaurang''' <br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM LIKE '%`%' AND ADATES.L_LOGIC_1= 1.000) <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 LIKE '%`%' AND ADATES.L_LOGIC_1= 1.000)</nowiki> <br> |
'''Alla kommande uthyrningar/konsert utan restaurang''' <br> | '''Alla kommande uthyrningar/konsert utan restaurang''' <br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND ADATES.L_LOGIC_1= 1.000) <br><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 NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND ADATES.L_LOGIC_1= 1.000) </nowiki><br><br> |
− | + | ||
'''Alla kommande uthyrningar/konferens''' <br> | '''Alla kommande uthyrningar/konferens''' <br> | ||
− | (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)) <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> |
'''Alla kommande uthyrningar/konferens med restaurang''' <br> | '''Alla kommande uthyrningar/konferens med restaurang''' <br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM LIKE '%`%' AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))<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 LIKE '%`%' AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))</nowiki><br> |
'''Alla kommande uthyrningar/konferens utan restaurang''' <br> | '''Alla kommande uthyrningar/konferens utan restaurang''' <br> | ||
− | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))<br><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 NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))</nowiki><br><br> |
'''Alla kommande händelser med restaurang'''<br> | '''Alla kommande 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> | ||
Rad 29: | Rad 27: | ||
<nowiki>((ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'') </nowiki> <br> | <nowiki>((ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'') </nowiki> <br> | ||
'''Alla kommande uthyrningar med garderob''' <br> | '''Alla kommande uthyrningar med garderob''' <br> | ||
+ | <nowiki>((ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'') </nowiki> <br> | ||
+ | |||
'''Alla kommande uthyrningar utan garderob''' <br> | '''Alla kommande uthyrningar utan garderob''' <br> |
Versionen från 30 oktober 2011 kl. 18.08
Det går att använda variabler i filter.
GETDATE() returnerar dagens datum.
Fönster "Händelser"
Alla kommande uthyrningar:
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%')
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 LIKE '%`%')
Alla kommande uthyrningar utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL))
Alla kommande 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)
Alla kommande 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 LIKE '%`%' AND ADATES.L_LOGIC_1= 1.000)
Alla kommande uthyrningar/konsert utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND ADATES.L_LOGIC_1= 1.000)
Alla kommande 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))
Alla kommande 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 LIKE '%`%' AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))
Alla kommande uthyrningar/konferens utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))
Alla kommande händelser med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM > '')
Alla kommande händelser utan restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_> (GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL))
Alla kommande händelser med garderob
((ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'')
Alla kommande uthyrningar med garderob
((ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'')
Alla kommande uthyrningar utan garderob