Documentation

    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Custom Lookups

  • Article
  • 1 minutes to read

Details

Table ID: h_sm_custom_lookups

Custom Lookups

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Area
h_area
 The area of the custom lookup
Nullable true
Type VARCHAR
Size 64
Created By
h_created_by
 The user id of the user who created the custom lookup
Nullable true
Type VARCHAR
Size 100
Custom Fields
h_custom_fields
 The configuration of custom fields for the custom lookup record
Type LONGTEXT
Nullable true
Date Created
h_date_created
 The date the custom lookup was created
Nullable true
Type DATETIME
Date Last Modified
h_date_last_modified
 The last modified date of the custom lookup
Nullable true
Type DATETIME
Description
h_description
 The description of the custom lookup
Nullable true
Type VARCHAR
Size 1024
Id
h_id
 The id of the custom lookup
Primary Key true
Nullable false
Auto Increment true
Type INTEGER
Size 11
One to Many
CustomLookupRecords
h_sm_custom_lookup_records.h_custom_lookup_id
Last Modified By
h_last_modified_by
 The user id of the user who last modified the custom lookup
Nullable true
Type VARCHAR
Size 100
Name
h_name
 The name of the custom lookup
Nullable true
Type VARCHAR
Size 128
Reference Type
h_reference_type
 The reference type of the custom lookup
Nullable true
Type VARCHAR
Size 64
Status
h_status
 The status of the custom lookup
Nullable true
Type VARCHAR
Size 30
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document