Creating and finding records
The JSON configurations below can be pasted into the editor via the Import/Export popup.
Create event-based notification
This example will create a new event-based notification task once a UsrOrder has been changed.
Steps:
- Create Task BusinessObject
- NotificationRef -> NotificationEventBasedDefinition is searched based on the provided code.
- BODefinitionRef -> Is filled with the BOtype of the changing UsrOrder.
- BORef -> Is filled with the syscode of the changing UsrOrder
- PlannedDateTime -> is set with the current systemtime.
- Task BO is saved.

Corresponding configuration:
{"drawflow":{"Home":{"data":{"132":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"133"}]}},"pos_y":329,"pos_x":32,"data":{"checksum":"9aaf429391b82146509d5aebadcc7a6dd9f58c55e7236e562365d30e2e611d85","basebo":"UsrOrder","confversion":"731","appversion":"2.10.0","solutiontype":"SX","undefined":"UsrOrder"},"inputs":{},"name":"Start of flow","html":"","id":132,"class":"start"},"133":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"135"},{"output":"input_1","node":"144"},{"output":"input_1","node":"145"},{"output":"input_1","node":"146"},{"output":"input_1","node":"141"}]}},"pos_y":488.77777777777777,"pos_x":350,"data":{"elementname":"Task"},"inputs":{"input_1":{"connections":[{"node":"132","input":"output_1"}]}},"name":"Create businessobject","html":"","id":133,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.Create"},"134":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"136"}]}},"pos_y":102,"pos_x":1023,"data":{"elementname":"Syscode","dataobject":"@NotificationEventBasedDefinition"},"inputs":{"input_1":{"connections":[{"node":"135","input":"output_1"}]}},"name":"Get field value (Static)","html":"","id":134,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.GetElementStatic"},"135":{"typenode":false,"outputs":{"output_2":{"connections":[]},"output_1":{"connections":[{"output":"input_1","node":"134"}]}},"pos_y":93,"pos_x":732,"data":{"elementname":"NotificationEventBasedDefinition","lookupvalue":"EM001"},"inputs":{"input_1":{"connections":[{"node":"133","input":"output_1"}]}},"name":"Find by lookup (Static)","html":"","id":135,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.FindByLookupStatic"},"136":{"typenode":false,"outputs":{"output_1":{"connections":[]}},"pos_y":67,"pos_x":1319,"data":{"elementname":"NotificationRef","dataobject":"@Task"},"inputs":{"input_1":{"connections":[{"node":"134","input":"output_1"}]}},"name":"Set field value","html":"","id":136,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.SetElement"},"138":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"139"}]}},"pos_y":421,"pos_x":1028,"data":{"elementname":"Syscode","dataobject":"RefBODefinitionUserDefined"},"inputs":{"input_1":{"connections":[{"node":"146","input":"output_1"}]}},"name":"Get field value (Static)","html":"","id":138,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.GetElementStatic"},"139":{"typenode":false,"outputs":{"output_1":{"connections":[]}},"pos_y":394,"pos_x":1319,"data":{"elementname":"BODefinitionRef","dataobject":"@Task"},"inputs":{"input_1":{"connections":[{"node":"138","input":"output_1"}]}},"name":"Set field value","html":"","id":139,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.SetElement"},"141":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"142"}]}},"pos_y":785,"pos_x":740,"data":{"elementname":"Syscode","dataobject":"Target"},"inputs":{"input_1":{"connections":[{"node":"133","input":"output_1"}]}},"name":"Get field value (Static)","html":"","id":141,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.GetElementStatic"},"142":{"typenode":false,"outputs":{"output_1":{"connections":[]}},"pos_y":740,"pos_x":1040,"data":{"elementname":"BORef","dataobject":"@Task"},"inputs":{"input_1":{"connections":[{"node":"141","input":"output_1"}]}},"name":"Set field value","html":"","id":142,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.SetElement"},"143":{"typenode":false,"outputs":{"output_1":{"connections":[]}},"pos_y":1042.5714285714287,"pos_x":1041,"data":{"elementname":"PlannedDateTime","dataobject":"@Task"},"inputs":{"input_1":{"connections":[{"node":"144","input":"output_1"}]}},"name":"Set field value","html":"","id":143,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.SetElement"},"144":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"143"}]}},"pos_y":1058,"pos_x":747,"data":{},"inputs":{"input_1":{"connections":[{"node":"133","input":"output_1"}]}},"name":"System date","html":"","id":144,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.date.SystemDate"},"145":{"typenode":false,"outputs":{"output_1":{"connections":[]}},"pos_y":1238,"pos_x":747,"data":{"dataobject":"@Task"},"inputs":{"input_1":{"connections":[{"node":"133","input":"output_1"}]}},"name":"Save data","html":"","id":145,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.Save"},"146":{"typenode":false,"outputs":{"output_2":{"connections":[]},"output_1":{"connections":[{"output":"input_1","node":"138"}]}},"pos_y":360,"pos_x":732,"data":{"elementname":"RefBODefinitionUserDefined","dataobject":"Target"},"inputs":{"input_1":{"connections":[{"node":"133","input":"output_1"}]}},"name":"Goto element (Static)","html":"","id":146,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.GoToElementStatic"}}}}}
Search businessobject based on 1 unique field
This example will search a Property in Planon based on 1 unique String field. This example is triggered from an insert or update on a person.
Steps:
- Get value of FreeString1 on the person
- Provide the value to the “Find by unique field” function. Provide the (UD)BO systemname which must be searched. In this case a Property.

