Filter

Från opas
(Skillnad mellan versioner)
Hoppa till: navigering, sök
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>
−
<nowiki>(ADATES.PLANNINGLEVEL=     1.000 AND ADATES.DATE_>(GETDATE()-1) AND SPROJECTS.NAME LIKE 'UTHYRN'+CHAR(73)+CHAR(78)+'G%')</nowiki> <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 med restaurang'''<br>
+
'''12Alla kommande uthyrningar med 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 LIKE '%`%')</nowiki> <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>
+
'''13 Uthyrningar utan 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 NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL))</nowiki><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>
+
'''21 Uthyrningar/konsert''' <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>
 
<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>
+
'''22 Uthyrningar/konsert med 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 LIKE '%`%' AND ADATES.L_LOGIC_1=    1.000)</nowiki> <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>
+
'''23 Uthyrningar/konsert utan 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 NOT LIKE '%`%' OR ADATES.TICKET_SYSTEM IS NULL) AND ADATES.L_LOGIC_1=    1.000) </nowiki><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>
+
'''31 Uthyrningar/konferens''' <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>
 
<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>
+
'''32 Uthyrningar/konferens med 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 LIKE '%`%' AND (ADATES.L_LOGIC_1=    0.000 OR ADATES.L_LOGIC_1 IS NULL))</nowiki><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>
+
'''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 (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>
 
<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>
+
'''41 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>
−
'''Alla kommande händelser utan restaurang'''<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><br>
 
<nowiki>(ADATES.PLANNINGLEVEL=    1.000 AND ADATES.DATE_> (GETDATE()-1) AND (NOT ADATES.TICKET_SYSTEM>'' OR ADATES.TICKET_SYSTEM IS NULL))</nowiki><br><br>
−
'''Alla kommande händelser med garderob''' <br>
+
'''51 Händelser med garderob''' <br>
 
<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>
+
'''52 Uthyrningar 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>
 
<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>
−
'''Alla kommande uthyrningar utan garderob''' <br>
+
'''53 Uthyrningar 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>
 
<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>

Versionen från 30 oktober 2011 kl. 18.24

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%' AND ADATES.TICKET_SYSTEM>’’')
12Alla 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 '%`%')
13 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))

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 LIKE '%`%' 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 (ADATES.TICKET_SYSTEM NOT LIKE '%`%' 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 LIKE '%`%' 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 (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))

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))

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

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