im now incredibly busy as a Systems Administrator for a system called Concept 500.
Its a horrible system but based around SQL its a call logging system, if there is a fault it logs a call and stores it in a database is able to recall it at a later date and add notes to it etc.

In a nut shell it has a section called "workflows" which basically run in the background and perform different tasks, example when a task is logged it will email someone to notify them. It also has periodic workflows which is what im trying to work through but i need to understand what programming language it uses so i can learn it.

i'll post the code in next post as its too many charactes to post @ the mo!!

Does anyone recognise this code at all so i can go off and learn it.

__________________

__________________
He who has never failed has never attempted anything worth succeeding at.

__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."

Hmmmmm maybe :?
maybe i should expand on why i want to learn this, in a nut shell we log jobs for things on Concept lets say someones blinds are broke, they phone us we log it on the system we them assign the task to an engineer and he goes out and completes. Well if for whatever reason the person logging the job forgets to assign the task its forgotten about until someone finds it.
which isnt too bad for broken blinds someone will find it in a day or 2 thats not the end of the world, the problem being we have jobs for people trapped in lifts of fire alarms going off that cant be reset and these need to be assigned straight away as if they are not attended to within 4 hours we face a financial penalty. Now i know what kind of muppet cant remember to assign a call lol it happens trust me, usually when the person logging a call gets interupted either by another phone call or by someone else.

What my workflow is designed to do is to check the system periodically i currently have it set @ 5 minutes and it checks for any tasks left on "active" ie not assigned now this is fine and it works great the problem is we are a big contract every minute we log approx 20 - 30 jobs meaning while my workflow is running and lets say the advisors take 30 seconds to assign the task my workflow is picking all of these up.

What im trying to do is to write a little extra code to say very roughly @ the mo (if TA_TASK.TA.DATE > System.DateTime.Now (6)) then blah blah blah and it goes onto emailing somone to notify them a task has been left unassigned.

the problem is i can not work out the syntax or the format in which it wants.

TA.TASK is a table which TA.DATE is stored and TA.DATE contains the time the call was logged.

Im looking for something to only pickup calls that were logged longer than say 6 minutes ago???? anyone help??

__________________
He who has never failed has never attempted anything worth succeeding at.

If ((F_TASKS.TA_STATUS.ToUpper = "Active".ToUpper) AND (F_TASKS.TA_DATE = current time - 5 minute) Then

__________________

__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."