hi all,
I am trying to get the complete list of users with direct or indirect reporting to the logged in user. for the same i am tring to write the fetch xml statement.
as usual i first wrote the sql statement and then tried to convert it in the fetch xml but this time i wrote a CTE statement.
and now i am stuck in how to convert the sql CTE queries to fetch xml query ??
do you have any suggestion on how to do that ?
or any other way to write the recursive fetchxml query ?
*This post is locked for comments
I have the same question (0)