Skip to main content

Alternative Solution for Querying Date Interval in Aras Innovator

Query data from date range is a common demand, but the Property may not show in main grid. Therefore, users must use "Advanced Search" in order to query these "hidden Property" (like Figure 1).

Figure 1

"Advanced Search" should satisfy most of demands. But it is not friendly for users due to the search option contains all Properties.
Here propose an alternative solution for easily querying date interval, please follow the steps as follow:
  1. Create "Begin Date" and "End Date" Property with "Date" data type.


  2. Create a server side Method with below code:
    
Const strQueryProp As String = "created_on"

Dim strBegin As String = Me.getProperty("_begin","")
Dim strEnd As String = Me.getProperty("_end","")

Me.removeProperty("_begin")
Me.removeProperty("_end")

If Not String.IsNullOrEmpty(strBegin) Then
    strBegin = RegularExpressions.Regex.Split(strBegin," and ")(0)
    
    Me.node.InnerXml &= "<" & strQueryProp & " condition=""ge"">" & strBegin & "</" & strQueryProp & ">"
End If

If Not String.IsNullOrEmpty(strEnd) Then
    strEnd = RegularExpressions.Regex.Split(strEnd," and ")(1)
    
    Me.node.InnerXml &= "<" & strQueryProp & " condition=""le"">" & strEnd & "</" & strQueryProp & ">"
End If

Return Me

  3. Add above Method to Server Events of ItemType with "OnBeforeGet" event.

Although there are two "useless" Properties (permanently no data), users can easily enter their query criteria in "Simple Search" (see Figure 2). It should be more friendly way for users to query data from date range.

Figure 2
標籤：

Comments

Post a Comment

Popular posts from this blog

Trigger Sequence of Promotion Events in Aras Innovator

There are several Server Event could trigger Method during item promotion: ItemType: OnBeforePromote, OnAfterPromote; Life Cycle: Transition Pre, Transition Post. Trigger sequence of above events is shown in below figure: It's important to note that "Transition Post" cannot rollback while exception throws because item promotion is finished after "OnAfterPromote" That means even if throwing exception, the life cycle will still stay at promoted state. Please note, all above events will not be triggered when "OnPromote" event exists (due to this will overwrite original system process).
Post a Comment
Read more

Account and Password Policy in Aras Innovator

Aras Innovator has prepared security policy for account and password and very simple to set up. Account Policy There are two system variables could handle account policy: AccountLockoutThreshold_triesNum: The maximum trying number of login, user account will be locked if exceed. AccountLockoutDuration_minutes: User account locking duration after reach maximum trying number. ※Account policy will only be effective when values of above two variables are greater than zero. Password Policy There are two system variables could handle password policy: User_pwd_symbols_min_number: The minimum characters that must be contained when user set new password. User_pwd_digits_min_number: The minimum digits that must be contained when user set new password.
Post a Comment
Read more

aras.uiShowItemEx Method (aras Object)

aras.uiShowItemEx Method Shows Item with Item node. Syntax aras.uiShowItem( itemNd , viewMode , isOpenInTearOff ) Parameters Name Type Description itemNd Object Required. Item node. viewMode String Optional. Unknown purpose but only supports the following values: tab view (Default) openFile new ※Each supported value will get same result. Therefore, call method and pass undefined for this parameter is OK. isOpenInTearOff Boolean Optional. Specifies whether show Item with tear-off window. true - open in a tear-off window. false - open in a tab. (Default) Return Value An AsyncResult object or a Boolean. Returns AsyncResult object if the Item winodw is opened successfully, otherwise returns false. See Also aras Object Aras Innovator Client Framework
Post a Comment
Read more