- Wed May 08, 2019 5:22 pm
#824362
Dear Experts,
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>
</membersGroup>
Unfortunately, nothing appears in dropdown.
I was wondering if you could help me to solve it.
Kind Regards
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>
</membersGroup>
Unfortunately, nothing appears in dropdown.
I was wondering if you could help me to solve it.
Kind Regards