.rst .pdf

On this page

Model Filters

Model filters are set up as instances of data/ModelFilterCriteria with the following properties:

Property	Description
name	The name is used by the macro function
type	The model on which the filter is applied
criteria.attribute	attribute name of the applied model
criteria.conditional_operator	optional: takes a boolean AND, OR NOT to apply to next criteria
criteria.condition	see list below for options
criteria.value	filter condition value of attribute to check against

criteria.condition can be:

Field Name	Description	GUI Field Name
equalsIgnoreCase	Case insensitive exact match.	Equals
isexactly	Case sensitive exact match.	Equals Exactly
containsIgnoreCase	Case insensitive substring match.	Contains
contains	Case sensitive substring match.	Contains Exactly
regex_search	Regular expression	Regex Search

The macro functions take a Model Filter name as input.

Match Model Filter Criteria

• fn.match_model_filter_criteria: Given input context data and a model filter criteria instance name, return a dictionary of output that contains a result.

  Syntax: {{fn.match_model_filter_criteria <input-data>,<filter-name> }}

  In the Model Filter Criteria:

  • The filter-name, individual criteria are evaluated to a value: True or False

  • The filter-name, criteria are combined with a conditional_operator (e.g. boolean AND) to yield the result value: true or false

  • Filters will evaluate each of the criteria for the specified type.

  Below is an instance of data/ModelFilterCriteria for type is device/msgraph/MsolUser:

  "data": {
             "type": "device/msgraph/MsolUser",
             "description": "Multi Level Filter",
             "name": "Multi Level Filter",
             "criteria": [
                 {
                     "attribute": "City",
                     "condition": "isexactly",
                     "value": "Cape Town",
                     "conditional_operator": "AND"
                 },
                 {
                     "attribute": "Address",
                     "condition": "contains",
                     "value": "Bellville"
                 }
              ]
           }
  

  Example	Output
  data/ModelFilterCriteria with name is “Multi Level Filter” as in example above. Input context data contains: {"user_details": { City": "Cape Town", ... Address": "City of Bellville", ... } Function call: {{fn.match_model_filter_criteria user_details.City, 'Multi Level Filter' }}	{"output": "[City] 'Cape Town' isexactly 'Cape Town' = True\n [Address] 'City of Bellville' contains 'Bellville' = True", "result": true}

Instances that match Model Filter Criteria

• fn.instances_match_model_filter_criteria:

  Syntax:

  {{fn.instances_match_model_filter_criteria <model filter criteria name>,<field name>,<direction>}}

  Given:

  • model filter criteria name: name of data/ModelFilterCriteria

  • field name: a field name from the model filter criteria instance type. The match results will be a list of this field, with the list called model_match_list.

    The model filter can contain one or multiple criteria operating on the type model - with multiple criteria also combined with a boolean conditional_operator.

  • direction: optional search direction. Default is above, which is upwards and excludes the current hierarchy if it is not the top hierarchy.

  Return:

  • Input model filter and query details and result model_match_list.

  Example macro:

  {{ fn.instances_match_model_filter_criteria CityTulsa,username,up }}
  

  Example output:

  {
    "model_filter_criteria_field": "username",
    "model_filter_criteria_name": "CityTulsa",
    "hierarchy": "nnf525b7e04a4a001480cfnn",
    "model_filter_criteria": {
        "usage": "Test",
        "type": "data/User",
        "name": "Demo Criteria City = Tulsa",
        "criteria": [
            {
                "attribute": "city",
                "condition": "isexactly",
                "value": "Tulsa"
            }
        ]
    },
    "model_filter_macro": "{# data.User.* || direction:up #}",
    "model_match_list": [
        "[email protected]",
        "[email protected]",
        "[email protected]",
        "[email protected]",
        "[email protected]"
    ],
    "model_filter_criteria_direction": "up",
    "hierarchy_friendly_path": "sys.hcs.CS-P.CS-NB.RND.East.AlterLake"
  }
  

Builds a macro for filtering dropdown choices

fn.build_filter_macro: Given 2 mandatory input parameters:

• a

• a

return

Examples:

Example	Output

previous

List Functions

next

Model Instance Filters (MIF) from CSV File