Hola Guys,
There has always been lot of buzz about understanding and creating apps in Studio application and usually people tend to think it is quite complicated and will create issues while running in prod and they opt to use Global app instead. Last year, I had created an app in Studio for my client which is still running fine without any issues 🙂 .
Having said that, it's a very basic app but it sorted out lot of manual work for Change Managers where they had to manually search and delete the templates that were unused since 1 year. Their environment allowed any ITIL user to create templates for themselves but they were often left unused or people used to leave the company.
My app will basically show a report and a custom table to change managers of all the custom templates created and their last used date, last used by and Number of times a template was used. ( We are tracking usage of Change Templates here)
So, let's quickly start my favorite part- Coding.
- Go to Application Navigator and search and click Studio
- Select 'Create Application' and then 'Start From Scratch'. Give your application a name and then click 'Create'
- You will be now in your Studio and then click 'Create Application File'. Create a new table, by clicking Table in the pop up and then click 'Create'
- Type in the details of the table and its columns. The columns are specified in the screenshot below
- Similar to the creation of table, create a new business rule which will create an entry in our custom table 'Template Metric' whenever a new record(template) is created in the system. So, its a 'After-Insert' business rule
- Next, we have to update our 'Template Metric' table whenever our Change request is created. To update, I wrote a custom 'After-Insert' Business rule on Change table which will update Template Metric record with Last Used By (Current user), Last Used (Current Date) and will increase the counter by 1
- We have to next handle the deletion of template which is quite straight forward. If the change manager or user deletes the change template, it should not have any record in 'Template Metric'. To handle this, I created a 'Before-Delete' business rule on Template[sys_template] table
- Our app is almost ready. We just have to add the Template Metric on the Application Navigator for Change Managers to review all the custom templates and their usage through counters
- As an alternative, you can create a report for Change Managers to check the templates that were not used in last 1 year. Give the edit rights to Change Managers so they can update the report w.r.t. their requirement
Finally, we are done with our app in Studio which is quite basic but will ability to get hands-on experience on Studio. I think studio is not gaining the popularity it deserves. Any thoughts or where you guys have used studio?
Let me know if you guys have any issues in understanding studio apps or are stuck while creating the app.
Cheers,
Hardit Singh
