Changing lowercase letters to uppercase letters

lucasjt
Tera Contributor

Hey guys.
When I opened an incident using the chatbot, in the "channel" field it comes as "Chatbot", but very rarely, it comes as "ChatBot":

lucasjt_0-1700252766942.png

 

When it comes to "ChatBot" (with the capital letter B), the field in the incident list is blue, as if it didn't exist.

 

The question is, does anyone know anything I can start investigating? Any directions?

 

This is an instance of a client. Where they extract data from ServiceNow (from the incident table) to use outside the platform, and this is causing problems.

Thanks!

3 REPLIES 3

AshishKM
Kilo Patron
Kilo Patron

Hi @lucasjt ,

Check the Choide [ sys_table] for Inciden table Channel values, ChatBot exist or Chatbot. 

There may be somewhere ChatBot process is setting channel value as ChatBot instead of Chatbot.

 

-Thanks,

AshishKMishra

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Danish Bhairag2
Tera Sage
Tera Sage

Hi @lucasjt ,

 

Can u check if those incidents where blue chatbot comes are created via some integration or script & not manually.

 

The reason when Blue color comes is that record at the time of insertion is not present in the database.So as you said like u have an option Chatbot but some incidents have capital B in it.

 

This does not happen when manually an incident is created bcz u need to select from the available options. But in case of integrations or some script it can happen.

 

If u have a virtual agent or chat bot in ur instance please check there is there is any flow where incident creation happens automatically ,if yes is there any script or wrong Chatbot name entered with capital B.

 

Thanks,

Danish

 

Sandeep Rajput
Tera Patron
Tera Patron

@lucasjt The potential sources for this issue could be a Business rule, script include or a third party integration. If you manage to find the please from where this record is originating you can fix the field value there.

 

In case if you don't get a clue about this issue, then you can simply fix the existing records via a background script and for the new records, you can simply create an onBefore Insert/Update business rule and apply a filter condition Channel Contains ChatBot. In the Action section of the BR you can set the Channel value to Chatbot.

 

 

 

Screenshot 2023-11-18 at 1.03.51 PM.png

Screenshot 2023-11-18 at 1.04.15 PM.png