Stuart Torres-Catmur Posted January 7, 2022 Share Posted January 7, 2022 I have run a report from the Services Table to find out the IDs of our services and note that each service seems to have two IDs. See examples below 63 Change Request 64 Change Request 129 Digital Service Request 130 Digital Service Request 3 ICT Service Request 4 ICT Service Request 13 ICT Software & Equipment Request 14 ICT Software & Equipment Request 135 New Digital & ICT Project 136 New Digital & ICT Project 65 Test Digital team requests 66 Test Digital team requests 59 Test IT Service 60 Test IT Service We want to start deleting requests older than a certain date by service type, putting the relevant IDs in the Clean Utility JSon script line RequestServices:[e.g. 1,2,3], then adding RequestLogDateTo:"2020-01-01 00:00:00" so it deletes all requests logged under those services up until 1st January 2020. Do I have to put both IDs in for each service or just the first one? The first one appears in the URL when the service is selected, e.g. 3 for ICT Service Request https://live.hornbill.com/walthamforest/catalog/service/com.hornbill.servicemanager/3/ Link to comment Share on other sites More sharing options...
Victor Posted January 7, 2022 Share Posted January 7, 2022 @Stuart Torres-Catmur what report you ran... interested to see what fields you choose to output and what table(s). The same ID for different records is expected (I'll explain why) but depends on what field you used to output these IDs... Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted January 7, 2022 Author Share Posted January 7, 2022 @Victor the report just uses the Services table. The column returning this data is Service ID. The report was set up just to get the right Service IDs. Link to comment Share on other sites More sharing options...
Victor Posted January 7, 2022 Share Posted January 7, 2022 @Stuart Torres-Catmur right... I have misread your initial post .. I thought you said "two services have the same ID" ... So what you see there is translations. While the service name is the same, each ID you see there belongs to a different translation. So, in your report add this column: Linked Translation ID. This would be the ID that you would use for each service. You will notice that while there are different service IDs for the same service (identified by name for example) there is only one linked translation and that is the (service) ID that you need. 1 Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted January 7, 2022 Author Share Posted January 7, 2022 @Victor thank you. That makes sense. I'll ensure I use the Linked Translation ID 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now