adutoit1

Thanks Eric, I do have mySQL, but not clever enough to know how to export from the various tables and keeping the various fields linked. Anyways, Ill play around a bit more and see if I can figure this out. Thank's for your all your help! Regards, Stephan

Ah so it was indeed the apostrophes. Now the new colour is displayed, however, upon choosing the new colour and clicking "Save" the application reverts back to the previous colour used. What did I miss?

Hi Sbaskerville, Yes I did. You need to mark your main or Parent ticket as a "Problem": Then open the ticket (Child) you want to link to the Parent ticket and click on "Problems" tab: Next, click "Search" and choose the "Problem" (Parent) ticket: And your done. Any updates you make to either ticket will reflect on the…

Ok, so I encountered a small problem... The colours disappeared altogether. See attached screenshot of both WHD interface and the saved code snippet. I have a suspicion it might have something to do with those ' ' in which the colour code is encapsulated. Any ideas?

Hi Eele, The reason I would like to have the Subject field listed is because of the Export functionality. This morning i noticed by just adding and removing a few other columns and then Exporting, I know do get the "Subject" exported as a separate column. See below: So, that problem is for now resolved. However, I do have…

Hi Andeporter, Thank you so much. I will start the work on it now and will let you know whether I achieved success or a miserable failure.

Hi there, Forgive my ignorance, but how do you create this parent and child relationships? I know this can be achieved by marking the parent ticket as a "Problem" and the child tickets as "Incidents". However, Is there a way to do it on "Service Request"? Appreciate your assistance.

Thanks, Kelly I came right. I started to study the WHD MySQL structure and found the relevant tables and fields that I need to query data from. Also, this REST API also came in handy when generating automatic form completion in our Visio planning files. Life is getting simpler. Slowly but surely. Regards, Stephan

When I click on the new colour, it sticks. When I submit though it reverts back.

Haha, only just. The new problem still exists though... If I select my newly created colour, it does not stick. It reverts back to the previous colour. What am I missing?

Thanks Fluffy, I added the code to the only area I noticed would take code, "Email Footer". It worked great, but obviously its not the real solution. I need to find out where I should add the code to have the logo in the header. Let me know if you have any other ideas. regards, Stephan