Corresponding configuration:
{"drawflow":{"Home":{"data":{"2":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"91"}]}},"pos_y":1595.1818181818182,"pos_x":-1304.1818181818182,"data":{"checksum":"02018c07a5c68d15d5e3d9720ae11c8726011fc1a30bb107e2b13662f7c79ef8","basebo":"Person","confversion":"719","appversion":"2.10.0","solutiontype":"SX"},"inputs":{},"name":"Start of flow","html":"","id":2,"class":"start"},"88":{"typenode":false,"outputs":{"output_2":{"connections":[{"output":"input_1","node":"93"}]},"output_1":{"connections":[{"output":"input_1","node":"92"}]}},"pos_y":1594.75,"pos_x":-603,"data":{"fieldname":"Code","elementname":"Property"},"inputs":{"input_1":{"connections":[{"node":"91","input":"output_1"}]}},"name":"Find by unique field","html":"","id":88,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.FindByUniqueField"},"91":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"88"}]}},"pos_y":1597.25,"pos_x":-974,"data":{"elementname":"FreeString1","dataobject":"Target"},"inputs":{"input_1":{"connections":[{"node":"2","input":"output_1"}]}},"name":"Get field value (S)","html":"","id":91,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.GetElementStatic"},"92":{"typenode":false,"outputs":{},"pos_y":1447.25,"pos_x":-60.25,"data":{"errorid":"11374","message":"Property found"},"inputs":{"input_1":{"connections":[{"node":"88","input":"output_1"}]}},"name":"Show warning","html":"","id":92,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning"},"93":{"typenode":false,"outputs":{},"pos_y":1837.25,"pos_x":-56.25,"data":{"errorid":"11374","message":"Property found"},"inputs":{"input_1":{"connections":[{"node":"88","input":"output_2"}]}},"name":"Show warning","html":"","id":93,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning"}}}}}
Search businessobject based on multiple unique fields (Expert mode)
This example is a more complex version of the previous example and will search a Space in Planon based on 2 unique String fields because the Code of a space is not unique. This example assumes a space with a unique code within a property.
This example is triggered from an insert or update on a person.
Steps:
- Search Property based on the Code and a static String ‘BZ’
- If found (upper output) get the value Syscode (systemcode) of the found Property.
- Provide the value to the QuerySearchField and provide the searchfield (PropertyRef) and operator (Equal)
- Add another QuerySearchField which will have a static input value ‘001’ as input and provide the searchfield ‘Code’ and also operator (Equal).
- Both QuerySearchFields will be the input of the Find by query function (expert mode) which will actually execute the query based on the provided systemname of the (UD)BO (Space).

