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:
Step 1: Enhance Query
- Open your query for your advanced list pane
- Add a new data field to the SearchParameters data structure that belongs to your data list
- Select the CreationDateTime element on the right in the section of your bound query
- Add the CreationDateTime to the query-parameter list
- Bind CreationDateTime parameter to the previously created data field
Step 2: Create Default Set
- Right click the query and choose add default set
- Open the newly created default set
- Change the title to a meaningful description (e.g. Quotes of last 5 Days)
- Select the query parameter on the left and click + to add a parameter option on the right
- 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)
- Click … to add a transformation (this will ‘create’ the point of time in the past)
Step 3: Create Transformation
- in create transformation window do:
- Select Namespace: http://sap. com/xi/A1S/ReuseFunctions
- Select Transformation: DaysToGlobalDateTime
- 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
- Click dropdown list bar in designer tab or select the AdvancedListPane: ObjectWorkList in properties tab
- Select DefaultSet Mapping in properties tab
- In the upcoming window do:
- Select the previously created default set
- Click > to move it to the list of bound default sets
The result should look like:
Hi Thomas,
I cannot add parameter for Today's record. 🙂
Best Regards
Fred
Did you try the third option in screenshot: "InNowOrToday" and set it to true?
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
Hi Fred,
I'm not sure right now, since I cannot test it.
But I'd try:
Regards
Thomas
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
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
Hi Thomas,
I will wait 1511.
For now, I will create my own Reuse function.
Thanks,
Fred
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
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
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
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.