Question Vivian Lee · Jul 7, 2023 %CONTAINS doesn't work with "time" string Is "time" a reserved word in the %CONTAINS function? When I run the following SQL query, I get 0 matching results SELECT ID, text FROM Test.Sentence WHERE text %CONTAINS('time') OR text %CONTAINS('time ') OR text %CONTAINS(' time') However, when I run a query where the search string contains words other than "time" alone, it returns the expected matching results #SQL #InterSystems IRIS 1 7 1 269
Question Vivian Lee · Dec 20, 2021 Having trouble sending an HTTP POST request with form-data from Angular app to Cache backend I'm trying to send an HTTP POST request with form-data from an Angular app to a Cache backend, but my request fails with a 406 Not Acceptable error. #REST API #Caché #Other 1 2 0 12.8K
Question Vivian Lee · Nov 18, 2021 Create Calculated Property in Persistent Class based on Relationship Hi Dev Community, I have a persistent Document class that has a FileName string property and another Question class that has an optional one-to-many relationship with Document. I'm trying to add a SqlComputed property to the Question class (docFileName) where docFileName = Document.FileName if there is a related Document or an empty string if there isn't one. I'd prefer the property to be SqlComputed so that if Question.Document changes, Question.docFileName will automatically update. #ObjectScript #SQL #InterSystems IRIS 0 12 0 387