Corresponding configuration:
{"drawflow":{"Home":{"data":{"2":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"94"}]}},"pos_y":836.25,"pos_x":-1363.5,"data":{"checksum":"cee33909edaafc400b1f29a85f4b0b393536d9d28e0c34cfbfc32f13ddbb8f78","basebo":"Person","confversion":"721","appversion":"2.10.0","solutiontype":"SX"},"inputs":{},"name":"Start of flow","html":"","id":2,"class":"start"},"88":{"typenode":false,"outputs":{"output_2":{"connections":[{"output":"input_1","node":"93"}]},"output_1":{"connections":[{"output":"input_1","node":"98"},{"output":"input_1","node":"99"}]}},"pos_y":839,"pos_x":-802.2222222222222,"data":{"fieldname":"Code","elementname":"Property"},"inputs":{"input_1":{"connections":[{"node":"94","input":"output_1"}]}},"name":"Find by unique field","html":"","id":88,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.FindByUniqueField"},"93":{"typenode":false,"outputs":{},"pos_y":1301.888888888889,"pos_x":-434,"data":{"errorid":"11374","message":"Property not found"},"inputs":{"input_1":{"connections":[{"node":"88","input":"output_2"}]}},"name":"Show warning","html":"","id":93,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning"},"94":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"88"}]}},"pos_y":839.1111111111111,"pos_x":-1080.3333333333333,"data":{"staticvalue":"BZ"},"inputs":{"input_1":{"connections":[{"node":"2","input":"output_1"}]}},"name":"Static String","html":"","id":94,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.StaticString"},"95":{"typenode":false,"outputs":{"output_2":{"connections":[{"node":"101","output":"input_1"}]},"output_1":{"connections":[{"node":"102","output":"input_1"}]}},"pos_y":883,"pos_x":280,"data":{"elementname":"Space"},"inputs":{"input_1":{"connections":[{"node":"96","input":"output_1"},{"node":"100","input":"output_1"}]},"input_2":{"connections":[{"node":"100","input":"output_1"}]}},"name":"Find by query","html":"","id":95,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.FindByQuery"},"96":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"95"}]}},"pos_y":670,"pos_x":-127,"data":{"elementname":"PropertyRef","operator":"EQUAL"},"inputs":{"input_1":{"connections":[{"node":"98","input":"output_1"}]}},"name":"QuerySearchField","html":"","id":96,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.QuerySearchField"},"98":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"96"}]}},"pos_y":659,"pos_x":-443,"data":{"elementname":"Syscode","dataobject":"@Property"},"inputs":{"input_1":{"connections":[{"node":"88","input":"output_1"}]}},"name":"Get field value (S)","html":"","id":98,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.GetElementStatic"},"99":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"100"}]}},"pos_y":1013,"pos_x":-435,"data":{"staticvalue":"001"},"inputs":{"input_1":{"connections":[{"node":"88","input":"output_1"}]}},"name":"Static String","html":"","id":99,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.StaticString"},"100":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"95"},{"output":"input_2","node":"95"}]}},"pos_y":1005,"pos_x":-128,"data":{"elementname":"Code","operator":"EQUAL"},"inputs":{"input_1":{"connections":[{"node":"99","input":"output_1"}]}},"name":"QuerySearchField","html":"","id":100,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.element.QuerySearchField"},"101":{"id":101,"name":"Show warning","data":{"errorid":"11374","message":"Space not found"},"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning","html":"","typenode":false,"inputs":{"input_1":{"connections":[{"node":"95","input":"output_2"}]}},"outputs":{},"pos_x":652.25,"pos_y":1058},"102":{"id":102,"name":"Show warning","data":{"errorid":"11374","message":"Space found"},"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning","html":"","typenode":false,"inputs":{"input_1":{"connections":[{"node":"95","input":"output_1"}]}},"outputs":{},"pos_x":645,"pos_y":682.25}}}}}
Search businessobject based on SQL query (Expert mode)
This example is the most complex version of the previous examples and will search a Space in Planon based on 2 unique String fields because the Code of a space is not unique. This example assumes a space with a unique code within a property.
With a SQL statement including a join it is possible to search a space directly including the property and space code.
This example is triggered from an insert or update on a person.
Steps:
- Search space based on the property Code (first input and $1 in the SQL) and a space code (second input and $2 in the SQL)
SQL:
SELECT
Space.Syscode as Syscode
FROM
Space
INNER JOIN Property
ON Space.PropertyRef = Property.Syscode
WHERE
Property.Code = $1 AND
Space.Code = $2

