field State change to 3 or more letters or numbers (char)

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

field State change to 3 or more letters or numbers (char)

Postby speedmaker » Tue Feb 15, 2022 11:12 am

Hello

When i log in as an agent and i look at field State i just can use 2 Letters - is there a posibillty to change that in 3 or more letters or numbers.
i dont need the state i want to relabel it to my needs ,, but we need mininum 3 letters / numbers

https://www.transfernow.net/dl/vici

the yellow one ,,,

thx Speedmaker
speedmaker
 
Posts: 34
Joined: Wed Sep 02, 2020 10:46 am

Re: field State change to 3 or more letters or numbers (char

Postby mflorell » Wed Feb 16, 2022 7:17 am

Since it's a text field, the agent script will adjust the form size if you alter the table column on the MySQL client:

ALTER TABLE vicidial_list MODIFY state VARCHAR(3);

Keep in mind you should only perform that query after-hours when nobody is using the system since it may take a while to perform, and it will lock up your system until it is finished.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: field State change to 3 or more letters or numbers (char

Postby speedmaker » Mon Feb 21, 2022 1:35 am

Hello Matt,

Thx but i thing something went wrong ,, i logged in in maria db and tryed it but nothing happend. i waited over a day.
regards speed
speedmaker
 
Posts: 34
Joined: Wed Sep 02, 2020 10:46 am

Re: field State change to 3 or more letters or numbers (char

Postby mflorell » Mon Feb 21, 2022 7:22 am

Post the results of this query from the "mysql>" prompt:

describe vicidial_list;
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 83 guests