Filter

Från opas
(Skillnad mellan versioner)
Hoppa till: navigering, sök
Rad 9: Rad 9:
 
(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>
 
(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>
 
'''Alla kommande händelser med restaurang'''<br>
 
'''Alla kommande händelser med restaurang'''<br>
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND ADATES.TICKET_SYSTEM>'')<br>
+
<nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND ADATES.TICKET_SYSTEM > '')</<nowiki><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.L_LOGIC_1=    1.000) <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. 17.05

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 > '')</<nowiki><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.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= 0.000 OR ADATES.L_LOGIC_1 IS NULL)) <br> '''Restaurang''' <br> '''Uthyrning Ej Restaurang''' <br> '''Uthyrning Restaurang''' <br>

Personliga verktyg
Namnrymder
Varianter
Åtgärder
Navigering
Verktygslåda