https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Retrieve_Group_membership 2026-06-13T19:41:33Z Revision history for this page on the wiki MediaWiki 1.45.3 https://wiki.smt-x.com/index.php?title=Retrieve_Group_membership&diff=867&oldid=prev 2024-02-20T13:11:12Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:11, 20 February 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l23">Line 23:</td> <td colspan="2" class="diff-lineno">Line 23:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This will return the group names form the groups listed.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This will return the group names form the groups listed.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">dample </del>form :</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Sample </ins>form: <ins style="font-weight: bold; text-decoration: none;">https://dev.ssp7.smt-x.com/Forms/Admin/formDetail.aspx</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Webservice: https://dev.ssp7.smt-x.com/Common/Admin/WsCallAddEdit.aspx?genericid=403</ins></div></td></tr> </table>

Smtxwiki https://wiki.smt-x.com/index.php?title=Retrieve_Group_membership&diff=866&oldid=prev 2024-02-20T13:06:04Z

<p>Created page with &quot;If you want to know in a form, to which groups a user belongs,use this Query in a webservice: SELECT [Name] FROM [PersonGroup] WHERE [Id] IN (SELECT [PersonGroupId] FROM [PersonGroupPerson] WHERE [PersonId] IN (SELECT [Id] FROM [Person] WHERE [Email] = #EMAIL#)) AND [Name] IN ( &#039;03. Anesthesiology (PD)&#039;, &#039;04. Biobank (PD)&#039;, &#039;05. Cardiologie (PD - OD)&#039;, &#039;06. DPO (PD)&#039;, &#039;07. Gastro-enterology (PD)&#039;, &#039;08. Information management (PD)&#039;, &#039;09. Laboratory (PD)&#039;, &#039;10. Legal depa...&quot;</p> <p><b>New page</b></p><div>If you want to know in a form, to which groups a user belongs,use this Query in a webservice:<br /> <br /> SELECT [Name] FROM [PersonGroup]<br /> WHERE [Id] IN (SELECT [PersonGroupId] FROM [PersonGroupPerson] WHERE [PersonId] IN (SELECT [Id] FROM [Person] WHERE [Email] = #EMAIL#))<br /> AND [Name] IN (<br /> &#039;03. Anesthesiology (PD)&#039;,<br /> &#039;04. Biobank (PD)&#039;,<br /> &#039;05. Cardiologie (PD - OD)&#039;,<br /> &#039;06. DPO (PD)&#039;,<br /> &#039;07. Gastro-enterology (PD)&#039;,<br /> &#039;08. Information management (PD)&#039;,<br /> &#039;09. Laboratory (PD)&#039;,<br /> &#039;10. Legal department (PD)&#039;,<br /> &#039;11. Neurology (PD)&#039;,<br /> &#039;12. Nuclear medicine (PD)&#039;,<br /> &#039;13. Pathology (PD)&#039;,<br /> &#039;14. Pharmacy (PD)&#039;,<br /> &#039;15. Radiology (PD)&#039;,<br /> &#039;16. HR department&#039;<br /> )<br /> <br /> <br /> This will return the group names form the groups listed.<br /> <br /> dample form :</div>

Smtxwiki