Skip to content

Registry

Switchacct Notes

Query Example

SELECT
`ao`.`slid` AS `slid`,
`oo`.`slid` AS `slid`,
`ao`.`org_id` AS `org_id`,
`org`.`name` AS `name`
FROM `db101`.`ao`
INNER JOIN `db101`.`reg` AS `org` ON((`ao`.`org_id`=`org`.`id`) AND (`org`.`slid`=6))
INNER JOIN `db101`.`oo` AS `oo` ON((`ao`.`oo_id`=`oo`.`id`))
WHERE
(`ao`.`a_id` = 8111)
AND (`ao`.`slid` BETWEEN 600 AND 699)
AND (`oo`.`slid` BETWEEN 600 AND 699)
AND (`org`.`slid` = 6)
AND (`ao`.`org_id` in (8024,8137,8066,14011))
ORDER BY
`ao`.`slid`

Explanation

  • ao.org_id = reg.id and reg.slid = 6
  • ao.oo_id = oo.id
  • ao.a_ip = The Application
  • ao.slid is 600-699
  • oo.slid is 600-699
  • ao.org_id linked to valid slid=6
  • ao.org_id in List of swaccts

Notes

  • You must add each ao to the /Registry so you can switch acct to that app. Then select the app from /Registry and setup the users.