AnsweredAssumed Answered

SharePoint Connector - Studio Query returns no results to sharepoint list

Question asked by Joel on Mar 1, 2010
Latest reply on Mar 5, 2013 by sarunachalam
I am attempting to create  an NSQL query for use with the SharePoint connector. I have followed the requirements outlined in the "CA Clarity PPM Connector for Microsoft SharePoint Product Guide" (Page 39. "Query Requirements for Use in Microsoft SharePoint")following all syntax andwtih/witout project filter. The Webpart will map the field collumns, but when using the "Synchronize With Clarity" action, it returns no results, with a "There are no items to show in this List." messageI have tested the NSQL in Clarity, and through a DB editor successfully.Does anyone have any experience with working with this type of Business Visibility Option NSQL queries?  would  anyone have a working sample?This is the nsql I am using to test. will expected results are to return all milestones for the specified project.   SELECT @SELECT:DIM:USER_DEF:IMPLIED:TASK:T.PRID:merge_key@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:I.ID:PROJID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:TO_CHAR(T.LAST_UPDATED_DATE):change_key@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:T.PRNAME:TASK@
FROM INV_INVESTMENTS I,
PRTASK T
WHERE @FILTER@
AND I.ID=T.PRPROJECTID(+)
AND T.PRISMILESTONE=1
AND I.CODE=@WHERE:PARAM:USER_DEF:STRING:SP_PROJECT_ID@
HAVING @HAVING_FILTER@     Regards,Joel  

Outcomes