Using Milestones

I'm trying to build an application that would wrap around the actual Livelink's task system. I already finished building my objects around Task objects and I was going to start working on the Milestones when I realised there doesn't seem to be anything implemented to retrieve the real information given by this object (the percentage done for instance).So here is my question:1- Am I missing something?2- If not, what is the best way to implement this?What I tried up to now is to create a new API to retrieve the information. I used the $Task.TaskListUtils.MilestoneInfo( prgCtx, node ) function which returns really too many values for what is needed and takes too much time (the point of the API being to be as fast as possible).What I'm looking at now is to define some SQL queries to retrieve the data but I'm wondering if it is a great idea since we have no warranty on the schema itself between versions and since we are too often pushed to upgrade to be able to solve bugs, I think this could lead to a lot of job for each release :SWhat is your answers/opinions on the subject? Thanks!

Find more posts tagged with

Comments

Louis_Routhier

I don't know why but each time I post on these forums, I never get an answer... Maybe my posts are too technical? Or my English is bad? any idea how I could reformulate this to be better understood?If you have any questions that could enlightn this topic, feel free to ask them.Thanks

eLink User

Message from Carsten Kulms via eLinkCannot comment on the "each time [...] never get an answer".However, your questions in this thread are very special. If I understood correctly you're implementing your own extension ofLAPI, because the current functionality does not match your needs and isnot fast enough. I.e. you're doing module (OScript) development.I think this is out of the scope of the most readers of this forum. (Iapologize if this offending to anyone.)While I have some experience in development of LES modules andimplemented LAPI extensions in the past, I'm unfamilar with all theWorkflow stuff. Sorry, therefore I cannot give you any tipps regardingthat.Just a note on "define some SQL queries to retrieve the data but I'mwondering if it is a great idea": I would not recommend to access thedatabase directly. What you've said about changes in the schema is onereason. Another is that working directly with the database is annoyingand error prone.

Carsten_Kulms

... because of the nature of your questions.You find the Development Discussion here:https://knowledge.opentext.com/knowledge/llisapi.dll/open/786303

Louis_Routhier

Good idea! thanks!