Hello,
I want to add some new 'Default Source Codes' - those that can be regularly selected by agents - but am having trouble with the auto-generated ones added by Appeals. They are too high and not very memorable. Is there anyway to manually select sources in a lower range that I know is free?
Thanks in advance,
Kyle (NT)
Hi Kyle,
The source_no value is generated by the get next ID function and isn't an identity column, so you’re in luck! I think you could just add the sources via Appeals as normal, and then manually update the source_no column in TX_APPEAL_MEDIA_TYPE with codes you know are free, like this:
Update TX_APPEAL_MEDIA_TYPE
Set source_no = ‘free source_no here’
Where source_no = ‘current source_no here’
You wouldn't have to worry about accidentally adding a duplicate because source_no is a primary key and SQL will throw you an error if you try to add one that already exists.
So, I think the only thing you would have to be cautious of is that the sources you are updating haven’t been used yet – although SQL will probably throw you another error if that’s the case. Of course it’s always best to try these things in TEST first!
Alternatively, depending on whether you want the agents to just type it straight in or open the sources window and select it, you could use a naming convention that pushes all the defaults to the top of the list. We put an underscore (e.g. ‘_Radio’) in front of all of our default sources to achieve just that.
Hope that helps,
Natasha