Skip to Content
0

Query builder favorite reports by user group

Jun 20, 2017 at 02:55 PM

76

avatar image

Hi experts,

I am struggling to build a Query Builder query for LCM_CLI that will allow me to export favourite folders and the reports in the favourite folders for a specified user group. My query is:

SELECT TOP 10000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS WHERE CHILDREN("SI_NAME='User-Favorites'","DESCENDENTS('SI_NAME="UserGroup-User"','SI_NAME="<User Group Name>"')")

Can anyone help me please?

Alternatively what is the best way to export favourite folders and the reports in the favourite folders for a specific group of users?

Thanks,

Chris

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Manikandan Elumalai Jun 26, 2017 at 11:51 PM
0

Hello Chris,

You cannot achieve the relationship in a single query. You need to go for a SDK code. Because Usergroup-User relationship and User-Favorites relationship are maintained separately and you cannot capture the relationship between all three in a single query.

Thanks

Mani

Show 2 Share
10 |10000 characters needed characters left characters exceeded
2

Thanks Joe. I never tried this way. Thanks for sharing again.

0
Manikandan Elumalai Jun 26, 2017 at 11:55 PM
0

refer my blog here to understand the relationships https://blogs.sap.com/2013/06/10/businessobjects-query-builder-queries-part-iv/

Share
10 |10000 characters needed characters left characters exceeded