Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Table of Contents

Updating Automatically

Run the following query in Axon to automatically assign permission levels to all Emergency actions(9), Override actions (6), and all else "set/default/etc" to (3).

Code Block
finUniqueActions().map(row => finActionsRewrite(actions, {dis:row->dis, expr: row->expr}, {hvac_finCat: if(row->expr.contains("Emergency")) 9 else if(row->expr.contains("Override")) 6 else 3})[0])

Folio Instructions:

  1. Copy the entire axon query listed above

  2. Go To Folio

  3. Paste and run the axon query into Folio

    hit enter

  4. Verify that all your actions got a category by typing in "finUniqueActions"

     Done!

Note

We recommend placing the above axon query into a "job" so you can avoid any "timeouts" (on larger databases) and so you can have the job saved for anytime you add new points with actions that need permissions. 

Job download file: ActionPermissionsJob.zip 

Job Instructions:

  1. Download the "ActionPermissionsJob.zip" listed directly above

  2. In FIN Stack, click on the "Folio" app (in the right menu)

  3. Select "Restore"

  4. Get out of the Folio app, and go into the "Jobs" app (in the right menu)

  5. Click on the "Action Permissions - Auto" Job

  6. click the "Run" option to begin the job 

    1. Depending on your database's size, this may take anywhere from 10seconds - 4minutes to complete

  7. Verify that all your actions got a permission level set by running "finUniqueActions()" in Folio

    Done!

Updating Manually 

1.First find all sets of unique actions: readAll(point and actions).unique("actions")

2. Use one point from each of the unique sections returned from the first query and plug its id into the query below to get a list of all actions that have the same actions:
readAll(point and actions==read(id==@1eeb0a1b-e62962c7)→actions)

3. Tag the results with a unique tag so you can later do a "clone [action] tag" to all of those unique sets. Repeat 2&3 until you have a unique tag (temporary) for each unique set.

4. If you do not want to get results form step 3, you can automatically find all similar action points and tag them in the same exact step (combine step 2 & 3) by using the following query
: readAll(point and actions==read(id==@1eeb0a1b-e62962c7)->actions).toRecList().map x=> x.diff({testTag}).commit()

5. when your done tagging each point, you can then go and perfect 1 point from each unique set, and use the clone tags tool to clone it to each of the ppints in the same set using the tag you assigned them in steps 3/4. 

6. Repeat step 5 until all points are the way you want them and then remove the unique tags. 

Note

To find unique expressions run this as an example: (you can find the dis by running `findUniqueActions`findUniqueActions: readAll(point and actions).findAll(v => v->actions.contains("Manual Off"))