I want to query from my dynaform at the dorpdown property to get the member groups. I used the codes below in sql part of dropdown:
<membersGroup type="dropdown" required="0" readonly="0" mode="edit" btn_cancel="Cancel">
<![CDATA[SELECT U.USR_UID, U.USR_USERNAME from (USERS U left join GROUP_USER GU on U.USR_UID=GU.USR_UID) left join CONTENT C on
GU.GRP_UID=C.CON_ID where C.CON_VALUE='my group']]>
<en>Members of a particular Group</en>
Unfortunately, nothing appears in dropdown.
I was wondering if you could help me to solve it.