Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ivan 165 posts 542 karma points
    Feb 25, 2014 @ 06:51
    Ivan
    0

    List member groups in the backoffice.

    Hi.

    I would like to output availalbe member groups using SQL Dropdown. Does anybody in the world know appropriate SQL query?

    Or suggest another way of showing the groups (the sql dropdown is not required).

    Copy Link
  • Dan Lister 416 posts 1973 karma points c-trib
    Feb 25, 2014 @ 09:13
    Dan Lister
    100

    How about the following? I believe the node type GUID is always the same for Member Groups so it should be safe across different Umbraco instances:

    SELECT [text]
  FROM [umbracoNode]
 WHERE [nodeObjectType] = '366E63B9-880F-4E13-A61C-98069B029728'
    Copy Link
  • Ivan 165 posts 542 karma points
    Feb 25, 2014 @ 09:20
    Ivan
    0

    Perfect, Dan! It works, thank you!

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies