Search

was the primary subject of exploration. With iFind, we stick to regular SQL tables, on which an iFind index is defined. An iFind index is an implementation of the Functional Index

Solon. cheatsheet is really helpfull Thanks to @Muhammad.Waseem I'm posting an updated version of the "Cheat Sheet." how about adding a note about the fact that each index

Hello All,what is the best method for search a portion of text in a non-indexed global?I need to implement an autocomplete kind of search, in a global of >1M registers (text

Here is a snippet that I learned yesterday You can define an index on a collection property but when I tried to use it, I failed. I was using Select ….. where …. :xx

clearly want that indexed as it's a great way to look someone up. We know that sometimes we're going to have to look people up by name, so we'll want a name index, too

Just wondering an Insight in the difference between these two indexesIdKey / PrimaryKey================= Property Identifier As %IntegerIndex Index1 on Identifier [Idkey]Index

I have an XML I am sending to an operation from a BPL. This is a query for Patient information from Epic using a web service. I created the operation using the add-in in Studio

I have an SQL text index defined like this Index TextIndex On (Text) As %iFind.Index.Basic(IGNOREPUNCTUATION = 1, INDEXOPTION = 0, LANGUAGE = "en", LOWER = 1); If I run a query

($SYSTEM.Util.UTCtoLocalWithZTIMEZONE($ZTIMESTAMP), 3, 1, 0) }]; Index CityId ON CityId; Index State ON State; Index Longitude ON Longitude; Index Latitude ON Latitude; Index Status

, there are also segments related to the patient and order. Since patient information uses the same segments in different messages I won't go into details - an example of version 2.5

the XSL files, I see some very good comments like the following: <!-- Field : Patient Name Target: HS.SDA3.Patient Name Target

Parameter. 1. At the beginning, I have created 2 persistent classes to support Populate Utility( Extends (%Persistent, %Populate)): popPatient which aim to populate patients

Hello Community, I've created my FHIR patient profile and POST into FHIR endpoint in Intersystems FHIR Server. http:localhost:52773/fhirr4/StructureDefinition I use

index. /// Define an index for <property>Name</property>.Index NameIDX On Name [ Data = (Name, Home.State, SSN) ]; And being experienced and comfortable