Forum Discussion

irismaessen's avatar
irismaessen
Data Pipeline
06-22-2022
Solved

How do I pass the content of a text Input to a Blox filter?

I'm trying to create a slightly more restrictive text filter using Blox. I want my users to be able to type in a search term to filter on, but I only want them to be able to do a 'contains' filter, n...
Blox
  • harikm007's avatar
    harikm007
    06-23-2022

    Hi irismaessen ,

    Try this blox script (update table and column name in script):

    {
    "style": "",
    "script": "",
    "title": "",
    "showCarousel": true,
    "carouselAnimation": {
        "delay": 0,
        "showButtons": false
    },
    "body": [
        {
            "type": "Container",
            "items": [
                {
                    "type": "ColumnSet",
                    "columns": [
                        {
                            "type": "TextBlock",
                            "horizontalAlignment": "center",
                            "verticalContentAlignment": "center",
                            "wrap": true,
                            "text": "Search Text",
                            "spacing": "small"
                        },
                        {
                            "type": "Container",
                            "items": [
                                {
                                    "type": "Input.Text",
                                    "id": "data.filters[0].filterJaql.contains",
                                    "class": "",
                                    "title": "New Input",
                                    "placeholder": "Your Search Term"
                                }
                            ]
                        }
                    ]
                }
            ]
        }
    ],
    "actions": [
        {
            "type": "Filters",
            "title": "Filter (by Dimension)",
            "data": {
                "filters": [
                    {
                        "filterJaql": {
                            "contains": ""
                        },
                        "dim": {
                            "title": "Search",
                            "table": "Records",
                            "column": "Region",
                            "datatype": "text"
                        }
                    }
                ]
            }
        }
    ]
}

    -Hari

devanisetty's avatar
devanisetty
Data Storage
06-23-2022

Hi Iris, 

Below is the widget level script (which need to be added in Blox widget scripts). 

 

widget.on('ready', function(w){ 

	$('#textVal').blur(function(){
		var applyJaql = {
			'jaql':{
				"table": "TableeName",
				"column": "TableName.ColumnName",
				"dim": "[TableName.ColumnName]",
				"datatype": "text",
				"title": "Your Search Term",
				"filter": {
					"multiSelection": false,
					'members': [$(this).val()],
                    'explicit': true
                }
			},
			'instanceid': 'filterInstanceID'  
		};
		prism.activeDashboard.filters.update(applyJaql,filterOptions);
		
		prism.activeDashboard.refresh();
	});

});
​

filterInstanceID - In the dashboard console type below line, in the console we will have the list of filters on the dashboard with instanceID

prism.activeDashboard.filters.$$items​

 

Hope the above solution works for your need. 
 
Thanks, 
Dev
irismaessen's avatar
irismaessen
Data Pipeline
06-23-2022

Hi,

Thanks for replying. In extremis, this might give me some guide on how to achieve what I would like to do.


But why would I need to resort to Widget scripts for this if Blox allows interaction between actions and input elements in other cases? Surely there must be a way I can pass the value of the inputbox to the Blox filter action without having to use another widget script?

  • devanisetty's avatar
    devanisetty
    Data Storage
    06-23-2022

    Rather in Widget Scripts, I think we can move the scripts to customAction and use it.