HS.FHIRServer.Storage.Json.SearchColumn

persistent class HS.FHIRServer.Storage.Json.SearchColumn extends %Library.Persistent

SQL Table Name: HS_FHIRServer_Storage_Json.SearchColumn

Property Inventory

• Added
• ColumnName
• DataType
• Definition
• FHIRPath
• IndexType
• ParamName
• RepoKey
• ResourceType
• ServiceKey
• TableName
• Target
• Type
• isMultiValue

Method Inventory

• GenerateFromMeta()
• GenerateFromStrategy()
• GetStorageType()
• RegenerateFromStrategy()
• deleteColumnsForService()
• getAddedParametersForServiceId()
• getById()
• getChangedTableListForRepoId()
• getColumnIdsForRepoTable()
• getParamIdListForType()
• getTableListForRepoId()
• getTableListForRepoIdEx()
• resetAdded()
• resetAddedForTable()
• test()
• testAdd()
• testMerge()

Parameters

parameter BitmapIndex = 2;

parameter NoIndex = 1;

parameter PlainIndex = 0;

Properties

property Added as %Boolean;

Property methods: AddedDisplayToLogical(), AddedGet(), AddedGetStored(), AddedIsValid(), AddedLogicalToDisplay(), AddedNormalize(), AddedSet()

property ColumnName as %String;

Property methods: ColumnNameDisplayToLogical(), ColumnNameGet(), ColumnNameGetStored(), ColumnNameIsValid(), ColumnNameLogicalToDisplay(), ColumnNameLogicalToOdbc(), ColumnNameNormalize(), ColumnNameSet()

property DataType as %String;

Property methods: DataTypeDisplayToLogical(), DataTypeGet(), DataTypeGetStored(), DataTypeIsValid(), DataTypeLogicalToDisplay(), DataTypeLogicalToOdbc(), DataTypeNormalize(), DataTypeSet()

property Definition as %String (MAXLEN = 2000);

the canonical URL for this search param. e.g. http://hl7.org/fhir/us/core/SearchParameter/us-core-race|3.1.0

Property methods: DefinitionDisplayToLogical(), DefinitionGet(), DefinitionGetStored(), DefinitionIsValid(), DefinitionLogicalToDisplay(), DefinitionLogicalToOdbc(), DefinitionNormalize(), DefinitionSet()

property FHIRPath as %String (MAXLEN = 500);

Property methods: FHIRPathDisplayToLogical(), FHIRPathGet(), FHIRPathGetStored(), FHIRPathIsValid(), FHIRPathLogicalToDisplay(), FHIRPathLogicalToOdbc(), FHIRPathNormalize(), FHIRPathSet()

property IndexType as %Integer;

Property methods: IndexTypeDisplayToLogical(), IndexTypeGet(), IndexTypeGetStored(), IndexTypeIsValid(), IndexTypeLogicalToDisplay(), IndexTypeNormalize(), IndexTypeSet()

property ParamName as %String;

Property methods: ParamNameDisplayToLogical(), ParamNameGet(), ParamNameGetStored(), ParamNameIsValid(), ParamNameLogicalToDisplay(), ParamNameLogicalToOdbc(), ParamNameNormalize(), ParamNameSet()

property RepoKey as %String;

Property methods: RepoKeyDisplayToLogical(), RepoKeyGet(), RepoKeyGetStored(), RepoKeyIsValid(), RepoKeyLogicalToDisplay(), RepoKeyLogicalToOdbc(), RepoKeyNormalize(), RepoKeySet()

property ResourceType as %String;

Property methods: ResourceTypeDisplayToLogical(), ResourceTypeGet(), ResourceTypeGetStored(), ResourceTypeIsValid(), ResourceTypeLogicalToDisplay(), ResourceTypeLogicalToOdbc(), ResourceTypeNormalize(), ResourceTypeSet()

property ServiceKey as %String;

