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

Popular posts from this blog

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

aras.uiShowItem Method (aras Object)

aras.uiShowItem Method Gets Item by Item ID and then shows the Item. Syntax aras.uiShowItem( itemTypeName , itemID , viewMode ) Parameters Name Type Description itemTypeName String Required. Name of the ItemType. itemID String Required. ID of the Item. viewMode String Optional. Unknown purpose but only supports the following values: tab view - This is default. openFile new ※Each supported value will get same result. Therefore, call method without this parameter is OK. 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

window.handleItemChange Method (Instance Window Object)

window.handleItemChange Method Changes current Item's property value. If Item is not locked, the function will do nothing. Syntax window.handleItemChange( propNm , propVal , dataType , datePattern ) Parameters Name Type Description propNm String Required. Property name. propVal String Required. Property value. dataType String Optional. Property data type. If the data type is "date", this parameter is required, otherwise it is not necessary to pass. datePattern String Optional. Date pattern, supports the following values: short_date (Default) short_date_time long_date long_date_time See Also Instance Window Object Aras Innovator Client Framework