Variable
Description
The current iteration of the loop. (1 indexed)
The current iteration of the loop. (0 indexed)
The number of iterations from the end of the loop (1 indexed)
The number of iterations from the end of the loop (0 indexed)
True if first iteration.
True if last iteration.
The number of items in the sequence.
A helper function to cycle between a list of sequences. See the explanation below.
Indicates how deep in a recursive loop the rendering currently is. Starts at level 1
Indicates how deep in a recursive loop the rendering currently is. Starts at level 0
The item from the previous iteration of the loop. Undefined during the first iteration.
The item from the following iteration of the loop. Undefined during the last iteration.
True if previously called with a different value (or not called at all).
Within a for-loop, it’s possible to cycle among a list of strings/variables each time through the loop by using the special loop.cycle helper:
Since Jinja 2.1, an extra cycle helper exists that allows loop-unbound cycling. For more information, have a look at the List of Global Functions .
Unlike in Python, it’s not possible to break or continue in a loop. You can, however, filter the sequence during iteration, which allows you to skip items. The following example skips all the users which are hidden:
The advantage is that the special loop variable will count correctly; thus not counting the users not iterated over.
If no iteration took place because the sequence was empty or the filtering removed all the items from the sequence, you can render a default block by using else :
Note that, in Python, else blocks are executed whenever the corresponding loop did not break . Since Jinja loops cannot break anyway, a slightly different behavior of the else keyword was chosen.
It is also possible to use loops recursively. This is useful if you are dealing with recursive data such as sitemaps or RDFa. To use loops recursively, you basically have to add the recursive modifier to the loop definition and call the loop variable with the new iterable where you want to recurse.
The following example implements a sitemap with recursive loops:
The loop variable always refers to the closest (innermost) loop. If we have more than one level of loops, we can rebind the variable loop by writing {% set outer_loop = loop %} after the loop that we want to use recursively. Then, we can call it using {{ outer_loop(…) }}
Please note that assignments in loops will be cleared at the end of the iteration and cannot outlive the loop scope. Older versions of Jinja2 had a bug where in some circumstances it appeared that assignments would work. This is not supported. See Assignments for more information about how to deal with this.
If all you want to do is check whether some value has changed since the last iteration or will change in the next iteration, you can use previtem and nextitem :
If you only care whether the value changed at all, using changed is even easier:
The if statement in Jinja is comparable with the Python if statement. In the simplest form, you can use it to test if a variable is defined, not empty and not false:
For multiple branches, elif and else can be used like in Python. You can use more complex Expressions there, too:
If can also be used as an inline expression and for loop filtering .
Macros are comparable with functions in regular programming languages. They are useful to put often used idioms into reusable functions to not repeat yourself (“DRY”).
Here’s a small example of a macro that renders a form element:
The macro can then be called like a function in the namespace:
If the macro was defined in a different template, you have to import it first.
Inside macros, you have access to three special variables:
If more positional arguments are passed to the macro than accepted by the macro, they end up in the special varargs variable as a list of values.
Like varargs but for keyword arguments. All unconsumed keyword arguments are stored in this special variable.
If the macro was called from a call tag, the caller is stored in this variable as a callable macro.
Macros also expose some of their internal details. The following attributes are available on a macro object:
The name of the macro. {{ input.name }} will print input .
A tuple of the names of arguments the macro accepts.
A tuple of default values.
This is true if the macro accepts extra keyword arguments (i.e.: accesses the special kwargs variable).
This is true if the macro accepts extra positional arguments (i.e.: accesses the special varargs variable).
This is true if the macro accesses the special caller variable and may be called from a call tag.
If a macro name starts with an underscore, it’s not exported and can’t be imported.
In some cases it can be useful to pass a macro to another macro. For this purpose, you can use the special call block. The following example shows a macro that takes advantage of the call functionality and how it can be used:
It’s also possible to pass arguments back to the call block. This makes it useful as a replacement for loops. Generally speaking, a call block works exactly like a macro without a name.
Here’s an example of how a call block can be used with arguments:
Filter sections allow you to apply regular Jinja2 filters on a block of template data. Just wrap the code in the special filter section:
Inside code blocks, you can also assign values to variables. Assignments at top level (outside of blocks, macros or loops) are exported from the template like top level macros and can be imported by other templates.
Assignments use the set tag and can have multiple targets:
Scoping Behavior
Please keep in mind that it is not possible to set variables inside a block and have them show up outside of it. This also applies to loops. The only exception to that rule are if statements which do not introduce a scope. As a result the following template is not going to do what you might expect:
It is not possible with Jinja syntax to do this. Instead use alternative constructs like the loop else block or the special loop variable:
As of version 2.10 more complex use cases can be handled using namespace objects which allow propagating of changes across scopes:
Note hat the obj.attr notation in the set tag is only allowed for namespace objects; attempting to assign an attribute on any other object will raise an exception.
New in version 2.10: Added support for namespace objects
New in version 2.8.
Starting with Jinja 2.8, it’s possible to also use block assignments to capture the contents of a block into a variable name. This can be useful in some situations as an alternative for macros. In that case, instead of using an equals sign and a value, you just write the variable name and then everything until {% endset %} is captured.
The navigation variable then contains the navigation HTML source.
Changed in version 2.10.
Starting with Jinja 2.10, the block assignment supports filters.
The extends tag can be used to extend one template from another. You can have multiple extends tags in a file, but only one of them may be executed at a time.
See the section about Template Inheritance above.
Blocks are used for inheritance and act as both placeholders and replacements at the same time. They are documented in detail in the Template Inheritance section.
The include statement is useful to include a template and return the rendered contents of that file into the current namespace:
Included templates have access to the variables of the active context by default. For more details about context behavior of imports and includes, see Import Context Behavior .
From Jinja 2.2 onwards, you can mark an include with ignore missing ; in which case Jinja will ignore the statement if the template to be included does not exist. When combined with with or without context , it must be placed before the context visibility statement. Here are some valid examples:
New in version 2.2.
You can also provide a list of templates that are checked for existence before inclusion. The first template that exists will be included. If ignore missing is given, it will fall back to rendering nothing if none of the templates exist, otherwise it will raise an exception.
Changed in version 2.4: If a template object was passed to the template context, you can include that object using include .
Jinja2 supports putting often used code into macros. These macros can go into different templates and get imported from there. This works similarly to the import statements in Python. It’s important to know that imports are cached and imported templates don’t have access to the current template variables, just the globals by default. For more details about context behavior of imports and includes, see Import Context Behavior .
There are two ways to import templates. You can import a complete template into a variable or request specific macros / exported variables from it.
Imagine we have a helper module that renders forms (called forms.html ):
The easiest and most flexible way to access a template’s variables and macros is to import the whole template module into a variable. That way, you can access the attributes:
Alternatively, you can import specific names from a template into the current namespace:
Macros and variables starting with one or more underscores are private and cannot be imported.
Changed in version 2.4: If a template object was passed to the template context, you can import from that object.
By default, included templates are passed the current context and imported templates are not. The reason for this is that imports, unlike includes, are cached; as imports are often used just as a module that holds macros.
This behavior can be changed explicitly: by adding with context or without context to the import/include directive, the current context can be passed to the template and caching is disabled automatically.
Here are two examples:
In Jinja 2.0, the context that was passed to the included template did not include variables defined in the template. As a matter of fact, this did not work:
The included template render_box.html is not able to access box in Jinja 2.0. As of Jinja 2.1, render_box.html is able to do so.
Jinja allows basic expressions everywhere. These work very similarly to regular Python; even if you’re not working with Python you should feel comfortable with it.
The simplest form of expressions are literals. Literals are representations for Python objects such as strings and numbers. The following literals exist:
Everything between two double or single quotes is a string. They are useful whenever you need a string in the template (e.g. as arguments to function calls and filters, or just to extend or include a template).
Integers and floating point numbers are created by just writing the number down. If a dot is present, the number is a float, otherwise an integer. Keep in mind that, in Python, 42 and 42.0 are different ( int and float , respectively).
Everything between two brackets is a list. Lists are useful for storing sequential data to be iterated over. For example, you can easily create a list of links using lists and tuples for (and with) a for loop:
Tuples are like lists that cannot be modified (“immutable”). If a tuple only has one item, it must be followed by a comma ( ('1-tuple',) ). Tuples are usually used to represent items of two or more elements. See the list example above for more details.
A dict in Python is a structure that combines keys and values. Keys must be unique and always have exactly one value. Dicts are rarely used in templates; they are useful in some rare cases such as the xmlattr() filter.
true is always true and false is always false.
The special constants true , false , and none are indeed lowercase. Because that caused confusion in the past, ( True used to expand to an undefined variable that was considered false), all three can now also be written in title case ( True , False , and None ). However, for consistency, (all Jinja identifiers are lowercase) you should use the lowercase versions.
Jinja allows you to calculate with values. This is rarely useful in templates but exists for completeness’ sake. The following operators are supported:
Adds two objects together. Usually the objects are numbers, but if both are strings or lists, you can concatenate them this way. This, however, is not the preferred way to concatenate strings! For string concatenation, have a look-see at the ~ operator. {{ 1 + 1 }} is 2 .
Subtract the second number from the first one. {{ 3 - 2 }} is 1 .
Divide two numbers. The return value will be a floating point number. {{ 1 / 2 }} is {{ 0.5 }} .
Divide two numbers and return the truncated integer result. {{ 20 // 7 }} is 2 .
Calculate the remainder of an integer division. {{ 11 % 7 }} is 4 .
Multiply the left operand with the right one. {{ 2 * 2 }} would return 4 . This can also be used to repeat a string multiple times. {{ '=' * 80 }} would print a bar of 80 equal signs.
Raise the left operand to the power of the right operand. {{ 2**3 }} would return 8 .
Compares two objects for equality.
Compares two objects for inequality.
true if the left hand side is greater than the right hand side.
true if the left hand side is greater or equal to the right hand side.
true if the left hand side is lower than the right hand side.
true if the left hand side is lower or equal to the right hand side.
For if statements, for filtering, and if expressions, it can be useful to combine multiple expressions:
Return true if the left and the right operand are true.
Return true if the left or the right operand are true.
negate a statement (see below).
group an expression.
The is and in operators support negation using an infix notation, too: foo is not bar and foo not in bar instead of not foo is bar and not foo in bar . All other expressions require a prefix notation: not (foo and bar).
The following operators are very useful but don’t fit into any of the other two categories:
Perform a sequence / mapping containment test. Returns true if the left operand is contained in the right. {{ 1 in [1, 2, 3] }} would, for example, return true.
Performs a test .
Applies a filter .
Converts all operands into strings and concatenates them.
{{ "Hello " ~ name ~ "!" }} would return (assuming name is set to 'John' ) Hello John! .
Call a callable: {{ post.render() }} . Inside of the parentheses you can use positional arguments and keyword arguments like in Python:
{{ post.render(user, full=true) }} .
Get an attribute of an object. (See Variables )
It is also possible to use inline if expressions. These are useful in some situations. For example, you can use this to extend from one template if a variable is defined, otherwise from the default layout template:
The general syntax is <do something> if <something is true> else <do something else> .
The else part is optional. If not provided, the else block implicitly evaluates into an undefined object:
You can also use any of the methods of defined on a variable’s type. The value returned from the method invocation is used as the value of the expression. Here is an example that uses methods defined on strings (where page.title is a string):
This also works for methods on user-defined types. For example, if variable f of type Foo has a method bar defined on it, you can do the following:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return the absolute value of the argument.
Get an attribute of an object. foo|attr("bar") works like foo.bar just that always an attribute is returned and items are not looked up.
See Notes on subscriptions for more details.
A filter that batches items. It works pretty much like slice just the other way round. It returns a list of lists with the given number of items. If you provide a second parameter this is used to fill up missing items. See this example:
Capitalize a value. The first character will be uppercase, all others lowercase.
Centers the value in a field of a given width.
If the value is undefined it will return the passed default value, otherwise the value of the variable:
This will output the value of my_variable if the variable was defined, otherwise 'my_variable is not defined' . If you want to use default with variables that evaluate to false you have to set the second parameter to true :
Sort a dict and yield (key, value) pairs. Because python dicts are unsorted you may want to use this function to order them by either key or value:
Convert the characters &, <, >, ‘, and ” in string s to HTML-safe sequences. Use this if you need to display text that might contain such characters in HTML. Marks return value as markup string.
Format the value like a ‘human-readable’ file size (i.e. 13 kB, 4.1 MB, 102 Bytes, etc). Per default decimal prefixes are used (Mega, Giga, etc.), if the second parameter is set to True the binary prefixes are used (Mebi, Gibi).
Return the first item of a sequence.
Convert the value into a floating point number. If the conversion doesn’t work it will return 0.0 . You can override this default using the first parameter.
Enforce HTML escaping. This will probably double escape variables.
Apply python string formatting on an object:
Group a sequence of objects by a common attribute.
If you for example have a list of dicts or objects that represent persons with gender , first_name and last_name attributes and you want to group all users by genders you can do something like the following snippet:
Additionally it’s possible to use tuple unpacking for the grouper and list:
As you can see the item we’re grouping by is stored in the grouper attribute and the list contains all the objects that have this grouper in common.
Changed in version 2.6: It’s now possible to use dotted notation to group by the child attribute of another attribute.
Return a copy of the string with each line indented by 4 spaces. The first line and blank lines are not indented by default.
width – Number of spaces to indent by.
first – Don’t skip indenting the first line.
blank – Don’t skip indenting empty lines.
Changed in version 2.10: Blank lines are not indented by default.
Rename the indentfirst argument to first .
Convert the value into an integer. If the conversion doesn’t work it will return 0 . You can override this default using the first parameter. You can also override the default base (10) in the second parameter, which handles input with prefixes such as 0b, 0o and 0x for bases 2, 8 and 16 respectively. The base is ignored for decimal numbers and non-string values.
Return a string which is the concatenation of the strings in the sequence. The separator between elements is an empty string per default, you can define it with the optional parameter:
It is also possible to join certain attributes of an object:
New in version 2.6: The attribute parameter was added.
Return the last item of a sequence.
Return the number of items in a container.
Convert the value into a list. If it was a string the returned list will be a list of characters.
Convert a value to lowercase.
Applies a filter on a sequence of objects or looks up an attribute. This is useful when dealing with lists of objects but you are really only interested in a certain value of it.
The basic usage is mapping on an attribute. Imagine you have a list of users but you are only interested in a list of usernames:
Alternatively you can let it invoke a filter by passing the name of the filter and the arguments afterwards. A good example would be applying a text conversion filter on a sequence:
New in version 2.7.
Return the largest item from the sequence.
case_sensitive – Treat upper and lower case strings as distinct.
attribute – Get the object with the max value of this attribute.
Return the smallest item from the sequence.
Pretty print a variable. Useful for debugging.
With Jinja 1.2 onwards you can pass it a parameter. If this parameter is truthy the output will be more verbose (this requires pretty )
Return a random item from the sequence.
Filters a sequence of objects by applying a test to each object, and rejecting the objects with the test succeeding.
If no test is specified, each object will be evaluated as a boolean.
Example usage:
Filters a sequence of objects by applying a test to the specified attribute of each object, and rejecting the objects with the test succeeding.
If no test is specified, the attribute’s value will be evaluated as a boolean.
Return a copy of the value with all occurrences of a substring replaced with a new one. The first argument is the substring that should be replaced, the second is the replacement string. If the optional third argument count is given, only the first count occurrences are replaced:
Reverse the object or return an iterator that iterates over it the other way round.
Round the number to a given precision. The first parameter specifies the precision (default is 0 ), the second the rounding method:
'common' rounds either up or down
'ceil' always rounds up
'floor' always rounds down
If you don’t specify a method 'common' is used.
Note that even if rounded to 0 precision, a float is returned. If you need a real integer, pipe it through int :
Mark the value as safe which means that in an environment with automatic escaping enabled this variable will not be escaped.
Filters a sequence of objects by applying a test to each object, and only selecting the objects with the test succeeding.
Filters a sequence of objects by applying a test to the specified attribute of each object, and only selecting the objects with the test succeeding.
Slice an iterator and return a list of lists containing those items. Useful if you want to create a div containing three ul tags that represent columns:
If you pass it a second argument it’s used to fill missing values on the last iteration.
Sort an iterable. Per default it sorts ascending, if you pass it true as first argument it will reverse the sorting.
If the iterable is made of strings the third parameter can be used to control the case sensitiveness of the comparison which is disabled by default.
It is also possible to sort by an attribute (for example to sort by the date of an object) by specifying the attribute parameter:
Changed in version 2.6: The attribute parameter was added.
Make a string unicode if it isn’t already. That way a markup string is not converted back to unicode.
Strip SGML/XML tags and replace adjacent whitespace by one space.
Returns the sum of a sequence of numbers plus the value of parameter ‘start’ (which defaults to 0). When the sequence is empty it returns start.
It is also possible to sum up only certain attributes:
Changed in version 2.6: The attribute parameter was added to allow suming up over attributes. Also the start parameter was moved on to the right.
Return a titlecased version of the value. I.e. words will start with uppercase letters, all remaining characters are lowercase.
Dumps a structure to JSON so that it’s safe to use in <script> tags. It accepts the same arguments and returns a JSON string. Note that this is available in templates through the |tojson filter which will also mark the result as safe. Due to how this function escapes certain characters this is safe even if used outside of <script> tags.
The following characters are escaped in strings:
This makes it safe to embed such strings in any place in HTML with the notable exception of double quoted attributes. In that case single quote your attributes or HTML escape it in addition.
The indent parameter can be used to enable pretty printing. Set it to the number of spaces that the structures should be indented with.
Note that this filter is for use in HTML contexts only.
New in version 2.9.
Strip leading and trailing whitespace.
Return a truncated copy of the string. The length is specified with the first parameter which defaults to 255 . If the second parameter is true the filter will cut the text at length. Otherwise it will discard the last word. If the text was in fact truncated it will append an ellipsis sign ( "..." ). If you want a different ellipsis sign than "..." you can specify it using the third parameter. Strings that only exceed the length by the tolerance margin given in the fourth parameter will not be truncated.
The default leeway on newer Jinja2 versions is 5 and was 0 before but can be reconfigured globally.
Returns a list of unique items from the the given iterable.
The unique items are yielded in the same order as their first occurrence in the iterable passed to the filter.
attribute – Filter objects with unique values for this attribute.
Convert a value to uppercase.
Escape strings for use in URLs (uses UTF-8 encoding). It accepts both dictionaries and regular strings as well as pairwise iterables.
Converts URLs in plain text into clickable links.
If you pass the filter an additional integer it will shorten the urls to that number. Also a third argument exists that makes the urls “nofollow”:
If target is specified, the target attribute will be added to the <a> tag:
Changed in version 2.8+: The target parameter was added.
Count the words in that string.
Return a copy of the string passed to the filter wrapped after 79 characters. You can override this default using the first parameter. If you set the second parameter to false Jinja will not split words apart if they are longer than width . By default, the newlines will be the default newlines for the environment, but this can be changed using the wrapstring keyword argument.
New in version 2.7: Added support for the wrapstring parameter.
Create an SGML/XML attribute string based on the items in a dict. All values that are neither none nor undefined are automatically escaped:
Results in something like this:
As you can see it automatically prepends a space in front of the item if the filter returned something unless the second parameter is false.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
Return whether the object is callable (i.e., some kind of function).
Note that classes are callable, as are instances of classes with a __call__() method.
Return true if the variable is defined:
See the default() filter for a simple way to set undefined variables.
Check if a variable is divisible by a number.
Same as a == b.
== , equalto
Check if the value is escaped.
Return true if the variable is even.
Same as a >= b.
Same as a > b.
> , greaterthan
Check if value is in seq.
New in version 2.10.
Check if it’s possible to iterate over an object.
Same as a <= b.
Return true if the variable is lowercased.
Same as a < b.
< , lessthan
Return true if the object is a mapping (dict etc.).
New in version 2.6.
Same as a != b.
Return true if the variable is none.
Return true if the variable is a number.
Return true if the variable is odd.
Check if an object points to the same memory address than another object:
Return true if the variable is a sequence. Sequences are variables that are iterable.
Return true if the object is a string.
Like defined() but the other way round.
Return true if the variable is uppercased.
The following functions are available in the global scope by default:
Return a list containing an arithmetic progression of integers. range(i, j) returns [i, i+1, i+2, ..., j-1] ; start (!) defaults to 0 . When step is given, it specifies the increment (or decrement). For example, range(4) and range(0, 4, 1) return [0, 1, 2, 3] . The end point is omitted! These are exactly the valid indices for a list of 4 elements.
This is useful to repeat a template block multiple times, e.g. to fill a list. Imagine you have 7 users in the list but you want to render three empty items to enforce a height with CSS:
Generates some lorem ipsum for the template. By default, five paragraphs of HTML are generated with each paragraph between 20 and 100 words. If html is False, regular text is returned. This is useful to generate simple contents for layout testing.
A convenient alternative to dict literals. {'foo': 'bar'} is the same as dict(foo='bar') .
The cycler allows you to cycle among values similar to how loop.cycle works. Unlike loop.cycle , you can use this cycler outside of loops or over multiple loops.
This can be very useful if you want to show a list of folders and files with the folders on top but both in the same list with alternating row colors.
The following example shows how cycler can be used:
A cycler has the following attributes and methods:
Resets the cycle to the first item.
Goes one item ahead and returns the then-current item.
Returns the current item.
New in version 2.1.
A tiny helper that can be used to “join” multiple sections. A joiner is passed a string and will return that string every time it’s called, except the first time (in which case it returns an empty string). You can use this to join things:
Creates a new container that allows attribute assignment using the {% set %} tag:
The main purpose of this is to allow carrying a value from within a loop body to an outer scope. Initial values can be provided as a dict, as keyword arguments, or both (same behavior as Python’s dict constructor):
The following sections cover the built-in Jinja2 extensions that may be enabled by an application. An application could also provide further extensions not covered by this documentation; in which case there should be a separate document explaining said extensions .
If the i18n extension is enabled, it’s possible to mark parts in the template as translatable. To mark a section as translatable, you can use trans :
To translate a template expression — say, using template filters, or by just accessing an attribute of an object — you need to bind the expression to a name for use within the translation block:
If you need to bind more than one expression inside a trans tag, separate the pieces with a comma ( , ):
Inside trans tags no statements are allowed, only variable tags are.
To pluralize, specify both the singular and plural forms with the pluralize tag, which appears between trans and endtrans :
By default, the first variable in a block is used to determine the correct singular or plural form. If that doesn’t work out, you can specify the name which should be used for pluralizing by adding it as parameter to pluralize :
When translating longer blocks of text, whitespace and linebreaks result in rather ugly and error-prone translation strings. To avoid this, a trans block can be marked as trimmed which will replace all linebreaks and the whitespace surrounding them with a single space and remove leading/trailing whitespace:
If trimming is enabled globally, the notrimmed modifier can be used to disable it for a trans block.
New in version 2.10: The trimmed and notrimmed modifiers have been added.
It’s also possible to translate strings in expressions. For that purpose, three functions exist:
gettext : translate a single string
ngettext : translate a pluralizable string
_ : alias for gettext
For example, you can easily print a translated string like this:
To use placeholders, use the format filter:
For multiple placeholders, always use keyword arguments to format , as other languages may not use the words in the same order.
Changed in version 2.5.
If newstyle gettext calls are activated ( Whitespace Trimming ), using placeholders is a lot easier:
Note that the ngettext function’s format string automatically receives the count as a num parameter in addition to the regular parameters.
If the expression-statement extension is loaded, a tag called do is available that works exactly like the regular variable expression ( {{ ... }} ); except it doesn’t print anything. This can be used to modify lists:
If the application enables the Loop Controls , it’s possible to use break and continue in loops. When break is reached, the loop is terminated; if continue is reached, the processing is stopped and continues with the next iteration.
Here’s a loop that skips every second item:
Likewise, a loop that stops processing after the 10th iteration:
Note that loop.index starts with 1, and loop.index0 starts with 0 (See: For ).
New in version 2.3.
The with statement makes it possible to create a new inner scope. Variables set within this scope are not visible outside of the scope.
With in a nutshell:
Because it is common to set variables at the beginning of the scope, you can do that within the with statement. The following two examples are equivalent:
An important note on scoping here. In Jinja versions before 2.9 the behavior of referencing one variable to another had some unintended consequences. In particular one variable could refer to another defined in the same with block’s opening statement. This caused issues with the cleaned up scoping behavior and has since been improved. In particular in newer Jinja2 versions the following code always refers to the variable a from outside the with block:
In earlier Jinja versions the b attribute would refer to the results of the first attribute. If you depend on this behavior you can rewrite it to use the set tag:
In older versions of Jinja (before 2.9) it was required to enable this feature with an extension. It’s now enabled by default.
New in version 2.4.
If you want you can activate and deactivate Autoescaping from within a template.
After an endautoescape the behavior is reverted to what it was before.
Variables let you inject data in your template. In PushMetrics, they're called parameters .
Working in Python, the simplest way to set variables is as a Dictionary . You can then use your dictionary as an argument for the .render() method of the Jinja Template.
You can set variables in your SQL template just like you would do for any other Jinja template. The following code would result in the same query as the code in the example above:
To reduce (or avoid altogether) repetition. Consider the follow CTE query:
Using day_param you can reuse the same query with different values.
There are two ways in PushMetrics to set variables that are then available in throughout your notebook, including all SQL, API, Email, or Slack blocks.
1. Parameter Blocks
Create a _parameter block_ and reference its name in SQL
2. Jinja in text blocks
In PushMetrics you can write Jinja anywhere. To create a variable you can use the following Syntax:
The value of parameter will then be available to all following blocks defined in the notebook.