Warning: It works but it’s an ugly solution 😀
Our users wish to see inactive team requests so with my limited programming skills I have made this solution to add the Active / Inactive buttons the team request page.
A specials thanks to @Ryan_Lane and his post https://community.cireson.com/smp-customizations/post/sql-queries-to-simulate-analyst-views-LO8XRXwDYKufR7Y which gave me the idea to solve this.
This solution contains several steps you must go through before it works.
1. Make at new Navigation Node and a new custom page under this. We don’t want it to be visible in the navigation menu, so we are going to hide this node in the javascript. Make both visible and public to work (https://community.cireson.com/service-manager-portal/post/is-it-not-possible-to-hide-a-page-from-navigation-menu-but-still-have-006CaUmoy25MKPr )
TIP: Place the node last in the navigation menu – it will be visible for a short time before script is loaded.
2. On the custom page add a new sql table widget – Name it “Team Requests” to match the original team request best – but you can use what ever name you want. Query the ServiceManagent database with sql query attached to this post.
3. Fill out the variables in the custom_AddInactiveWorkItemsLinkToTeamRequests.js to match your environment.
4. Load file in custom.js