Property methods: ServiceKeyDisplayToLogical(), ServiceKeyGet(), ServiceKeyGetStored(), ServiceKeyIsValid(), ServiceKeyLogicalToDisplay(), ServiceKeyLogicalToOdbc(), ServiceKeyNormalize(), ServiceKeySet()

property TableName as %String;

Property methods: TableNameDisplayToLogical(), TableNameGet(), TableNameGetStored(), TableNameIsValid(), TableNameLogicalToDisplay(), TableNameLogicalToOdbc(), TableNameNormalize(), TableNameSet()

property Target as %String);

Property methods: TargetDisplayToLogical(), TargetGet(), TargetGetStored(), TargetIsValid(), TargetLogicalToDisplay(), TargetLogicalToOdbc(), TargetNormalize(), TargetSet()

property Type as %String;

Property methods: TypeDisplayToLogical(), TypeGet(), TypeGetStored(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

property isMultiValue as %Boolean;

Property methods: isMultiValueDisplayToLogical(), isMultiValueGet(), isMultiValueGetStored(), isMultiValueIsValid(), isMultiValueLogicalToDisplay(), isMultiValueNormalize(), isMultiValueSet()

Methods

classmethod GenerateFromMeta(pMetaAPI As HS.FHIRMeta.API, pRepoKey As %String, pServiceKey As %String)

Generate the SearchColumn table rows using a specified FHIRMeta API object, and the repo and service keys to associate to the generated table rows.

classmethod GenerateFromStrategy(strategy As HS.FHIRServer.API.InteractionsStrategy)

classmethod GetStorageType(param As HS.FHIRMeta.SearchParam) as %String

Calculates the datatype that we will use to store the values for this search parameter.

classmethod RegenerateFromStrategy(strategy As HS.FHIRServer.API.InteractionsStrategy)

classmethod deleteColumnsForService(serviceKey As %String)

classmethod getAddedParametersForServiceId(serviceId As %String) as %List

classmethod getById(id As %String) as HS.FHIRServer.Storage.Json.SearchColumn

classmethod getChangedTableListForRepoId(repoId As %String) as %List

classmethod getColumnIdsForRepoTable(repoId As %String, tableName As %String) as %List

Returns a %List of SearchColumn id's for a specified table.

classmethod getParamIdListForType(resourceType As %String, serviceKey As %String) as %List

classmethod getTableListForRepoId(repoId As %String) as %List

Returns a %List of table names used by the specified Repo.

classmethod getTableListForRepoIdEx(repoId As %String) as %List

Returns a %List of table names, resource types, and service keys used by the specified Repo.

classmethod resetAdded(repoKey As %String)

classmethod resetAddedForTable(repoKey As %String, tableName As %String)

classmethod test(id As %String = "4||4", generateOnly As %Boolean = 1)

classmethod testAdd(id As %String = "7", metaKey="USCore40")

classmethod testMerge(id As %String = "3||3", generateOnly As %Boolean = 1)

Indexes

index ($SearchColumn on ) [Extent, Type = bitmap];

index (AddedIdx on Added) [Type = bitmap];

index (DataTypeIdx on DataType) [Type = bitmap];

index (DefinitionIdx on Definition);

Index methods: DefinitionIdxExists()

index (IDKEY on ) [IdKey, Type = key];

Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

index (NameIdx on ServiceKey,ParamName);

Index methods: NameIdxExists()

index (RepoKeyIdx on RepoKey) [Type = bitmap];

index (RepoTypeIdx on RepoKey,ResourceType,ParamName);

Index methods: RepoTypeIdxExists()

index (ResourceTypeIdx on ResourceType) [Type = bitmap];

index (ServiceKeyIdx on ServiceKey) [Type = bitmap];

index (TableIdx on RepoKey,TableName);

Index methods: TableIdxExists()

index (Type on Type) [Type = bitmap];

Index methods: TypeDisplayToLogical(), TypeGet(), TypeGetStored(), TypeIdxExists(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

index (TypeIdx on ServiceKey,ResourceType);

Index methods: TypeIdxExists()