Capturing & Applying Filters - Different Filter Types

Karthick_

Hi Team

We need to Capture and Apply Filters after embedding the OAC Workbook within our website using JavaScript code.
To do so, we are using Data actions to capture the filter values and Parameters attributes to applying the filters.

Am facing trouble in the below scenarios.

Scenario 1 :How to apply filters for the fields that are not visible in the Filter Type.

Example : For "Date Range Filter Type" - If the default type is Date Range means, we cannot be able to apply filters to "non active filter sections" List or Relative Time as shown in the below image.

The same scenario for the "List Filter Type" & "Range Filter Type" to apply filter values for non active filter sections ie, Top Bottom N , Range , List & Vice Versa.

Scenario 2 : How to Capture & Apply Filters for "Search Option Menu" & "Null" in List Filter Type

In the List Filter Type, Need a way to get the filter values of selected fields from the Data Action Payload V2

Also Since there is no parameter options available, Not able to apply filters to that fields.

Scenario 3 : How to Capture & Apply Filters for Date Range Filter "Range Types" ie, Range, Start At, End At, Equal.

Since it doesn't have the parameters attribute too, Not able to apply filters too,.

It would be great, If values can be captured in Data Actions Payload and Parameter attribute to apply filters.

Scenario 4 : How to Capture & Apply filters for "By" field in Range Filter Type.

Using Data Action, Not able to get the filter values of the By field.

Since it doesn't have the parameters attributes, How to apply filters for the field.
It would be great, If parameters are added to it.

Scenario 5 : How to Capture & Apply Filters for "By" field in Top Bottom N Filter Type

Using Data Actions, Not able to get the filter values of the By field.

Since it doesn't have the parameters attributes too, How to apply filters for the field.

It would be great, If parameters are added to it.

Scenario 6 : How to apply filters only for the List Filter Type ?

Consider, We have parameters for both Exclude & Selection.

If we try to apply filters only for selection, Filter values is not applying.

It is working once the Filter values is passed with Exclude 1. Even 0 is not working.

				 

// BELOW CODE WORKS FINE !

                                 var parameters={ 

					 "p1n": "Param_Vertical", 

  			               	"p1v": "BFS"

					,"p2n": "Pram_IsExcludesVertical", 

					 "p2v": 1,

				   }; 

// BELOW CODE WONT WORK !
                                 var parameters={ 

					 "p1n": "Param_Vertical", 

  			               	"p1v": "BFS"

					//,"p2n": "Pram_IsExcludesVertical", 

					 //"p2v": 1,

				   }; 

The above code may looks strange, But it is not working as mentioned above.

Previously created SR for the above scenarios are :

SR 3-38318710791
SR 3-38341411361
SR 3-38341299591
SR 3-38341580431
SR 3-38430110711

It would be great, If parameters are added to the fields, That are not available to apply filters to it.

Also It'll be helpful If the same values are being able to capture it via Data Actions.

Also, Will be very happy If Data Actions ca be triggered by external button click.

Thanks in advance.

Karthick.S