Table Details

Name:
sys_search_genius_result_field
Label:
Search Genius Result Field (en)
Created On:
2022.09.17 02:12:20
Created By:
system
Updated On:
2022.09.17 02:12:20
Updated By:
system
Column Updated On:
2022.09.17 03:00:42
Column Updated By:
system
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  active
Active boolean 40 Global sys_dictionary
  array
Array boolean 40 Global sys_dictionary
  array_denormalized
Array denormalized boolean 40 Global sys_dictionary
  attributes
Attributes string 1000 Global sys_dictionary
  audit
Audit boolean 40 Global sys_dictionary
  calculation
Calculation script 8000 Global sys_dictionary
  choice
Choice integer[choice] 40 Global sys_dictionary
  choice_field
Choice field field_name 80 Global sys_dictionary
  choice_table
Choice table table_name 80 Global sys_dictionary
 
D
column_label
Column label documentation_field 80 Global sys_dictionary
  comments
Comments string 4000 Global sys_dictionary
  create_roles
Create roles user_roles 255 Global sys_dictionary
  defaultsort
Defaultsort integer 40 Global sys_dictionary
  default_value
Default value string 512 Global sys_dictionary
  delete_roles
Delete roles user_roles 255 Global sys_dictionary
  dependent
Dependent string 80 Global sys_dictionary
  dependent_on_field
Dependent on field field_name 80 Global sys_dictionary
  display
Display boolean 40 Global sys_dictionary
  dynamic_creation
Dynamic creation boolean 40 Global sys_dictionary
  dynamic_creation_script
Dynamic creation script string 4000 Global sys_dictionary
  dynamic_default_value
Dynamic default value reference 32 Global sys_filter_option_dynamic sys_dictionary
  dynamic_ref_qual
Dynamic ref qual reference 32 Global sys_filter_option_dynamic sys_dictionary
  element
Column name string 80 Global sys_dictionary
  element_reference
Element reference boolean 40 Global sys_dictionary
  foreign_database
Foreign database string 40 Global sys_dictionary
  formula
Formula expression 4000 Global sys_dictionary
  function_definition
Function definition string 4000 Global sys_dictionary
  function_field
Function field boolean 40 Global sys_dictionary
  help
Help string 4000 Global var_dictionary
  hint
Hint string 255 Global var_dictionary
  internal_type
Type reference 40 Global sys_glide_object sys_dictionary
 
D
label
Label string 50 Global var_dictionary
  mandatory
Mandatory boolean 40 Global sys_dictionary
  max_length
Max length integer 40 Global sys_dictionary
 
M
model
Model reference 32 Global sys_search_genius_result_model sys_search_genius_result_field
  model_id
Model ID document_id 32 Global var_dictionary
  model_table
Model Table table_name 80 Global var_dictionary
 
M
name
Table table_name 80 Global sys_dictionary
  next_element
Next element string 80 Global sys_dictionary
  order
Order integer 40 Global var_dictionary
  primary
Primary boolean 40 Global sys_dictionary
  read_only
Read only boolean 40 Global sys_dictionary
  read_roles
Read roles user_roles 255 Global sys_dictionary
  reference
Reference reference 80 Global sys_db_object sys_dictionary
  reference_cascade_rule
Reference cascade rule string[choice] 20 Global sys_dictionary
  reference_floats
Reference floats boolean 40 Global sys_dictionary
  reference_key
Reference key string 40 Global sys_dictionary
  reference_qual
Reference qual string 1000 Global sys_dictionary
  reference_qual_condition
Reference qual condition conditions 1000 Global sys_dictionary
  reference_type
Reference type string 10 Global sys_dictionary
  sizeclass
Sizeclass integer 40 Global sys_dictionary
  spell_check
Spell check boolean 40 Global sys_dictionary
  staged
Staged boolean 40 Global sys_dictionary
  sys_class_name
Class sys_class_name[choice] 80 Global sys_metadata
  sys_created_by
Created by string 40 Global sys_metadata
  sys_created_on
Created glide_date_time 40 Global sys_metadata
 
K
sys_id
Sys ID GUID 32 Global sys_search_genius_result_field
  sys_mod_count
Updates integer 40 Global sys_metadata
  sys_name
Display name string 255 Global sys_metadata
  sys_package
Package reference 32 Global sys_package sys_metadata
  sys_policy
Protection policy string[choice] 40 Global sys_metadata
  sys_scope
Application reference 32 Global sys_scope sys_metadata
  sys_updated_by
Updated by string 40 Global sys_metadata
  sys_updated_on
Updated glide_date_time 40 Global sys_metadata
  sys_update_name
Update name string 250 Global sys_metadata
  table_reference
Table reference boolean 40 Global sys_dictionary
  text_index
Text index boolean 40 Global sys_dictionary
  unique
Unique boolean 40 Global sys_dictionary
  use_dependent_field
Use dependent field boolean 40 Global sys_dictionary
  use_dynamic_default
Use dynamic default boolean 40 Global sys_dictionary
  use_reference_qualifier
Use reference qualifier string[choice] 40 Global sys_dictionary
  virtual
Calculated boolean 40 Global sys_dictionary
  virtual_type
Calculation Type string[choice] 40 Global sys_dictionary
  widget
Widget string 40 Global sys_dictionary
  write_roles
Write roles user_roles 255 Global sys_dictionary
  xml_view
XML view boolean 40 Global sys_dictionary
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Sandiego
formula missing
virtual_type missing

Referenced

sys_dictionary referenced from table:
cmdb_data_management_policy, m2m_dictionary_dataclass, sys_hub_action_output, sys_index, sys_schema_attribute, sys_schema_attribute_m2m
sys_metadata referenced from table:
one_api_feature_provider, sys_delete_recovery, sys_metadata_delete, sys_metadata_delete_related
sys_search_genius_result_field referenced from table:
v_search_genius_result
var_dictionary referenced from table:
sys_hub_flow_logic, sys_variable_value

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out