Filter using Record's Value

In This Topic

When krewDashboard is displayed on the kintone's record detail screen or krewSheet sub window, the field values of the displayed record (or the record having focus in the krewSheet sub window) can be used as filter conditions.

If the field's value specified in the filter condition changes when displaying other records, the data of the aggregation source app will be fetched.

Setting Example

Before applying filter:

Filter settings (select Include any of record's value option and aggregate data from Exam with the same value in the displayed record):

After applying filter:

The following table depicts the possible combination of available field types can be used, as some field types such as number fields cannot be used as filter conditions for date fields. The vertical fields in the table represent the fields used to specify the conditions, while the horizontal fields represent the fields used to specify the values for those conditions.

Filed Types	Text	Rich Text	Text Area	Number	Calculated (Number (Example:1000))	Calculated (Number(Example:1,000))	Calculated (Date and time (Example:2012-08-06 2:03))	Calculated (Date (Example:2012-08-06))	Calculated (Time (Example:2:03))	Calculated (Time (Example:26 hours 3 minutes))	Calculated (Time (Example: 1 day 2hours 3 minutes))	Radio button	Check box	Multi-choice	Drop-down	Date	Time	Date and time	Attachment	Link	User selection	Department selection	Group selection	Lookup	Record number	Created by	Created datetime	Updated by	Updated datetime	Status	Assignee
Text	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇		〇	〇	〇	〇	〇	〇	〇
Rich Text	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇		〇	〇	〇	〇	〇	〇	〇
Text Area	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇	〇		〇	〇	〇	〇	〇	〇	〇
Number	〇	〇	〇	〇	〇	〇																			〇
Calculated (Number (Example:1000))	〇	〇	〇	〇	〇	〇																			〇
Calculated (Number(Example:1,000))	〇	〇	〇	〇	〇	〇																			〇
Calculated (Date and time (Example:2012-08-06 2:03))	〇	〇	〇				〇	〇								〇		〇									〇		〇
Calculated (Date (Example:2012-08-06))	〇	〇	〇				〇	〇								〇		〇									〇		〇
Calculated (Time (Example:2:03))	〇	〇	〇						〇
Calculated (Time (Example:26 hours 3 minutes))	〇	〇	〇							〇
Calculated (Time (Example: 1 day 2hours 3 minutes))	〇	〇	〇								〇
Radio button	〇	〇	〇									〇			〇															〇
Check box	〇	〇	〇										〇	〇
Multi-choice	〇	〇	〇										〇	〇
Drop-down	〇	〇	〇									〇			〇															〇
Date	〇	〇	〇				〇	〇								〇		〇									〇		〇
Time	〇	〇	〇						〇							〇	〇	〇									〇		〇
Date and time	〇	〇	〇													〇		〇									〇		〇
Attachment																			〇
Link	〇	〇	〇																	〇
User selection																					〇					〇		〇			〇
Department selection																						〇
Group selection																							〇
Lookup	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1	※1
Record number	〇	〇	〇	〇	〇	〇																			〇
Created by																					〇					〇		〇			〇
Created datetime	〇	〇	〇				〇	〇								〇		〇									〇		〇
Updated by																					〇					〇		〇			〇
Updated datetime	〇	〇	〇				〇	〇								〇		〇									〇		〇
Status	〇	〇	〇									〇			〇															〇
Assignee																					〇					〇		〇			〇

※ If the source field is a numeric type, it will be treated the same as a number field. For all other field types, they will be treated the same as text field.

When a date field's value is specified as a date and time field's condition, "00:00" will be added to the current time.
When specifying the value of text field as a condition for a date field, you cannot use a string in the format of a Japanese era. You need to input a string in the format such as "yyyy-m-d" or "yyyy/m/d" into the text field.
When you specify the value of the record number field that contains the app code as the condition for the number field, the value of the record number field that does not contain the app code is used.
The data that has been retrieved once will be cached. When displaying records with the same value, the cached record will be used (although data is not retrieved using the kintone API, the dashboard will be redrawn). The cache will be cleared by reloading the krewDashboard or refreshing the browser page.