AnsweredAssumed Answered

Portlet using OBS and Time

Question asked by brenochuba- on Aug 12, 2010
Latest reply on Aug 16, 2010 by brenochuba-
Hi,

I didn't found information about OBS and Period Time to create a custom portlet.

1 - I need to know what table/column I have to use to create a SQL/NSQL query to create a filter in a portlet that use OBS Resource. I have the same OBS to Project/Resources/Ideas.

For example: I select IT area in OBS, so show information only of resources that are in IT.


2 - What table/column I have to use to create a SQL/NSQL query to filter a period of time, for example to filter some timesheet information. The idea is:

Filter: Period of Time: xx/xx/*** to xx/xx/xxxx

I want to know the timesheet information of period 07/01/2010 to 07/01/2010 for example.


Best Regards,

Breno Chuba, CAPM

Outcomes