This enhancement can be used in the context of custom screens. There is no need to modify or add business logic, just UI-Designer magic.

Prerequisites:    The business object has to provide a date that can be used for querying (e.g. CreationDateTime).

 

Expected result:

/wp-content/uploads/2015/04/result_692748.png

 

Step 1: Enhance Query

 

  1. Open your query for your advanced list pane
    1. Add a new data field to the SearchParameters data structure that belongs to your data list

Bildschirmfoto 2015-04-25 um 21.37.16.png

    1. Select the CreationDateTime element on the right in the section of your bound query
    2. Add the CreationDateTime to the query-parameter list
    3. Bind CreationDateTime parameter to the previously created data field

Bildschirmfoto 2015-04-25 um 21.26.35.png

 

 

Step 2: Create Default Set

 

  1. Right click the query and choose add default set
  2. Open the newly created default set
  3. Change the title to a meaningful description (e.g. Quotes of last 5 Days)
  4. Select the query parameter on the left and click + to add a parameter option on the right
    1. Set select option to greaterOrEquals (to select all BO-instances that provide a date at or after a certain point of time in the past)
    2. Click … to add a transformation (this will ‘create’ the point of time in the past)

Bildschirmfoto 2015-04-25 um 21.26.44.png

 

 

Step 3: Create Transformation

 

  1. in create transformation window do:
    1. Select Namespace: http://sap. com/xi/A1S/ReuseFunctions
    2. Select Transformation: DaysToGlobalDateTime
    3. Type in the number of days you would like to include (e.g. -31 [minus! 31] for the last 31 days) 

Bildschirmfoto 2015-04-25 um 21.26.50.png

 

Step 4: Add Default Set to List Pane’s Dropdown List

 

  1. Click dropdown list bar in designer tab or select the AdvancedListPane: ObjectWorkList in properties tab
  2. Select DefaultSet Mapping in properties tab
  3. In the upcoming window do:
    1. Select the previously created default set
    2. Click > to move it to the list of bound default sets

Bildschirmfoto 2015-04-25 um 21.26.57.png

 

The result should look like:

 

/wp-content/uploads/2015/04/result_692748.png

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

      1. Fred K

        Hi Thomas,

        I have set InNowOrToday to True.

        How about other parameters?

        Can you please provide all the three parameters for Today’s record? 🙂

        Best Regards

        Fred

        (0) 
        1. Thomas Zwerg Post author

          Hi Fred,

          I’m not sure right now, since I cannot test it.

          But I’d try:

          • InNumberOfCalenderDays: -1, 1 or 0
          • InDirection: true
          • InNowOrToday: true

          Regards

          Thomas

          (0) 
          1. Fred K

            Hi Thomas,

            Thanks.

            Now when I activate the solution, the system is saying that DaysToGlobalDateTime is not in public solution model and the activation failed. 🙁

            Best Regards

            Fred

            (0) 
            1. Thomas Zwerg Post author

              Hi Fred,

              This is somehow like a known bug. I had some tickets concerning this issue. SAP confirmed that they will solve this by 1511 eventually.

              You can raise a ticket in your system. In case they already solved this, you may get a hotfix.

              Best Regards

              Thomas

              (0) 
  1. Srinivasan S

    Hi Thomas,

    I am trying to display multiple data in an embedded component using advanced list pane. I have created a node in my custom BO and displaying it in this embedded component(EC).

    I am able to save multiple data but only one row of data is visible in this EC.

    Hope you could provide any suggestion.

    Thanks,

    Srinivasan

    (0) 
    1. Thomas Zwerg Post author

      Hi Srinivasan,

      I do not understand how this is related to this post. I guess you should create a new question within SCN and add some context or screenshots for your problem.

      Best Regards

      Thomas

      (0) 

Leave a Reply