Filter
| Rad 8: | Rad 8: | ||
Alla kommande uthyrningar utan restaurang<br> | Alla kommande 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 '%`%' OR ADATES.TICKET_SYSTEM IS NULL))<br><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 '%`%' OR ADATES.TICKET_SYSTEM IS NULL))<br><br> | ||
| + | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_=CONVERT(DATETIME,'2011-10-02 00:00',120) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM LIKE '%`%') | ||
Versionen från 3 oktober 2011 kl. 03.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() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%)
Alla kommande uthyrningar med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() 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() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND (ADATES.TICKET_SYSTEM NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL))
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_=CONVERT(DATETIME,'2011-10-02 00:00',120) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.TICKET_SYSTEM LIKE '%`%')
