Print  
Gray star Gray star Gray star Gray star Gray star --Not rated--
252 Visits 3 Comments
Created
Marcel Dekker Marcel Dekker
Kablink Component
  • Teaming

I'm trying to build my own database query for entries in a folder for a remote app. I do have this working with SOAP calls, but since this is a query that's searching for all tasks below a couple of hundred workspaces and folders SOAP is just taking to long (not to mention the load on the server). By doing the query directly on the database the time is cut down from several seconds to below one second so this improves it a lot.  I have it working except for the start and end date. This is stored in a single cell in a format I don't understand. Anybody know how to manipulate this to get the start and end date?

Thanks.

Workflow
Process State Action
Discussion workflow Active
This entry is currently active
Attachments(0)
Entry History
Tags
 
Replies
Thumbnail Image
Marcel Dekker Marcel Dekker

It look like sombody replied to my question, but I can't see the reply.

Thumbnail Image
Paweł Nowicki Paweł Nowicki

Hi again. I wrote reply but then read post again and removed it :).

One more try: start/end time for tasks you can find in SS_Events table. It's just a standard datatime column.

Thumbnail Image
Marcel Dekker Marcel Dekker

Thanks,

that's it. The field I found is pointing to that table. I was just to lazy to look a little better ;-)

Skip Footer Toolbar