Filter
| Rad 11: | Rad 11: | ||
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND ADATES.TICKET_SYSTEM>'')<br> | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND ADATES.TICKET_SYSTEM>'')<br> | ||
'''Alla kommande uthyrningar/konsert''' <br> | '''Alla kommande uthyrningar/konsert''' <br> | ||
| − | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES. | + | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.L_LOGIC_1= 1.000) <br> |
| − | + | '''Alla kommande uthyrningar/konferens''' <br> | |
| − | ( | + | (ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.L_LOGIC_1= 1.000) <br> |
Versionen från 3 oktober 2011 kl. 04.10
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))
Alla kommande händelser med restaurang
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND ADATES.TICKET_SYSTEM>)
Alla kommande uthyrningar/konsert
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.L_LOGIC_1= 1.000)
Alla kommande uthyrningar/konferens
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.L_LOGIC_1= 1.000)
