This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
BMC Digital Workplace Advanced
BMC Digital Workplace Basic
What configurations and/or new DB indexes can be made to limit the number of Requests returned when clicking on 'My Activity'?
Currently it takes a long time to populate, and when clicking on Details on one of the Requests in the list and go back it takes a long time to populate again (i.e. does not appear to cache)
Index can be added to SRM:
Add the following compound index to the SRM:Request form:
301378004 Source Keyword 4 (CHAR)
303490600 CartID 4 (CHAR)
1 SysRequestID 4 (CHAR)