---
title: "TIPSBYTERM (Data Dictionary)"
description: "Tips by Term"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.TIPSBYTERM
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.TIPSBYTERM
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# TIPSBYTERM: Data Dictionary Tips by Term

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Label: Tips by Term

Tips by term.

Can only retrieve data.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `Category` | `` | [ ] |  | Category. |
| `IgnoreErrors` | `` | [ ] |  | Ignore errors in the retrieval of the tips, such as a timeout of the online help service, and return no tips instead. Defaults to false. |
| `IncludeOtherLanguages` | `` | [ ] |  | Include other tips in other languages than the preferred and fallback language. |
| `MessageCode` | `` | [x] |  | Message code to search. |
| `PreferredLanguageCode` | `` | [ ] |  | Preferred language code. |
| `SortingOrder` | `` | [ ] |  | Sorting order, such as 'views' or 'created'. |
| `Tags` | `` | [ ] |  | List of tags, separated by a comma (','). |
| `UltimateFallbackLanguageCode` | `` | [ ] |  | Fallback language code (optional). |

## Table Columns

The columns of the table `TIPSBYTERM` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CreatedUtc` | `datetime` | Created | [ ] | fetched only when named |  |
| `HasAnswer` | `boolean` | Has Answer | [x] | fetched only when named |  |
| `InteractionCount` | `int32` | Interaction Count | [x] | fetched only when named |  |
| `IsQuestion` | `boolean` | Is Boolean | [x] | fetched only when named |  |
| `LanguageCode` | `varchar2(2)` | Language Code | [x] | fetched only when named |  |
| `ModifiedUtc` | `datetime` | Modified | [ ] | fetched only when named |  |
| `ReadMoreUrl` | `varchar2` | URL | [ ] | fetched only when named |  |
| `Tags` | `varchar2` | Tags | [ ] | fetched only when named |  |
| `Title` | `varchar2(240)` | Title | [x] | fetched only when named |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Data Dictionary](/en/release-notes/drivers?driver=data-dictionary)