Corresponding configuration:
{"drawflow":{"Home":{"data":{"2":{"typenode":false,"outputs":{"output_1":{"connections":[{"output":"input_1","node":"94"},{"node":"104","output":"input_1"}]}},"pos_y":836.25,"pos_x":-1363.5,"data":{"checksum":"bbc39e616ce4427f162ba1e2da866328f909cffb69c560ed5d0f7035ed2f924a","basebo":"Person","confversion":"722","appversion":"2.10.0","solutiontype":"SX"},"inputs":{},"name":"Start of flow","html":"","id":2,"class":"start"},"94":{"typenode":false,"outputs":{"output_1":{"connections":[{"node":"103","output":"input_1"}]}},"pos_y":774,"pos_x":-1060.75,"data":{"staticvalue":"BZ"},"inputs":{"input_1":{"connections":[{"node":"2","input":"output_1"}]}},"name":"Static String","html":"","id":94,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.StaticString"},"101":{"typenode":false,"outputs":{},"pos_y":1124.25,"pos_x":-96,"data":{"errorid":"11374","message":"Space not found"},"inputs":{"input_1":{"connections":[{"node":"103","input":"output_2"}]}},"name":"Show warning","html":"","id":101,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning"},"102":{"typenode":false,"outputs":{},"pos_y":720.5,"pos_x":-100.25,"data":{"errorid":"11374","message":"Space found"},"inputs":{"input_1":{"connections":[{"node":"103","input":"output_1"}]}},"name":"Show warning","html":"","id":102,"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.notification.Warning"},"103":{"id":103,"name":"Execute query","data":{"dataobject":"","sql":"SELECT\n\tSpace.Syscode as Syscode\nFROM\n\tSpace\n\tINNER JOIN Property\n\t\tON Space.PropertyRef = Property.Syscode\nWHERE\n\tProperty.Code = $1 AND \n\tSpace.Code = $2","elementname":"SpaceQuery"},"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.query.ExecuteQuery","html":"","typenode":false,"inputs":{"input_1":{"connections":[{"node":"94","input":"output_1"},{"node":"104","input":"output_1"}]},"input_2":{"connections":[{"node":"104","input":"output_1"}]}},"outputs":{"output_1":{"connections":[{"node":"102","output":"input_1"}]},"output_2":{"connections":[{"node":"101","output":"input_1"}]}},"pos_x":-734.25,"pos_y":945.5},"104":{"id":104,"name":"Static String","data":{"staticvalue":"001"},"class":"planonsoftware.apps.configurablebusinessrule.logic.functions.implementations.StaticString","html":"","typenode":false,"inputs":{"input_1":{"connections":[{"node":"2","input":"output_1"}]}},"outputs":{"output_1":{"connections":[{"node":"103","output":"input_1"},{"node":"103","output":"input_2"}]}},"pos_x":-1063,"pos_y":1011.5}}}}}