Help topics with in multi branch setup

Josy

Hey guys..have implemented the Osticket but our company has over 10 branches and every branch has its own help topics. Now the problem is mixed help topics. Can we have help topics filtering based on a branch. So clients selects their branch and systems loads respective help topics for that branch.

masino_sinaga

Hi Josy,

Could you please give us some example? It would be helpful, I think. ;)

Sincerely,

Masino Sinaga

masino_sinaga

Solution?

Still no response with any example, yet?

Well, okay then. Please try to implement this MOD (if I am not mistaken):

(Displaying Help Topic Based on Selected Department in New Ticket Form at Client Side of osTicket v1.6 RC5).

Hopefully this will help you. Cheers!

Sincerely,

Masino Sinaga

Josy

multi branch Help topics

Thanks..have been out of internet..now your solutions works, have modified it to fit branches instead of departments.

The problem is now on the sql error. Though the code is working it sends and an sql error as shown below

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY topic' at line 1

i guess this is generated by below code on Includes/Client/open.inc.php file

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 AND dept_id = '.$info.' ORDER BY topic');

masino_sinaga

Josy,

Make sure you have already done the step number 4 correctly.

Sincerely,

Masino Sinaga

blkphtm

I also had the same issue as Josy and followed the link instructions in the link above.

I managed to resolve the issue by modifying the open.inc.php file in /includes/client directory.

Find:

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 AND dept_id = '.$info.' ORDER BY topic');

Replace With:

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 ORDER BY topic');

I was comparing some of the differences to a previous mod posted here: (http://www.osticket.com/forums/showthread.php?t=2023&highlight=department+topic). Everything is working as it should with no DB errors.

I also made a slight change to the findtopic.php file.

From:

<option value="">Select Help Topic*lt;/option>

To:

<option value="">Select Help Topic</option>

Hope this helps anyone else who runs into this issue.

-Daren

masino_sinaga

Hi Daren,

Thanks for your feedback and correction for "*lt;" become "<" or "

I have modified the original code on my blog. Also, the alternative way to avoid the error related to SQL query.

Hope it helps all of you.

Sincerely,

Masino Sinaga