Skip to Content
avatar image
Former Member

Query only active projects

Hi all,

for an integration scenario, I have to get the data of all active projects in ByDesign.

At the moment I use the QueryProjectIn service to query the projects. But this service doesn't support a query filter for the status. This mean I have to get all projects and filter them. Of course this is neither fast nor very nice.

Do you have any suggestion to get only active projects?

Thanks,

Michael

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 30 at 10:31 AM

    Dear Michael,

    To get only active projects you can make use of a PDI/custom generated webservice on basis of projects.

    Best regards,

    Sahalya

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Michael,

    Can you try the below snippet to get the project details based on status?

    http://sap.com/xi/SAPGlobal20/Global">
    <ProcessingConditions>
    <QueryHitsMaximumNumberValue>2000</QueryHitsMaximumNumberValue>
    <QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
    </ProcessingConditions>
    <ProjectSelectionByElements>
    <ProjectStatus>
    <ProjectLifeCycleStatusCode>3</ProjectLifeCycleStatusCode>
    </ProjectStatus>
    </ProjectSelectionByElements>
    </n0:ProjectByElementsQuery>

    In the ROOT node, you can select Object Name Status -> PRO_S_PROJECT_STATUS -> PROJECT_LFCYC_STAT_C ProjectLifeCycleStatusCode .

    IN_PLANNING - Action code 1

    STARTED - Action code 2

    RELEASED - Action code 3

    STOPPED - Action code 4

    CLOSED - Action code 5

    COMPLETED - Action code 6

    You can use Action code 3 to get the RELEASED projects.

    Please try this & mark it as answered, if it is helpful.

    Best Regards,
    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Michael,

    Please let me know, if you have tested with the above snippet.

    If it works, please mark the thread as answered.

    Best Regards,

    Arun

    Add comment
    10|10000 characters needed characters exceeded