{"id":11606,"date":"2021-07-27T09:40:43","date_gmt":"2021-07-27T08:40:43","guid":{"rendered":"https:\/\/sdna.lu\/?p=11606"},"modified":"2022-12-18T11:06:23","modified_gmt":"2022-12-18T10:06:23","slug":"query-update-usergroup","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=11606","title":{"rendered":"Query: Update UserGroup"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Update UserGroup from Group after activation of the new rights<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Update [UserGroup] Set [UserGroup].[Type] = [Group].[Type], [UserGroup].[DBGroupId] = [Group].[DBGroupId], [UserGroup].[DBId] = [Group].[DBId]<br>From [UserGroup] Inner join [Group] On [UserGroup].[GroupId] = [Group].[Id]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Update UserGroup from Group after activation of the new rights Update [UserGroup] Set [UserGroup].[Type] = [Group].[Type], [UserGroup].[DBGroupId] = [Group].[DBGroupId], [UserGroup].[DBId] = [Group].[DBId]From [UserGroup] Inner join [Group] On [UserGroup].[GroupId] = [Group].[Id]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[487],"tags":[],"class_list":["post-11606","post","type-post","status-publish","format-standard","hentry","category-query"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11606"}],"version-history":[{"count":1,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11606\/revisions"}],"predecessor-version":[{"id":11607,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11606\/revisions\/11607"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}