Time-based Stored Queries - Revision history

Gityerfix: Reverted edits by Agegeleruvy (Talk); changed back to last version by Kowy

2010-11-30T05:23:16Z

Reverted edits by Agegeleruvy (Talk); changed back to last version by Kowy

Agegeleruvy at 03:24, 24 November 2010

2010-11-24T03:24:15Z

Kowy: /* Timespans */

2008-08-01T14:08:31Z

‎Timespans

Kowy: /* Details */

2008-08-01T14:07:52Z

‎Details

Kowy: /* See Also */

2008-08-01T14:06:12Z

‎See Also

Kowy: /* Timespans */

2008-08-01T14:05:22Z

‎Timespans

Gityerfix at 19:04, 26 July 2008

2008-07-26T19:04:48Z

Gityerfix at 05:29, 26 July 2008

2008-07-26T05:29:03Z

Gityerfix at 22:02, 25 July 2008

2008-07-25T22:02:33Z

Gityerfix: /* See Also */

2008-07-18T14:09:10Z

‎See Also

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Customizations]]
@@ Line 16: / Line 8: @@
 You can use an exact date in the Time-Based Stored Queries or counted time using one of these 2 functions:
-&lt;source lang=&quot;javascript&quot;&gt;StartAtTime (timespan-name)&lt;/source&gt;
+<source lang="javascript">StartAtTime (timespan-name)</source>
 returns begin of the timespan's period.
-&lt;source lang=&quot;javascript&quot;&gt;EndAtTime (timespan-name)&lt;/source&gt;
+<source lang="javascript">EndAtTime (timespan-name)</source>
 returns end of the timespan's period.
@@ Line 24: / Line 16: @@
 == Timespans ==
-Timespans are simple string values (so must be enclosed in simple quotes leaded by backslash). They are defined in a special enumeration table, which can be out-of-the-box found in Administration tab -&gt; Service Desk -&gt; Application Data -&gt; Codes -&gt; Timespans.
+Timespans are simple string values (so must be enclosed in simple quotes leaded by backslash). They are defined in a special enumeration table, which can be out-of-the-box found in Administration tab -> Service Desk -> Application Data -> Codes -> Timespans.
 Each timespan has 3 milestones which are connected to current time:
@@ Line 36: / Line 28: @@
 Here are list of predefined timespan names, but you can create new ones if you need.
 Examples assume actual date and time is 26.6.2008 11:07.
-{| style=&quot;width:100%;min-width:800px;vertical-align:top;&quot;
+{| style="width:100%;min-width:800px;vertical-align:top;"
 ! | Name || StartAtTime || EndAtTime
-! style=&quot;width:450px&quot; | Comment
+! style="width:450px" | Comment
 |-
 | AFTER_NOON || 26.6.2008 12:00 || 27.6.2008 00:00 ||

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Customizations]]
@@ Line 8: / Line 16: @@
 You can use an exact date in the Time-Based Stored Queries or counted time using one of these 2 functions:
-<source lang="javascript">StartAtTime (timespan-name)</source>
+&lt;source lang=&quot;javascript&quot;&gt;StartAtTime (timespan-name)&lt;/source&gt;
 returns begin of the timespan's period.
-<source lang="javascript">EndAtTime (timespan-name)</source>
+&lt;source lang=&quot;javascript&quot;&gt;EndAtTime (timespan-name)&lt;/source&gt;
 returns end of the timespan's period.
@@ Line 16: / Line 24: @@
 == Timespans ==
-Timespans are simple string values (so must be enclosed in simple quotes leaded by backslash). They are defined in a special enumeration table, which can be out-of-the-box found in Administration tab -> Service Desk -> Application Data -> Codes -> Timespans.
+Timespans are simple string values (so must be enclosed in simple quotes leaded by backslash). They are defined in a special enumeration table, which can be out-of-the-box found in Administration tab -&gt; Service Desk -&gt; Application Data -&gt; Codes -&gt; Timespans.
 Each timespan has 3 milestones which are connected to current time:
@@ Line 28: / Line 36: @@
 Here are list of predefined timespan names, but you can create new ones if you need.
 Examples assume actual date and time is 26.6.2008 11:07.
