Hi RTDev Team,
Im using RT 4.0.4 and currently now its under testing for implementation. I have some issues to clarify regarding RT and hope you guide or give some suggestions, answers for this.
- Can i print/ review all ticket created for hardcopy purposes.
- Ticket number needs to be format of YEARMONTHDAYxxxx
Example: #201707310001 would be the 1st ticket for today.
- Is there a possibility for the requestor to have first approval of his/her supervisor before creating a ticket?
Thanks in advance
Hope you guide me for this
Denver21
For 2 You can use SetStartingId - Request Tracker Wiki.
Example:
/etc/cron.d/newid:
1 0 * * * postgres [ -x /usr/local/bin/newid ] && /usr/local/bin/newid
/usr/local/bin/newid:
#!/bin/bash
id=$(date +%y%m%d0000)
/usr/bin/psql -c "SELECT setval('tickets_id_seq', $id);\q" myrtdb >>/var/log/newid/newid.log 2>&1
hi mkosmach
Sorry but where will i encode this? what part of the configuration?
Thanks in advance
It’s not an RT configuration options.
It’s postgresql-specific way to set seq id.
-
Create file /usr/local/bin/newid
#!/bin/bash
id=$(date +%y%m%d0000)
/usr/bin/psql -c “SELECT setval(‘tickets_id_seq’, $id);\q” myrtdb >>/var/log/newid/newid.log 2>&1
-
Make in executable
chmod 755 /usr/local/bin/newid
-
Create file /etc/cron.d/newid:
1 0 * * * postgres [ -x /usr/local/bin/newid ] && /usr/local/bin/newid
Hi Jeff,
Thank you for your response, its a great help for me to enlighten.
Regards,
Hi mkosmach
Thanks for the great help, ill check this out.
Regards
Hi mkosmach
Not yet, but i will… thank you for your prompt response.
Regards,