Search

The table/class will specify an index on a column, and Caché will create and maintain that index automatically. I also tried this method and I didn't have the desired respond.

updates.This allows users safely back onto a system while new indexes are being built.It reduces or eliminates patching downtime for end user.Can also allow application specialists

Designs IRIS SQL applications 1.1 Designs a SQL schema Distinguishes use cases for row vs columnar table layout Distinguishes use cases for different index types 1.2

%Push({ "index": (i), "pid": (rs.%Get("ID")), "ssn" : (rs.%Get("SSN")), "age": (rs.%Get("Age"))}) //do results.%Push(+rs.

Also I would double-check if database HSTMDATADEV indeed has packages, based on its name it looks like it could have only data, and there is also HSTMCODEDEV where actual packages are

KEY=RSQL_grant#RSQL_grant_synopsis I think @akoblov actually meant "Yes" :-), as row-level security was indeed designed for exactly this purpose, to inject additional filters into queries

Regards Mike Hi Mike, Indeed, there is no HealthConnect (HealthShare Connect) Community Edition, but with IRIS for Health Community edition you can do the same as HealthConnect

There are multiple ID's for a given %ConfigName, but no indexing was observed. I received SQLCODE 100 only in TEST. In PROD i was able to fetch rows.

];Property Name As %String;Index Name On Name;Property Type As %String(DISPLAYLIST = ",Sveže,Zmrznjeno,Dodelava", VALUELIST = ",FRE,FRO,FIN");Property CUsInTU As %Integer;Property

Just indexes not enough, you need right indexes and right queries. I think it will be much more productive if you provide some examples of your classes with populate, and queries.

Another option is that some table is too big, and someone would like to split it to be stored in multiple different databases, together with the indexes.

The solution was adding .trim() to the end, so: FruitSelected=$('[name='Nameoftheradiobuttonhere]:checked').parent().text().trim(); Then everything works as it should.

%New() set param.Name=name set param.Default=value // adding the parameter to the parent class do

Determine the size of one index. It will include all descendants within the specified range.

Idea Author RPMShare - Database solution for remote patient | InterSystems Ideas @Dmitry Alexeev HL7 test message generator @Vadim Aniskin Introduce an Interoperability adapter