03-15-2010 12:04 PM - edited 03-15-2010 12:05 PM
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
03-16-2010 02:11 AM
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)
03-16-2010 07:28 AM - edited 03-16-2010 07:29 AM
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
03-16-2010 07:36 AM
03-16-2010 08:12 AM
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
03-16-2010 12:57 PM
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
03-17-2010 02:08 AM
Hi Joe,
See, Im always right unless Im wrong..