Saved filter, how to view all configurations?

I think we’re talking about something different. I have a grid that has “runtime filtering” enabled, per this option:

Which at runtime, looks like this:

Each user that configures a filter using this functionality sees only their own filter configuration. But how can I, as an administrator, see the detail of filters that all users have configured?

Hi @Jason3 

I think there is a way that you can see it but it will require accessing the K2 database which is a long shot.

In K2 database there is a table ‘UserSetting’ that has the runtime filters.

Please note that the runtime filters value is saved as xml code.

You can run the following code:

SELECT TOP (1000) [id]

      ,[Value]

  FROM [K2].[Form].[UserSetting]

Results: 

<ViewFilterCriteria><FilterCriteria name="TEST FOR COM"><Filter isSimple="True"><Equals><Item SourceType="ViewField" SourceID="3c747b30-8b92-0cac-294d-7e6e8c25ea7e" DataType="text" Name="72abe205-c92a-7f3c-43a1-7803723d1b26_3c747b30-8b92-0cac-294d-7e6e8c25ea7e" SourceName="Name" SourceDisplayName="Name">Name</Item><Item SourceType="Value"><SourceValue><Item SourceType="Value"><![CDATA[Qualified]]></Item></SourceValue></Item></Equals></Filter></FilterCriteria><FilterCriteria name="test number 2"><Filter isSimple="True"><Equals><Item SourceType="ViewField" SourceID="3c747b30-8b92-0cac-294d-7e6e8c25ea7e" DataType="text" Name="72abe205-c92a-7f3c-43a1-7803723d1b26_3c747b30-8b92-0cac-294d-7e6e8c25ea7e" SourceName="Name" SourceDisplayName="Name">Name</Item><Item SourceType="Value"><SourceValue><Item SourceType="Value"><![CDATA[failed]]></Item></SourceValue></Item></Equals></Filter></FilterCriteria></ViewFilterCriteria>

On the results you can see that I have 2 runtime filters :

• Test for com with CData[Qualified] (name = qualified runtime filter)
• Test number 2 with CData[Failed] (name = failed runtime filter)

Regards

HulisaniN

Hi @Jason3 

I agree with Prineel, Since you are using Cloud I don’t think it would be possible to get the runtime filter information.

Maybe you can log a new idea here.

Note: If your idea receives over 20 votes in 90 days, we will move it to Future Consideration.
If not, the Idea will be moved to Not Planned with the possibility of it being moved to Future Consideration should it collect 20 or more votes in the future.

Regards

Hulisani