Skip to Content
0

Query only active projects

Dec 15, 2016 at 03:35 PM

61

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

Hi Michael,

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

If it works, please mark the thread as answered.

Best Regards,

Arun

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sahalya Begum
Jan 30 at 10:31 AM
0

Dear Michael,

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

Best regards,

Sahalya

Share
10 |10000 characters needed characters left characters exceeded
Arun Mavinahally Lakshmikantha
Feb 16 at 12:08 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Arun Mavinahally Lakshmikantha
Apr 12 at 11:07 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded