Re: [dev] how to change maxlength of a textarea defined in an xml file?

prmarino1 Wed, 25 Feb 2015 15:43:18 -0800

Sorry it's been a long time since I dug into the schema. Also be aware if I remember correctly the limitation comes from MySQL. VARCHAR fields in MySQL max out at 256 characters and PostgreSQL maxes out at 512. This could in theory be resolved by transforming the column into a "TEXT" field which is essentially a BLOB containing text, but I don't know how well MySQL with searches of that field type. I know extensive work was done in PostgreSQL to make it work well for data warehouses, but I doubt much work was done on it for MySQL since I last looked.

Sent from my BlackBerry 10 smartphone.

From: Roald

Sent: Wednesday, February 25, 2015 13:28

To: Development community of OTRS

Reply To: Development community of OTRS

Subject: Re: [dev] how to change maxlength of a textarea defined in an xml file?

I had a suspicion that I would need to do something like that.

Would you happen to know how to go about this?

Thank you very much,
With kind regards,
Roald

Op 25 feb. 2015 18:05 schreef "Paul Robert Marino" <prmari...@gmail.com> het volgende:

for that you would have to alter the database schema.

On Wed, Feb 25, 2015 at 6:12 AM, Roald <depja...@gmail.com> wrote:
> Dear all,
>
> I want to make a small adaption to this CustomerSLA module:
> http://opar.perl-services.de/package/D/DI/DIETMARB/CustomerSLA
>
> I would like to increase the amount of accepted characters of the
> CustomerIDs field.
>
> Step one is to increase the Cols and Rows in
> /opt/otrs/Kernel/Config/Files/CustomerSLA.xml
>
> <ConfigItem Name="SLAPreferences###02_CustomerIDs" Required="0"
> Valid="1">
> <Description Translatable="1">List of customer company IDs for which
> this SLA applies.</Description>
> <Group>CustomerSLA</Group>
> <SubGroup>Frontend::SLA::Preferences</SubGroup>
> <Setting>
> <Hash>
> <Item
> Key="Module">Kernel::Output::HTML::SLAPreferencesGeneric</Item>
> <Item Key="Label">CustomerIDs</Item>
> <Item Key="Desc">List of customer company IDs for which this
> SLA applies.</Item>
> <Item Key="Block">TextArea</Item>
> <Item Key="Cols">50</Item>
> <Item Key="Rows">3</Item>
> <Item Key="PrefKey">CustomerIDs</Item>
> </Hash>
> </Setting>
> </ConfigItem>
>
> But If I change Cols and Rows the amount of characters when I hit Submit in
> the AdminCustomerSLA window still gets limited to 250 characters. How do I
> increase the max lenght of characters of CustomerIDs ?
>
> Thank you very much,
> With kind regards.
> Roald
>
> _______________________________________________
> OTRS mailing list: dev - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/dev
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Re: [dev] how to change maxlength of a textarea defined in an xml file?

Reply via email to