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

[ThomasZwerg]

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:

 

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
   
   
   
   

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

 

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)
   
   
   
   

 

 

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) 
   
   
   
   

 

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
   
   
   
   

 

The result should look like: