The code editor is available anywhere in Etlworks Integrator where the user can enter SQL, JavaScript, Python or XSLT code.
Code Editor Basics
To access the code editor, click the Open in Editor
button on top of the text field.
By default, the code editor opens in the pop-up window.
It then can be extended to the full screen by clicking the Enter full screen
button and collapsed back to the pop-up window by clicking the Exit full screen
button.
Code Editor Commands
# | Shortcut | Command |
---|---|---|
1 | Ctrl+F |
Search |
2 | Ctrl+Shift+F |
Search & Replace |
3 | Click the Line:Column |
Go to Line |
4 | Click the language selector |
Select color highlighter |
5 | Click the Enter or Exit Full Screen |
Enter or exit full-screen mode |
Code Library and Macros
The code library contains shared and reusable fragments of code in all supported by Etlworks Integrator languages: SQL, JavaScript, Python, shell, and others.
Any user with permission to create and edit flows can access and update the code library.
Macro
Macro is a reusable fragment of code which can be referenced in the code editor as {{LABEL}}.
Accessing Code Library
The code library can be only accessed from the Code Editor. You can hide the code library by turning off the Macros Library switch at the bottom of the code editor popup.
Using Code Library
Add new code fragment (macro)
Click the Add Macro button to add a new macro.
Enter the code, Title, Label, and other [optional] parameters. Save the macro. Once the macro is saved, the Label cannot be edited anymore.
Edit existing code fragment (macro)
Click the Edit macro button (the pen) to edit the code and other editable parameters.
Delete existing code fragment (macro)
Click the Edit macro button (the pen) to open the macro editor. Click the Delete button to delete the macro.
Search code fragments
You can filter existing macros by name, tag, description, and label.
Copy macro to editor
Highlight macro and click Copy macro to editor.
Copy macro body to editor
Highlight macro and click Copy macro body to editor.
Comments
0 comments
Please sign in to leave a comment.