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
• FHIRPath
• IndexType
• ParamName
• RepoKey
• ResourceType
• ServiceKey
• TableName
• Target
• Type
• isMultiValue

Method Inventory

• CreateColumn()
• GenerateFromMeta()
• GenerateFromStrategy()
• GetStorageType()
• RegenerateFromStrategy()
• deleteColumnsForService()
• getAddedParametersForServiceId()
• getById()
• getChangedTableListForRepoId()
• getColumnIdsForRepoTable()
• getParamIdListForType()
• getTableListForRepoId()
• getTableListForRepoIdEx()
• merge()
• 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 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 CreateColumn(repoMgr As HS.FHIRServer.API.RepoManager, serviceKey As %String, param As HS.FHIRMeta.SearchParam, isNew As %Boolean)

classmethod GenerateFromMeta(meta As HS.FHIRMeta.API, repoKey As %String, serviceKey As %String)

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 merge(repoKey As %String, serviceKey As %String, newServiceKey As %String = "")

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 (IDKEY on ) [IdKey, Type = key];

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

index (NameIdx on ServiceKey,ParamName);

Index methods: NameIdxExists()

index (RepoTypeIdx on RepoKey,ResourceType,ParamName);

Index methods: RepoTypeIdxExists()

index (TableIdx on RepoKey,TableName);

Index methods: TableIdxExists()

index (TypeIdx on ServiceKey,ResourceType);

Index methods: TypeIdxExists()