When working with Saved searches, it’s often essential to filter and narrow down the results based on specific criteria. For searches on execution of saved search, “last run by” filter allows us to view entries based on the individuals who performed the execution. However, by default, the filter options are limited to “mine,” “my team,” and “all,” making it impossible to view logs for specific individuals.
This limitation can be overcome by introducing a formula(text) in the criteria region. By leveraging the formula(text) functionality, we can enhance the execution log search to include more filtering options. To get started, a formula is added in the criteria subtab with the description “{lastrunby} contains h.” This formula essentially enables to search for entries where the last run by name contains the letter “h.”
Once the formula(text) is created, we can incorporate it into the available filters for the execution log search. This addition will introduce a text box in the filter section of the saved search results, allowing users to input names or parts of names to find the desired results. Users can now search for saved executions based on the employees who last ran them. For example, if we type “dipinker” in the text box, the search results will display the saved execution last run by the employee named “dipinker.”
Note: – In some cases, there may be multiple formulas in the criteria region. If this is the case, remember to prioritize the desired formula by placing it first. This ensures that the search results accurately reflect the intended criteria.