Home

Plugin : Item book

Author:Rex.Rainbow

Download

Properties

Sub domain

  • Sub domain for this function.

Actions

Convert - Item list

Action:Set key name

  • Set key name of item list.
    • Table ( number or string ) : Key of table ID.
    • Item ( number or string ) : Key of item ID.

Domain

Action:Set sub domain

  • Set sub domain ref.
    • Sub domain ( string ) : Sub domain for this function.

Load

Action:Clean result table

  • Clean result table.
    • Table ( number or string ) : Table ID. Set to "" to clean all tables.

Load - Signle query

Action:Get items by "In Range"

  • Get items by single condition-In Range with count limit in a table.
    • Table ( number or string ) : Table ID.
    • Key ( number or string ) : The name of the key.
    • Start ( number or string ) : Start value.
    • End ( number or string ) : End value.
    • Limit ( Combo ) : Limit types.
      • Options : ["Limit to first","Limit to last"]
    • Count ( number ) : Limit count. Set to (-1) to pick all queried items.
    • Tag ( string ) : A tag, to distinguish between different requests.

Action:Get items by comparison

  • Get items by single condition with count limit in a table.
    • Table ( number or string ) : Table ID.
    • Key ( number or string ) : The name of the key.
    • Comparison ( Combo ) : Comparison types.
      • Options : ["Equal to","Greater than or Equal to","Less than or Equal to"]
    • Value ( number or string ) : Compared value.
    • Limit ( Combo ) : Limit types.
      • Options : ["Limit to first","Limit to last"]
    • Count ( number ) : Limit count. Set to (-1) to pick all queried items.
    • Tag ( string ) : A tag, to distinguish between different requests.

Load - queue

Action:Start new request queue

  • Start new request queue.
    • Tag ( string ) : A tag, to distinguish between different requests.

Action:Process request queue

  • Process all requests in queue.

Load - table/item

Action:Load item

  • Load an item or a table, or all tables.
    • Table ( number or string ) : Table ID. Set to "" to load all tables.
    • Item ( number or string ) : Item ID. Set to "" to load all items in the table.
    • Tag ( string ) : A tag, to distinguish between different requests.

On disconnected - Enumeration

Action:Remove key

  • Remove key on disconnected.
    • Table ( number or string ) : Table ID. Set to "" to remove all tables.
    • Item ( number or string ) : Item ID. Set to "" to remove all items in the table.
    • Key ( number or string ) : The name of the key. Set to "" to remove all keys in the item.

Action:Set server timesetamp

  • Set to server timestamp on disconnected.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.

Action:Set server timesetamp

  • Set value on disconnected.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:Set boolean value

  • Set boolean value on disconnected.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.
    • Boolean ( Combo ) : Boolean value.
      • Options : ["false","true"]

Action:Set server timesetamp

  • Set JSON value on disconnected.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.
    • JSON ( string ) : The JSON value to set.

Action:Cancel

  • Cancel all handlers of disconnected.
    • Table ( number or string ) : Table ID. Set to "" to remove all tables.
    • Item ( number or string ) : Item ID. Set to "" to remove all items in the table.
    • Key ( number or string ) : The name of the key. Set to "" to remove all keys in the item.

On disconnected - Tree

Action:Remove key

  • Remove key on disconnected.
    • Key ( number or string ) : The name of the key.

Action:Set server timesetamp

  • Set to server timestamp on disconnected.
    • Key ( number or string ) : The name of the key.

