Skip to Content
Author's profile photo Thomas Zwerg

HowTo add Default Set for „Last 10 Days“ or „Due within 2 Weeks“ to Advanced List Pane

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

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Fred K
      Fred K

      Hi Thomas,

      I cannot add parameter for Today's record. 🙂

      Best Regards

      Fred

      Author's profile photo Thomas Zwerg
      Thomas Zwerg
      Blog Post Author

      Did you try the third option in screenshot: "InNowOrToday" and set it to true?

      /wp-content/uploads/2015/10/bildschirmfoto_2015_04_25_um_21_26_50_692751.png

      Author's profile photo Fred K
      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

      Author's profile photo Thomas Zwerg
      Thomas Zwerg
      Blog 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

      Author's profile photo Fred K
      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

      Author's profile photo Thomas Zwerg
      Thomas Zwerg
      Blog 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

      Author's profile photo Fred K
      Fred K

      Hi Thomas,

      I will wait 1511.

      For now, I will create my own Reuse function.

      Thanks,

      Fred

      Author's profile photo Srinivasan S
      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

      Author's profile photo Thomas Zwerg
      Thomas Zwerg
      Blog 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

      Author's profile photo Srivas S
      Srivas S

      Hi,

      So I did exactly as you have pointed out in this. Plus, have also imported in my BO. Saved, activated and refreshed the same. But the transformation field is still blank. It is blank for all SAP reuse functions.

      Thanks

      Srivas

       

      Author's profile photo Srivas S
      Srivas S

      Hi,

       

      Figured although the name is given as CreationDateTime, in reality the datatype is AP.Common.GDT:Date and not DateTIme as can be interpreted from name.

      It works.