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?