[otrs] Make certain queues not "cross searchable"

[Hochreiter Martin]

We normaly can search for locked tickets of other agents in any queue of our
OTRS 6.

 

For data protection reasons, I need to deactivate that feature for certain
queues only – could this be done?

 

 

 

_
DI (FH) Martin Hochreiter

Fachverantwortlicher Systemadministration

IT und Infrastruktur


Fachhochschule St. Pölten GmbH
Matthias Corvinus-Straße 15, 3100 St. Pölten
T: +43 (0) 2742 313 228 – 215

M: +43 (0) 676 847 228 215

E:   martin.hochrei...@fhstp.ac.at
I:   www.fhstp.ac.at
FN 146616m, LG St. Pölten, DVR 1028669F

 



smime.p7s
Description: S/MIME cryptographic signature
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Re: [otrs] RES: OTRS 5 migration from MySQL to PostgreSQL

[Never Min]

>
> Also, would be nice to add a suggestion for large installations to put all
> attachments on filesystem first
>

nice, thank you for your share


-Never

Edson Richter  于2019年2月21日周四 上午11:01写道：

> Thank you very much. It is wonderful how easy this script made my day.
>
> The only think I’ll point is that documentation is far behind the PDF that
> you have access through the web interface.
>
> Also, would be nice to add a suggestion for large installations to put all
> attachments on filesystem first – a “dry-run” will just die with 19Gb of
> attachments in mysql database (and I suspect that a migration also will
> die).
>
>
>
>
>
> Atenciosamente,
>
>
>
> Edson Richter
>
>
>
>
>
>
>
> Soli Deo Gloria
>
>
>
> *De:* otrs  *Em nome de * Never Min
> *Enviada em:* quarta-feira, 20 de fevereiro de 2019 07:08
> *Para:* User questions and discussions about OTRS. 
> *Assunto:* Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL
>
>
>
> Hi,
>
>
>
> please see this link:
>
>
> https://doc.otrs.com/doc/manual/admin/5.0/en/html/installation-on-windows.html
> 
>
>
>
>
>
> -Never
>
>
>
>
>
> Edson Richter  于2019年2月20日周三 上午6:13写道：
>
> Our company uses PostgreSQL as standard database for everything (that
> needs one 😉 ).
>
> So, our OTRS 5 system is the last one based on MySQL. Since we are facing
> some OS update issues, we decided it is time to move.
>
> I would like to know if there is a easy way to migrate data: for instance,
> can I bakcup (using otrs backup/restore scripts) on MySQL and restore on
> PostgreSQL?
>
> Or can you point me the tables that are more critical?
>
> I’ve tried to migrate using pgLoader (it is a breeze), but some contente
> show strange caracters after migration.
>
>
>
> I’ll appreciate your guidance or share your experience!
>
>
>
>
>
>
>
> Atenciosamente,
>
>
>
> Edson Richter
>
>
>
>
>
>
>
> Soli Deo Gloria
>
>
>
> -
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> 
> Archive: http://lists.otrs.org/pipermail/otrs
> 
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
> 
>
> -
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
>
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] Are FAQ attachments stored differently in MySQL and PostgreSQL?

[Edson Richter]

Hi!

Are FAQ attachments stored differently in MySQL and PostgreSQL?
I ask that because in MySQL I do have a "BLOB" type for the "content" column, 
and in PostgreSQL a "TEXT" type.
I'll appreciate your directions.


Regards,

Edson Richter



Soli Deo Gloria

-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] RES: Are FAQ attachments stored differently in MySQL and PostgreSQL?

[Edson Richter]

Answering my own question:

In MySQL: attachments are stored in binary format into blob field
In Postgres: attachments are stored as base64 encoded into text field.

Atenciosamente,

Edson Richter



Soli Deo Gloria

De: otrs  Em nome de Edson Richter
Enviada em: quinta-feira, 21 de fevereiro de 2019 12:40
Para: User questions and discussions about OTRS. 
Assunto: [otrs] Are FAQ attachments stored differently in MySQL and PostgreSQL?

Hi!

Are FAQ attachments stored differently in MySQL and PostgreSQL?
I ask that because in MySQL I do have a "BLOB" type for the "content" column, 
and in PostgreSQL a "TEXT" type.
I'll appreciate your directions.


Regards,

Edson Richter



Soli Deo Gloria

-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] OTRS 6 / AgentArticleZoom => Limit number of Articles

[Ml Ml]

Hello!

in AgentArticleZoom you can select if you want to show all articles of
a ticket or just one.

Can you point me the source code or sysconfig where i could change the
"SELECT  LIMIT 1" to like "SELECT  LIMIT 10" ?

I would like to show all articles OR the last 10 (not just one).

Thanks,
Mario
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Re: [otrs] OTRS 6 / AgentArticleZoom => Limit number of Articles

[Alvaro Cordero]

Hello,

I believe that is already done in the ticket zoom, you have the option to
see 1 article or to see all the ticket articles just like in you email
tools.

In Old systemas you had

[image: image.png]

The second icon is to see all articles.

In current versiones it shows the Settings icon where you can chose wether
see 1 or all articles

[image: image.png]
[image: image.png]

Regards


El jue., 21 feb. 2019 a las 10:18, Ml Ml ()
escribió:

> Hello!
>
> in AgentArticleZoom you can select if you want to show all articles of
> a ticket or just one.
>
> Can you point me the source code or sysconfig where i could change the
> "SELECT  LIMIT 1" to like "SELECT  LIMIT 10" ?
>
> I would like to show all articles OR the last 10 (not just one).
>
> Thanks,
> Mario
> -
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
>


-- 

*Alvaro Cordero RetanaConsultor de Tecnologias*
*Tel: 22585757 ext 123*
*Email:* alv...@gridshield.net
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs