Contact Process - "TASK" name field location [ Edited ]

[slsl]

Hey Everyone,

I'm working on a Crystal report to report on the status of "Waiting/In Process/Suspended/Completed/Aborted/etc..." contact processes and while most of the report is diagramed out, the "Task Name" field eludes me.  When viewing the attached image on this e-mail, you can see that the first process after starting is called "Follow Up Visit".  Where would one find the table and field that corresponds to that title?  I'd like to include this on the report so the managers can get a quick 30,000 foot view with where everything is standing.

As always, any info is greatly appreciated.

Regards,

Joe

Message Edited by slsl on 03-15-2010 03:05 PM

[AdamTravers]

Hi Joe,

I believe the data is stored within the Process table - Data field which is a blob field (You can view the data within Tools Execute SQL within the SLX Administrator)

[slsl]

Hey Adam,

Really?  That doesn't make any sense to me unfortunately.  Why would the description of the process step be inserted into a Blob (data - picture) field?  I'm not totally convinced that the data I'm looking for is where you indicate it to be.  (Which would really suck...)  If you look at how the steps are captured in a Sales process, that makes way more sense.  Difficult to report on, but able to be identified.

Thanks for the idea on the subject, but me being stubborn, will continue to look for it.  Whole eastern European background thing...

Take care,

Joe

Message Edited by slsl on 03-16-2010 10:29 AM

[AdamTravers]

Sorry! I meant the plugin table (Ive just read my thread)

[slsl]

Hi Adam,

Looked over the table suggested and while it links to the Process table via the BASEDON field, the step name isn't there   A boat load of other names and descriptions, but the one(s) that I'm looking for isn't/aren't.  Rather frustrating if you ask me.  Heck, it's frustrating if you don't ask me either.

Cheers,

Joe

[slsl]

Hi Adam,

Yep, it's the PLUGIN table, in the DATA field, which is a BLOB field.   ...sigh...

Which will now lead me to my "next" post.

Take care,

Joe

[AdamTravers]

Hi Joe,

See, Im always right unless Im wrong..