As of Biotics 5.11.8, Saved Maps are per user and cannot be shared (BX-3133). To get around this, you can copy a Saved Map for use by another user using the following workaround. The caveat is that if a user updates the Saved Map, the copy will not reflect those changes. A true shared Saved Map would include a single copy of the Saved Map, allowing all users to see the changes to the Map. So, the workaround can be seen as a benefit or deficit, depending on your needs.
- First, determine the SECURITY_USERS_ID of the person who will get the copy by running the following query in QueryBuilder, replacing Pepe LePieu with the appropriate user's name:
select "User_ID" from security_users_vw where "Full Name" = 'Pepe LePieu' - Next, replace 600199 with the User_ID returned from the query above and Rock Creek Park with the name of the Saved Map to copy:
Insert into MAP_SAVED_STATE (MAP_SAVED_STATE_ID,SECURITY_USERS_ID,NAME,DESCRIPTION,DATE_SAVED,PUBLIC_IND,MAP_CENTER_POINT,SCALE_LEVEL,LAYERS_JSON) (select getnextseq('MAP_SAVED_STATE'),600199, NAME, DESCRIPTION, DATE_SAVED, PUBLIC_IND, MAP_CENTER_POINT, SCALE_LEVEL, LAYERS_JSON FROM MAP_SAVED_STATE WHERE NAME='Rock Creek Park'); - Log into your favorite third-party tool (SQL Plus, SQL Developer, Tora, Toad...), as the biotics_dlink user, to run the insert statement.
- Commit; the change.
- Have the user refresh their Map and the Saved Map will now be available to them.