{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"7ff244ba-ee84-4d23-8cd1-f9c4e822bb0a"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"3b5cbb4d-24b9-4d28-ab2e-7aff04805b0a"}},{"type":"paragraph","content":[{"text":"This guide gives an overview of the functionality in the Mail Template configuration. It is an extension of the already existing mail documentation ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://digizuite.atlassian.net/wiki/spaces/DD/pages/3000406132"}},{"text":" showing how emails can be triggered by automations. ","type":"text"}]},{"type":"paragraph","content":[{"text":"If you need a template to use for general mail notifications, you can copy-paste the automation and mail template from the example:","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Example","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":834,"id":"db706ced-c509-4971-88af-988ccaf90e58","collection":"contentId-3412557852","type":"file","height":1054}}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Mail template","type":"text"}]},{"type":"paragraph","content":[{"text":"The template for the above mail notification can be found here.","type":"text"}]},{"type":"paragraph"},{"type":"codeBlock","content":[{"text":"{{include 'html-header-start'}}\n\nThese assets are expiring within the next 14 days.\n\n{{include 'html-header-end'}}\n\nThe following assets in the Saether DAM are expiring within the next 14 days\n\n{{include 'standard-header'}}\n\n\n

Hi {{receiver.name | html.escape}},

There {{if data.assets.size==1}}\n is an asset\n {{ else }}\n {{if data.assets.size < 100 }}\n are {{ data.assets.size }} assets\n {{ else }}\n are more than 100 assets\n {{ end }}\n {{ end }} \n about to expire within the next 14 days. Please review and take the appropriate action.

\n
\n
\n\n\n\n{{ for id in data.assets limit:12}}\n \n $\"{{$ \n \n\n{{ end }}\n\n
\n{{ if data.assets.size > 12}}\n

+ more.

\n{{ end }}\n
\n\n\n\n \n \n \n

\n When an asset expires, it will no longer be in the digizuite Media Manager. \n If you click on the thumbnails you can go to the assets, or you can navigate to the DAM and utilize the filtering.\n
\n

\n This is an automated email, please do not respond.\n

\n
\n\n\n{{include 'standard-footer'}}","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Automation","type":"text"}]},{"type":"paragraph","content":[{"text":"Input: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cron Input: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://www.freeformatter.com/cron-expression-generator-quartz.html"}},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Find Assets","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Remember to limit this as much as possible. e.g by not including already expired assets etc. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The dates on which you search can be adapted in the Get Date config. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Negative integers for offset will be in the past. Positive will be in the future. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"＠from always has to be smaller than ＠to. ","type":"text"}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Send Mail (Receiver and template name)","type":"text"}]}]}]},{"type":"expand","attrs":{"title":"Standard automation to send mail each day at 8.00 CET"},"content":[{"type":"codeBlock","content":[{"text":"action \"Send email\" {\n type = \"Send email to member\"\n needs = \"Join Strings\"\n receiver_is_group = \"false\"\n receiver_id = \"23\"\n template_name = \"TestTemplate\"\n config_version_id = \"0\"\n mail_data = \"(assets),(@assets)\"\n}\n\naction \"Join Strings\" {\n type = \"Join Strings\"\n needs = \"Non Empty search result\"\n strings = \"@AssetIds\"\n separator = \",\"\n result = \"@assets\"\n}\n\ntrigger \"CronScheduleTrigger\" {\n type = \"CronScheduleTrigger\"\n resolves = \"Send email\"\n schedule = \"0 0 8 ? * * *\"\n misfire_instruction = \"fireoncenow\"\n identity = \"ExpiryNotification\"\n}\n\naction \"Find assets\" {\n type = \"Find assets\"\n search_request = \"[{\\\"searchKey\\\":\\\"27053d69-a523-4ba8-9e58-55f521ed66a1\\\",\\\"dateRange\\\":{\\\"from\\\":{\\\"type\\\":\\\"variable\\\",\\\"key\\\":\\\"@from\\\"},\\\"to\\\":{\\\"type\\\":\\\"variable\\\",\\\"key\\\":\\\"@to\\\"}}}]\"\n max_result_count = \"101\"\n asset_sort_order = \"ascending\"\n asset_ids = \"@AssetIds\"\n asset_item_ids = \"@AssetItemIds\"\n needs = [\"Get today\", \"Get + 14 days\"]\n}\n\naction \"Get today\" {\n type = \"Get Current Date\"\n offset = \"0\"\n result = \"@from\"\n}\n\naction \"Get + 14 days\" {\n type = \"Get Current Date\"\n offset = \"1209600\"\n result = \"@to\"\n}\n\nfilter \"Non Empty search result\" {\n type = \"Is Array Empty\"\n needs = \"Find assets\"\n array = \"@AssetIds\"\n negate = \"true\"\n}\n","type":"text"}]},{"type":"paragraph"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Prerequisites","type":"text"}]},{"type":"paragraph","content":[{"text":"As a precondition to following the walkthrough, it is expected that the reader has a basic understanding of the following concepts:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"HTML","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Emails","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Basic programming and control structures","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"The templates are store under the ConfigManager (settings in MM):","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":922,"id":"79233249-2833-42af-b754-5b3a10168231","collection":"contentId-3412557852","type":"file","height":284}}]},{"type":"paragraph","content":[{"text":"Scribans own documentation can be found here: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://github.com/scriban/scriban/blob/master/doc/language.md"}},{"text":" and can be used for additional examples. ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Preparing the mail template","type":"text"}]},{"type":"paragraph","content":[{"text":"The first thing we will take a look at is the email template. We start out with a pretty simply template that doesn’t do a whole lot, but let us go over how it works either way.","type":"text"}]},{"type":"codeBlock","content":[{"text":"{{include 'html-header-start'}}\n\nHere is what happened since last time!\n\n{{include 'html-header-end'}}\n\nHere is what happened since last time!\n\n

Hi {{receiver.name | html.escape}},

Here is what was uploaded since yesterday

","type":"text"}]},{"type":"paragraph","content":[{"text":"On line 1 you will notice the double curly braces ","type":"text"},{"text":"{{","type":"text","marks":[{"type":"code"}]},{"text":", these denote that some special code should be run, and that it is not just html that to be printed directly into the final mail. In this case we are using a special Scriban structure called an ","type":"text"},{"text":"include","type":"text","marks":[{"type":"code"}]},{"text":". Specifically we are including another mail template here. This allows us to standardize somewhat how mails looks, and allows us to avoid having to repeat ourselves. On line 3 we just output a title for the mail client to display. On line 5 we include another template. Next on line 7 we have the pre-header, which is displayed by some email clients as the first part of the body, before you open the email. The pre-header is not displayed in the actual mail. On line 9 we say hello to the receiver of the email. There are certain parts that are always loaded by the mail system. Specifically the ","type":"text"},{"text":"receiver","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"sender","type":"text","marks":[{"type":"code"}]},{"text":". Important to notice is also that we use a pipe operator to call the ","type":"text"},{"text":"html.escape","type":"text","marks":[{"type":"code"}]},{"text":" function, to prevent html injection. Whenever you output data you don’t control, always remember to run it through ","type":"text"},{"text":"html.escape","type":"text","marks":[{"type":"code"}]},{"text":". On line 10 we just output yet more text for the user to see.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Displaying a simple table","type":"text"}]},{"type":"paragraph","content":[{"text":"Next we need to start outputting out assets. As this is just a simple walkthrough, we will not focus on styling the email, and will just output the assets in a simple table.","type":"text"}]},{"type":"paragraph","content":[{"text":"First thing to do is setup the basic table structure:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n\n\n \n \n \n \n\n\n\n\n...\n\n\n

AssetId	Asset title	Thumbnail	Status

","type":"text"}]},{"type":"paragraph","content":[{"text":"If you have working with html before, there really shouldn’t be anything surprising about this structure. We simply create a table with 4 rows, ","type":"text"},{"text":"AssetId","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"Asset title","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"Thumbnail","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"Status","type":"text","marks":[{"type":"code"}]},{"text":". The rest is just basic layout for us to put out main output in.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Looping through our assets","type":"text"}]},{"type":"paragraph","content":[{"text":"Then we get to the interesting parts, we need to actually output some data. To do this we insert a for loop:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n{{for assetId in data.assetIds}}\n\n...\n\n{{end}}\n","type":"text"}]},{"type":"paragraph","content":[{"text":"This will run once for every ","type":"text"},{"text":"assetId","type":"text","marks":[{"type":"code"}]},{"text":" in ","type":"text"},{"text":"data.assetIds","type":"text","marks":[{"type":"code"}]},{"text":". How does data get into ","type":"text"},{"text":"data.assetIds","type":"text","marks":[{"type":"code"}]},{"text":", you ask? This is handled by automations, which we will get to later in this walkthrough. For now, lets continue looking at how we can output data.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Conditioning","type":"text"}]},{"type":"paragraph","content":[{"text":"You can add conditions on the data to e.g. show alternative text depending on the length of the array. ","type":"text"}]},{"type":"paragraph"},{"type":"codeBlock","content":[{"text":"

\n
","type":"text"}]},{"type":"paragraph","content":[{"text":"Above examples shows three alternative text depending on the number of assets that are about to expire: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"1 result: ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":689,"id":"c91e464b-6b93-4dc0-9158-cec7e8ae8cec","collection":"contentId-3412557852","type":"file","height":675}},{"type":"caption","content":[{"text":"1 search result","type":"text"}]}]},{"type":"paragraph"},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Between 1 and 99 results","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":689,"id":"5f790dcf-c30c-4974-a2d0-6ebba3481136","collection":"contentId-3412557852","type":"file","height":662}},{"type":"caption","content":[{"text":"5 search results","type":"text"}]}]},{"type":"paragraph"},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"More than 100 results","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":689,"id":"7af7ee3d-4742-4cf2-a1e4-ee0b1044d2d9","collection":"contentId-3412557852","type":"file","height":689}},{"type":"caption","content":[{"text":"More than 100 search results","type":"text"}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Showing the asset id","type":"text"}]},{"type":"paragraph","content":[{"text":"First thing we wanted to display was the asset id. We already have the asset id available from the loop, so we can output it directly:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n{{for assetId in data.assetIds}}\n\n \n {{assetId}}\n \n ...\n\n{{end}}\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"As seen on line 5, all we need to do is to write ","type":"text"},{"text":"{{assetId}}","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Showing the asset title","type":"text"}]},{"type":"paragraph","content":[{"text":"Next we want to output the title of the asset. As can be seen in the auto-generated documentation below the mail template editor, there is a function called ","type":"text"},{"text":"get_title","type":"text","marks":[{"type":"code"}]},{"text":", that takes an asset id, and returns string. Calling it is as simple as this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n{{for assetId in data.assetIds}}\n\n ...\n \n {{digizuite.get_title(assetId) | html.escape}}\n \n ...\n\n{{end}}\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"All the custom functions Digizuite makes available can be found on the ","type":"text"},{"text":"digizuite","type":"text","marks":[{"type":"code"}]},{"text":" object in the template. So in this case to call the function and get the title is as simple as ","type":"text"},{"text":"{{digizuite.get_title(assetId)}}","type":"text","marks":[{"type":"code"}]},{"text":", and we simply pass the asset id as an argument to the function. As this is user provided input, we have to remember to escape it using ","type":"text"},{"text":"html.escape","type":"text","marks":[{"type":"code"}]},{"text":", as mentioned earlier.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Showing a thumbnail of the asset","type":"text"}]},{"type":"paragraph","content":[{"text":"Next we want to display a thumbnail of the asset. To do this we have a function ","type":"text"},{"text":"get_asset_thumbnail_url","type":"text","marks":[{"type":"code"}]},{"text":", which again takes an asset id. So we simply need to do this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n{{for assetId in data.assetIds}}\n\n ...\n \n

\n \n ...\n\n{{end}}\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"And we will get a nice small thumbnail. Notice how we don’t need to escape anything here. The function already returns a well formed URL, so it won’t cause any issues being included in the html like this.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Adding a link to the thumbnail","type":"text"}]},{"type":"paragraph","content":[{"text":"Next we want to thumbnail to actually take us to that asset in the Media Manager. For this we have a convenience function ","type":"text"},{"text":"get_link_to_asset_preview","type":"text","marks":[{"type":"code"}]},{"text":", which takes a ","type":"text"},{"text":"baseUrl","type":"text","marks":[{"type":"code"}]},{"text":" to the Media Manager and an asset id. Because we want to entire image to be clickable, we wrap the entire thumbnail in an ","type":"text"},{"text":"a","type":"text","marks":[{"type":"code"}]},{"text":" tag with a link to the image:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n{{for assetId in data.assetIds}}\n\n ...\n \n \n

\n \n \n ...\n\n{{end}}\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"If you have multiple Media Managers installed, you need to enter the link to the correct portal. You can use the config version id of the template to control this. Notice also that we again don’t need extra escaping, since this is again a well formed URL already.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Displaying the asset status","type":"text"}]},{"type":"paragraph","content":[{"text":"As the last thing in the template we want to include the status of the asset. To do this we need to load the value of a metadata field. During this part we will also see how to do some even more advanced logic to conditionally display output in the template. The Status field is a ","type":"text"},{"text":"combo","type":"text","marks":[{"type":"code"}]},{"text":" metafield, so we need to use the ","type":"text"},{"text":"get_combo_meta_field_value","type":"text","marks":[{"type":"code"}]},{"text":" function. And as can be seen from the documentation, this function takes an ","type":"text"},{"text":"assetId","type":"text","marks":[{"type":"code"}]},{"text":", which we already have available from the loop, and a ","type":"text"},{"text":"metaFieldLabelId","type":"text","marks":[{"type":"code"}]},{"text":". This is the label id of the metafield, which also means it is language specific. On my system the ","type":"text"},{"text":"labelId","type":"text","marks":[{"type":"code"}]},{"text":" for the status field in English is ","type":"text"},{"text":"51550","type":"text","marks":[{"type":"code"}]},{"text":", so we will use that as an example. On your system it is likely to be different. Last thing we will notice about the function is that it returns a ","type":"text"},{"text":"ComboValue","type":"text","marks":[{"type":"code"}]},{"text":", not a string like the other functions we used above. That means we have to extract a specific property from the ","type":"text"},{"text":"ComboValue","type":"text","marks":[{"type":"code"}]},{"text":" and display that. Additionally we want to handle the asset not having a status at all (Usually you have an automation ensuring the asset always have a status, but for the sake of example, we will take a look at how to check)","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n{{for assetId in data.assetIds}}\n\n ...\n \n {{status = digizuite.get_combo_meta_field_value(assetId, 51550)}}\n\n {{if status == null}}\n Asset has no status\n {{else}}\n {{status.label | html.escape}}\n {{end}}\n \n\n{{end}}\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"On line 6 you can see us calling the ","type":"text"},{"text":"get_combo_meta_field_value","type":"text","marks":[{"type":"code"}]},{"text":" function, passing in the ","type":"text"},{"text":"assetId","type":"text","marks":[{"type":"code"}]},{"text":" from the loop, and the ","type":"text"},{"text":"labelId","type":"text","marks":[{"type":"code"}]},{"text":" of the status metafield, and saving the result in the ","type":"text"},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":" variable. Next we wanted to handle the case of the asset not yet having a status at all. We do this by using an ","type":"text"},{"text":"if","type":"text","marks":[{"type":"code"}]},{"text":" statement, outputting ","type":"text"},{"text":"Asset has no status","type":"text","marks":[{"type":"code"}]},{"text":" if there is no status, and ","type":"text"},{"text":"{{status.label | html.escape}}","type":"text","marks":[{"type":"code"}]},{"text":" if there is. If you look in the documentation for the ","type":"text"},{"text":"ComboValue","type":"text","marks":[{"type":"code"}]},{"text":" type, you can see it has a ","type":"text"},{"text":"label","type":"text","marks":[{"type":"code"}]},{"text":" property. And again we remember to escape the user input, just to be on the safe side.","type":"text"}]},{"type":"paragraph","content":[{"text":"This concludes everything we need to do for the mail template. Make sure to save it, and put note down the name you gave the template, since we will need it for configuring the automation.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Sender of email","type":"text"}]},{"type":"paragraph","content":[{"text":"By default the sender of the email is shown as System Admin with an image of John Burke. The image only shows for internal digizuite mails, however the name (System Admin) is seen by all receivers of the email. It can be adapted by changing the name of the System Admin user. Be careful only to change the First and Last name as changing the System Admin login would potentially break the DAM. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":480,"id":"0a02f14b-3ad4-4c6e-91aa-83264863977f","collection":"contentId-3412557852","type":"file","height":129}},{"type":"caption","content":[{"text":"Default sender","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":497,"id":"782e1c9f-1f99-4614-97c2-0c3b18c0da8f","collection":"contentId-3412557852","type":"file","height":161}},{"type":"caption","content":[{"text":"Senders name changed to Digizuite DAM","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Using the sender-user","type":"text"}]},{"type":"paragraph","content":[{"text":"In the mail text you can reference the sender as in the one who triggered the action to send this mail (i.e. if a user send the mail due to a collection share). However, if the mail is triggered by an automation, then this will default to System Admin and is therefore not recommended to use. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"{{sender.name | html.escape}}\n({{sender.email_address | html.escape}}) has invited you to join a shared collection in Digizuite™ Media Manager called “{{data.collection_name | html.escape}}”. Enjoy!","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Good practices","type":"text"}]},{"type":"paragraph","content":[{"text":"This section lists some recommendations on good practices with the mail template. It is heavily suggested that you use the below recommendations as it limits toll on the system, makes the templates execute faster and provides a nicer overview for the receiver. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Check that result is not-empty","type":"text"}]},{"type":"paragraph","content":[{"text":"Users generally don’t want to be notified if nothing happens, so it is a good idea to check that the result returned by the Find Asset in the automation is not-empty before triggering the mail template. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Improving the performance of the mail template","type":"text"}]},{"type":"paragraph","content":[{"text":"If you run your mail template by loading 10 metadata fields for each assets, and loading 500 assets, it will of course take a bit of time, and put quite a bit of load on your dam center. To optimize your template we provide certain helper functions that will cause data to be bulk preloaded, which is must faster than loading each value as it is necessary.","type":"text"}]},{"type":"paragraph","content":[{"text":"At the time of writing Digizuite provides 3 functions for this:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"preload_title","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"queue_meta_field_loads_by_item_guid","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"queue_meta_field_loads_by_label_id","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph","content":[{"text":"Each of these functions takes the assets to preload. You just need to call them once in the start of the mail, and they are safe to call multiple times.","type":"text"}]},{"type":"paragraph","content":[{"text":"preload_title","type":"text","marks":[{"type":"code"}]},{"text":" is also recommended to use when using the ","type":"text"},{"text":"get_link_to_asset_preview","type":"text","marks":[{"type":"code"}]},{"text":" function, since it requires the title of the asset to work.","type":"text"}]},{"type":"paragraph","content":[{"text":"Using these functions properly can make almost any mail template execute instantly, with much less load on the dam center.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Iteration limits","type":"text"}]},{"type":"paragraph","content":[{"text":"Scriban only allows each loop to run a maximum of 1000 times, after which it will stop execution and throw an error. To get around that you can use a limiting operator like this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"for assetId in data.assetIds limit:200","type":"text"}]},{"type":"paragraph","content":[{"text":"to only display the first 200 items.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is also generally recommended that you keep the limit low, to both allow the template to execute faster, and to save the receiver some pain, since their mail client won’t start crying from too much mail.","type":"text"}]},{"type":"paragraph","content":[{"text":"If you cap the items send in the mail template, you might as well also cap the search result in the automation. You can do this by adding the Mac Result Count to be 1 more than the cap in the mail template","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":305,"id":"af8dd94d-04b2-425b-b145-cbd7a88b4c28","collection":"contentId-3412557852","type":"file","height":202}}]},{"type":"paragraph","content":[{"text":"You can always add a clause in the mail template like: ","type":"text"}]},{"type":"codeBlock","content":[{"text":"{{ if data.assets.size > 100}}\n There are more than 100 assets about to expire.\n{{ end }}","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Html escaping","type":"text"}]},{"type":"paragraph","content":[{"text":"It has been mentioned several times in this document, but make sure to escape any user input using ","type":"text"},{"text":"| html.escape","type":"text","marks":[{"type":"code"}]},{"text":", otherwise you might introduce security issues. When in doubt, escape the value.","type":"text"}]},{"type":"paragraph","content":[{"text":" E.g.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"{{sender.email_address | html.escape}}","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"{{sender.name | html.escape}}","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"{{receiver.name | html.escape}}","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"{{status.label | html.escape}}","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"{{ digizuite.get_title(id) | html.escape}}","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph"}],"version":1}