Filter

Från opas
(Skillnad mellan versioner)
Hoppa till: navigering, sök
 
(43 mellanliggande versioner av en användare visas inte)
Rad 2: Rad 2:
 
GETDATE() returnerar dagens datum.<br><br>
 
GETDATE() returnerar dagens datum.<br><br>
 
'''Fönster "Händelser"'''<br><br>
 
'''Fönster "Händelser"'''<br><br>
−
'''Alla kommande uthyrningar:''' <br>
+
'''11 Uthyrningar:''' <br>
−
(ADATES.PLANNINGLEVEL=     1.000 AND ADATES.DATE_>=GETDATE() 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>
+
'''12 Uthyrningar med restaurang'''<br>
−
(ADATES.PLANNINGLEVEL=     1.000 AND ADATES.DATE_>=GETDATE() 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>’’') </nowiki> <br>
−
'''Alla kommande uthyrningar utan restaurang'''<br>
+
'''13 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>
+
<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))</nowiki><br><br>
−
'''Alla kommande händelser med restaurang'''<br>
+
'''21 Uthyrningar/konsert''' <br>
−
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>=GETDATE() AND ADATES.TICKET_SYSTEM>'')<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''' <br>
+
'''22 Uthyrningar/konsert med restaurang''' <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>
+
<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>
−
'''Alla kommande uthyrningar/konferens''' <br>
+
'''23 Uthyrningar/konsert utan restaurang''' <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>
+
<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>
−
'''Restaurang''' <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>
−
'''Uthyrning Ej Restaurang''' <br>
+
'''32 Uthyrningar/konferens med restaurang''' <br>
−
'''Uthyrning Restaurang''' <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>’’ AND (ADATES.L_LOGIC_1= 0.000 OR ADATES.L_LOGIC_1 IS NULL))</nowiki><br>
 +
'''33 Uthyrningar/konferens utan restaurang''' <br>
 +
<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>
 +
<nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM > '')</nowiki><br>
 +
'''42 Händelser utan restaurang'''<br>
 +
<nowiki>(ADATES.PLANNINGLEVEL=    1.000 AND ADATES.DATE_> (GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL))</nowiki><br>
 +
'''43 Händelser en vecka bakåt, tre framåt'''<br>
 +
<nowiki>(ADATES.PLANNINGLEVEL=    1.000 AND ADATES.DATE_> (GETDATE()-9) AND ADATES.DATE_< (GETDATE()+23))</nowiki><br><br>
 +
'''51 Händelser med garderob''' <br>
 +
<nowiki>(ADATES.PLANNINGLEVEL=    1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'') </nowiki> <br>
 +
'''52 Uthyrning med garderob''' <br>
 +
<nowiki>(ADATES.PLANNINGLEVEL=     1.000 AND ADATES.DATE_>(GETDATE()-1)  AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%' AND ADATES.PROGRAMTITLE>'') </nowiki> <br>
 +
'''53 Uthyrning utan garderob''' <br>
 +
<nowiki>(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)) </nowiki> <br><br>
 +
'''61 Orkester = GSO med mat''' <br>
 +
<nowiki>(ADATES.PLANNINGLEVEL=    1.000 AND ADATES.DATE_>(GETDATE()-1)  AND ADATES.TICKET_SYSTEM>'' AND ORCHESTRAS.NAME1 LIKE 'GSO%')</nowiki> <br>
 +
'''62 Orkester = GSO utan mat''' <br>
 +
<nowiki>(ADATES.PLANNINGLEVEL=    1.000 AND ADATES.DATE_>(GETDATE()-1)  AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL) AND ORCHESTRAS.NAME1 LIKE 'GSO%')</nowiki> <br>
 +
'''63 Orkester = GSO 2011/12''' <br>
 +
<nowiki>(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SSEASONS.CODE LIKE '2011/12%' AND  ORCHESTRAS.NAME1 LIKE 'GSO%')</nowiki>

Nuvarande version från 8 november 2011 kl. 03.54

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 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))
43 Händelser en vecka bakåt, tre framåt
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_> (GETDATE()-9) AND ADATES.DATE_< (GETDATE()+23))

51 Händelser med garderob
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.PROGRAMTITLE>'')
52 Uthyrning 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 Uthyrning 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))

61 Orkester = GSO med mat
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND ADATES.TICKET_SYSTEM>'' AND ORCHESTRAS.NAME1 LIKE 'GSO%')
62 Orkester = GSO utan mat
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL) AND ORCHESTRAS.NAME1 LIKE 'GSO%')
63 Orkester = GSO 2011/12
(ADATES.PLANNINGLEVEL= 1.000 AND ADATES.DATE_>(GETDATE()-1) AND SSEASONS.CODE LIKE '2011/12%' AND ORCHESTRAS.NAME1 LIKE 'GSO%')

Hämtad från "http://opas.se/index.php/Filter"
Personliga verktyg
Namnrymder
Varianter
Åtgärder
Navigering
Verktygslåda