Does CA PPM provide web service / wsdl to fetch timesheets last date to submit monthly?
Not sure what your definition is of timesheet last date to submit monthly means.
So if last date means last business day of a month, one could write an NSQL to return that date.
This is for MSSQL and show the last non Saturday / Sunday date of the current month.
SELECT 1 as UNIQUE_ID, DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,-1,GETDATE()),0))
- CASE DATENAME(dw,DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,-1,GETDATE()),0)))
WHEN 'SUNDAY' THEN 2
WHEN 'SATURDAY' THEN 1
END AS LASTBUSINESSCURRENTMONTH
) X WHERE @FILTER@
For a different period, one would just replace the GETDATE() function with a date of interest (like the starting period of a timesheet record).
Once we have the NSQL, we get a WSDL.
Using SOAPUI we can test our results.
Thank you for sharing response. I am not a clarity developer. I am just trying to consume web services provided by our local clarity dev teams here.
Goal is to show a small notification on user portal if there clarity time-sheet submission is still due past last date. So, was thinking if there's any out of the box service that i can consume,
There is no "out of the box" query; however if you get your 'local clarity dev team' to build you a simple-query with your required logic then Clarity automatically builds you a web-service (like Gene has documented in some detail above) - i.e. almost "out of the box"
Thank you Gene and David for your responses. In my corporation last dates to submit clarity time-sheets are published publicly. So, i will go ahead and store them in a separate database and match status of returned time-sheets against the dates. i.e. if today's date is past last date to submit clarity and status is not x, where status x = submitted. Can someone please confirm status number for submitted? I think status 4 means approved.
Retrieving data ...