Database Intergration VM Pro

[Maxwell1001]

Im trying to work through a very complex (to me)database intergration and i have to admit all is going surprisingly well but im struggling on one bit and wanted to confirm it was possible.

and engineers dial enters a job number
system confirms job number and address

engineer pick from list of options on route,started,complete etc

what im trying to set up is so an engineer can only say the job is complete if its current state is started, or can only say on route if the system says confirmed access, is this possible, the only way i can find to do it is for the database to read out the current state and the engineer has to decide if to proceed but this leaves room for error or abuse, what the customer wants so there is no confusion is

if an enginner is trying to mark a job as complete but they have not marked it as started that the database will automatically check this and say invalid option "Mark as Complete" current status is "Awaiting Parts"

in principle can this be done, if so i will keep trying and if not please can somone suggest a better way

Regards

ACA - IP Office
ACS - IP Office
ACSS-SME

 

[TaureanDragon]

Bit of an old post, so probably sorted. But it was interesting and had no responses .

The questions I would ask would be along the lines of
How many states are there?
How many Transitions are possible from each state?

With an initial view that the number of states and possible transitions were not too many, something along the lines of:

New ----> Reject
|
|
| +->------------------------>+
v | v
Allocated ->+->-------------------------->+- On Route ->+-> Started ->+->-------------------->+-> Completed
| | ^ ^ | ^
+--> Awaiting Parts (A)-->+ | | +-> Awaiting Parts ->+
| | | |
+-------------->+ | v
+<-----------------------------<-+

So (Current state) (Possible Options)
From 'New' - 'Reject' or 'Allocated'

From 'Allocated' - 'Awaiting Parts (A)', 'On Route' or 'Started'

From 'Awaiting Parts (A)' - 'On Route' or 'Started'

From 'On Route' - 'Started'

From 'Started' - 'Awaiting Parts (B)' or 'Completed'

From 'Awaiting Parts (B)' - 'Started' or 'Completed'


Could get the Current 'State value and test
Use the test results to branch to 'Menu' actions that presnet the caller with only the options that are valid transitions from the current state.
Change state based on caller input
Note: Available option should probably also support an option for 'No Change' (Though this would also be achieved be hanging up).