I know &SQL returns only one result but is

&SQL(SELECT ID FROM Cinema.Film ORDER BY ID DESC)

and

&SQL(SELECT TOP 1 ID FROM Cinema.Film ORDER BY ID DESC)

the same in terms of processing required?

I have iKnow domain of forum posts, their full text is an iKnow data, and each post also has a number of views as a metadata field.

I want to get a sum of views by concept. Let's say I have a concept called "TESTEST" and there are 10 sources that have this concept. Each source has some views. I want to get views total - impact of this concept so to say.

What's the best iKnow architecture for this use case?

So far I got this:

After creating a ClassMethod for a routing rule is it possible to test an HL7 message within Studio rather than using Management portal? It would make it easier to debug the custom function to see where the rule is failing.

There seems to be a problem with the sync/save. If I open a CSP file, add a CRLF to end of it and save the file I get a sync conflict. This can't be right.

To make matters worse I can then select to the local version and will then end up in an infinite loop where the CSP import/compiler keeps adding more and more CRLFs to the file.

You can see an example here: https://youtu.be/EY-_FA-kOpI

Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri...
I've used the "year" level instead of a pivot variable.
I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD]
I create a new calculated member, under the same dimmension with the above expression.

I am new to Intersystems and I am wondering if there exists a NYC tri-state regional or NE regional group for Ensemble?

If anyone has any information, please reply.

Thanks,

George Cornejo

NYC Health and Hospitals Corporation

55 Water Street

NY, NY

We are working to build one. Without DeepSee. Regardless of whether you use Deepsee or not, what are some metrics you monitor?

If you don't use DeepSee, what do you use?

Hello all, i am new to IRIS in combination with VSCode, can anyone guide why this error appears ? Any suggestions are welcome. Thank you in advance.

Hello and welcome to the Developer Ecosystem Spring News!

This spring we've had a lot of online and offline activities in the InterSystems Developer Ecosystem. In case you missed something, we've prepared for you a selection of the hottest news and topics to catch up on!

Hi Team,

How InterSystems cache calculate the license count based on process?

How to we determine the product required license count ?

Thanks

Rathinakumar

Hi

I'm using an embedded SQL statement with a a cursor-based Embedded SQL query that uses host variables in the where clause, however, what I'm doing doesn't seem to work. Can anyone help?

The code I'm using is

Hi,

I have a requirement to convert few screens having character based interface built in Cache to a web based interface in Java while still keeping Cache as the backend which means database will remain the same. Wanted to know if we have any tool in the market which can help doing that keeping in consideration that these screens in cache are using mumps code.

If we don't have any tool, would appreciate if someone shares their experience in the manual conversion as well.

Hi-

I have a SQL Query using %iFind.Highlight which returns text highlighting certain words and phrases. %iFind.Highlight seems to remove cr/lf from the returned text.

Here's my query

ClassMethod Search(pSessionId As %String, pSearchString As %String) As %String
{
set tTags="<span style='background-color:yellow;'>"
&sql(
SELECT %iFind.Highlight(Text , :pSearchString , , :tTags) into :results
FROM SSA_OCR.TempSearchable where sessionId = :pSessionId)
quit results
}

Hi, world , i want to program a task for my adapterless business service for it be invoked each houre in the day by sending a trigger to my business process .

thank's