Action:Set value

  • Set value on disconnected.
    • Key ( number or string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:Set boolean value

  • Set boolean value on disconnected.
    • Key ( number or string ) : The name of the key.
    • Boolean ( Combo ) : Boolean value.
      • Options : ["false","true"]

Action:Set JSON

  • Set JSON value on disconnected.
    • Key ( number or string ) : The name of the key.
    • JSON ( string ) : The JSON value to set.

Action:Cancel all handlers

  • Cancel all handlers of disconnected.
    • Key ( number or string ) : The name of the key.

Prepare - Enumeration

Action:Set value

  • Set number or string value.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:Set boolean value

  • Set boolean value.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.
    • Boolean ( Combo ) : Boolean value.
      • Options : ["false","true"]

Action:Remove

  • Remove key or item or table.
    • Table ( number or string ) : Table ID. Set to "" to remove all tables.
    • Item ( number or string ) : Item ID. Set to "" to remove all items in the table.
    • Key ( number or string ) : The name of the key. Set to "" to remove all keys in the item.

Action:Set server timesetamp

  • Set to server timestamp.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.

Action:Set JSON

  • Set JSON value.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : Item ID.
    • Key ( number or string ) : The name of the key.
    • JSON ( string ) : The JSON value to set.

Prepare - Tree

Action:Set value

  • Set number or string value.
    • Key ( number or string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:Set boolean value

  • Set boolean value.
    • Key ( number or string ) : The name of the key.
    • Boolean ( Combo ) : Boolean value.
      • Options : ["false","true"]

Action:Remove key

  • Remove key.
    • Key ( number or string ) : The name of the key.

Action:Remove all

  • Remove all keys or items.

Action:Set server timesetamp

  • Set to server timestamp.
    • Key ( number or string ) : The name of the key.

Action:Set JSON

  • Set JSON value.
    • Key ( number or string ) : The name of the key.
    • JSON ( string ) : The JSON value to set.

Save

Action:Update

  • Update book.

Expressions

Convert

Expression:AsItemList

  • Convert table to item list (JSON string), optional parameters are (tableID, itemID).

For Each

Expression:CurItemID

  • Get current itemID in a For Each loop.

Expression:CurKey

  • Get current key in a For Each loop.

Expression:CurValue

  • Get current value in a For Each loop.

Expression:CurItemContent

  • Get current content in JSON stringin in a For Each loop. Add 2nd parameter for specific key, 3rd parameter for default value if this key is not existed.

Item count

Expression:ItemCount

  • Get items count of all tables or add table ID in 1st parameter to get items count in that table.

ItemID

Expression:GenerateKey

  • Generate new key from push action.

Expression:LastGeneratedKey

  • Get last generate a key from push action.

Load

Expression:LastTableID

  • Get last tableID of request.

Expression:LastItemID

  • Get last itemID of request.

Random

Expression:RandomBase32

  • Get a random base32 string.
    • Length ( number ) : Length of string.

Expression:LastRandomBase32

  • Get last random base32 string.

Reference

Expression:Ref

  • Get renerence in book, optional parameters are (tableID, itemID, key).

Value

Expression:At

  • Get value in book, optional parameters are (tableID, itemID, key, defaultValue).

Conditions

Load

Condition:For each itemID

  • Repeat the event for each itemID of load result in a table.
    • Table ( number or string ) : Table ID.
    • Order ( Combo ) : Order of itemID.
      • Options : ["descending","ascending","logical descending","logical ascending"]

Condition:For each key

  • Repeat the event for each key of a item of load result in a table.
    • Table ( number or string ) : Table ID.
    • Item ( number or string ) : ID of item.

Condition:Table is empty

  • Return true if no item in a table.
    • Table ( number or string ) : Table ID.

On disconnected - Tree

Condition:Remove on disconnected

  • Remove node on disconnected.

Condition:Cancel all handlers of disconnected

  • Cancel all handlers of disconnected.

Prepare - Tree structure

Condition:Table node

  • Add a table node.
    • Table ( number or string ) : Table ID.

Condition:Item node

  • Add a item node.
    • ItemID ( number or string ) : ItemID

Request

Condition:On request complete

  • Triggered when request current item complete.
    • Tag ( number or string ) : A tag, to distinguish between different save requests.

Save

Condition:On update complete

  • Triggered when update book complete.

Condition:On update error

  • Triggered when update book error.