The input param will be the "function name" and the output should be "all the responsibilities that use that function" irrespective of whether the function in under the menu or the sub-menu of that responsibility.

Mozen

• May 25th, 2018

The compiled_menu_functions table also takes into account submenus.. the table contains the result of the loop you have used in your query. I cant seem to find the correct query that takes into account exclusions

Paras

• Feb 27th, 2018

Fouzias answer is correct if you add following where clause in last two inner queries

and frf.responsibility_id = r.responsibility_id

Answer Question  Select Best Answer