-{| style="width:100%;min-width:800px;vertical-align:top;"
+{| style=&quot;width:100%;min-width:800px;vertical-align:top;&quot;
 ! | Name || StartAtTime || EndAtTime
-! style="width:450px" | Comment
+! style=&quot;width:450px&quot; | Comment
 |-
 | AFTER_NOON || 26.6.2008 12:00 || 27.6.2008 00:00 ||

@@ Line 24: / Line 24: @@
 You can define exact values (ie. 2008 for year, 4 for month, 3 for day and so on) into the time parts or relative differences against current value (ie. +1 or -5 and so on).
 === Out-of-the-box timespans ===
@@ Line 68: / Line 66: @@
 | YESTERDAY || 25.6.2008 00:00 || 26.6.2008 00:00 ||
 |}
 == See Also ==

@@ Line 12: / Line 12: @@
 <source lang="javascript">EndAtTime (timespan-name)</source>
 returns end of the timespan's period.
 == Timespans ==

← Older revision		Revision as of 14:06, 1 August 2008
Line 72:		Line 72:
	== See Also ==		== See Also ==
	[[Stored Queries]]		[[Stored Queries]]
		+
		+	Unicenter Service Desk Modification Guide page 70.

@@ Line 14: / Line 14: @@
 == Timespans ==
-Timespans are simple string values (so must be enclosed in simple quotes leaded by backslash).
+Timespans are simple string values (so must be enclosed in simple quotes leaded by backslash). They are defined in a special enumeration table, which can be out-of-the-box found in Administration tab -> Service Desk -> Application Data -> Codes -> Timespans.
-Here are possible timespan names ('''Let actual date and time be 26.6.2008 11:07:35'''):
+Each timespan has 3 milestones which are connected to current time:
 {| style="width:100%;min-width:800px;vertical-align:top;"
 ! | Name || StartAtTime || EndAtTime
-! style="width:350px" | Comment
+! style="width:450px" | Comment
 |-
-| AFTER_NOON ||  ||  ||
+| AFTER_NOON || 26.6.2008 12:00 || 27.6.2008 00:00 ||
 |-
-| BEFORE_NOON ||  ||  ||
+| BEFORE_NOON || 26.6.2008 00:00 || 26.6.2008 12:00 ||
 |-
-| LAST_HOUR ||  ||  ||
+| LAST_HOUR || 26.6.2008 10:07 || 26.6.2008 11:07 ||
 |-
-| LAST_MONTH ||  ||  ||
+| LAST_MONTH || 1.5.2008 00:00 || 1.6.2008 00:00 || full previous month
 |-
-| LAST_YEAR ||  ||  ||
+| LAST_YEAR || 1.1.2007 00:00 || 1.1.2008 00:00 || full previous year
 |-
-| PAST_HOUR || 26.6.2008 10:07:35 || 26.6.2008 11:07:35 || Current time -60 minutes
+| PAST_HOUR || 26.6.2008 10:07 || 26.6.2008 11:07 || Current time -1 hour
 |-
-| PAST_DAY || 25.6.2008 11:07:35 || 26.6.2008 11:07:35 || Current time -24 hours
+| PAST_DAY || 25.6.2008 11:07 || 26.6.2008 11:07 || Current time -1 day
 |-
-| PAST_WEEK || 19.6.2008 11:07:35 || 26.6.2008 11:07:35 || Current time -7 days
+| PAST_WEEK || 19.6.2008 11:07 || 26.6.2008 11:07 || Current time -7 days
 |-
-| PAST_MONTH || 26.5.2008 11:07:35 || 26.6.2008 11:07:35 || Current time -30 days
+| PAST_MONTH || 26.5.2008 11:07 || 26.6.2008 11:07 || Current time -30 days
 |-
-| PAST_YEAR || 26.6.2007 11:07:35 || 26.6.2008 11:07:35 || Current time -365 days
+| PAST_YEAR || 26.6.2007 11:07 || 26.6.2008 11:07 || Current time -1 year
 |-
-| THIS_MONTH_LAST_YEAR ||  ||  ||
+| THIS_HOUR || 26.6.2008 11:00 || 26.6.2008 11:07 ||
 |-
-| TODAY ||  ||  || Same as LAST_DAY
+| THIS_MONTH || 1.6.2008 00:00 || 26.6.2008 11:07 ||
 |-
-| TODO_TODAY ||  || 26.6.2008 24:00:00 ||
+| THIS_MONTH_LAST_YEAR || 1.6.2007 00:00 || 1.7.2007 00:00 ||
 |-
-| YESTERDAY ||  ||  ||
+| TODAY || 26.6.2008 00:00 || 26.6.2008 11:07 ||
 |}
 == See Also ==
 [[Stored Queries]]

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Customizations]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Details ==

← Older revision		Revision as of 14:09, 18 July 2008
Line 46:		Line 46:

	== See Also ==		== See Also ==
−	Stored Queries	+	[[Stored Queries]]