Filters Table

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

Description

The table stores filters. A filter consists of a number of filter items with the same FilterId. Filter items are stored in the FilterItems table.

Columns

The table contains the following columns:

FilterId  :  int, primary key, allows null: no

The unique numeric identifier of the filter.

CreateUserId  :  int, allows null: yes

The ID of the user who created the filter.

DataSource  :  varchar (max 100 chars), allows null: yes

The column is reserved for system use only.

DateCreated  :  datetime, allows null: no, default: Current date and time

Date and time when the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

Date and time when the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DeptId  :  int, allows null: no

The ID of the department that owns the filter.

EntityCode  :  varchar (max 100 chars), allows null: no

Module where the filter resides.

Correspondences between entity code values and related modules and features you can find in Table of Entity Code Values.

FilterType  :  varchar (max 15 chars), allows null: yes

The type of the filter (Standard, Escalation).

IsPublic  :  char (max 1 char), allows null: no, default: N

Y means the filter is public. N means the filter is private.

PreProcessedWhere  :  varchar (max 1000 chars), allows null: yes

The column is reserved for system use only.

ProjId  :  int, allows null: yes, default: 0

The ID of the project that contains the filter.

Title  :  varchar (max 100 chars), allows null: no

The name of the filter.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

FilterItems Table
Crossmodules

Highlight search results