Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Requesting for NSQL query for the below requirement

  • 1.  Requesting for NSQL query for the below requirement

    Posted Nov 27, 2013 03:23 AM
    •  Need NSQL query to show one level of Master Projects and Enhancements, and one level of subprojects and sub-enhancements,with below details.
    • Name
    • ID
    • Type (Idea, Project, Enhancement)
    • Project Manager
    • Process Step
    • Start Date
    • Finish Date
    • Status

    could anyone please help me with this?



  • 2.  RE: Requesting for NSQL query for the below requirement
    Best Answer

    Posted Nov 27, 2013 08:58 AM

    Here is a bit of sample sql code. You'll need to build out your additional sql needed (fields, tables, etc) and eventually convert to NSQL. But this can get you started:

    select srm.id, srm.name, srm.unique_name, prt.prid subprojID, prt.prname subProject
    from niku.srm_projects srm, niku.prtask prt, niku.prsubproject prsub
    where srm.id = prt.prprojectid
    and prt.prid = prsub.prtaskid
    and srm.unique_name = 'your project code here';

    Allen



  • 3.  RE: Requesting for NSQL query for the below requirement

    Posted Nov 27, 2013 09:03 AM

    Thanks allen!..