Support Forum

[dustin.sauter]

We have about 700 filters in our TS implementation. I'd like to get a list of all Filters that are using the Deep Search flag. Looking at the DB, I haven't yet been able to figure out where these are stored as they are not in the gr_filter or assocaited tables. Does anyone have a good map of where the task data is in the DB or any suggestions to get at this another way? Thanks.

[Petr]

Hi,
What version TrackStudio do you use?

[dustin.sauter]

Hello. We are on 3.5.73. Thanks.

[Petr]

In TrackStudio has not function, which show all filter. but you can use sql query.
in table gr_filter have name and id filter
in table gr_fvalue have property filter, for example deep search.
For receive all filter, which it have deep search you apply follows query
select * from gr_filter, gr_fvalue where filter_id = fvalue_filter and fvalue_key='subtask' and fvalue_value='on'