If you are on Windows, then you should have an .iris_history file on C:\Users\<yourusername>\.   Deleting this will clear your history

I see my mistake above, mixing Type and IdType.  Either 

IDTYPE = 'EMPLOYEE_NUMBER'

OR

TYPE ='NUM'

should give you results 

Not sure if this is quite matching your use case, but OPEN and USE are what allow for redirection of standard Input and Output

Docs are at https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

The following SQL should do it

CREATE UNIQUE INDEX ON TABLE <table> (field1, field2)

You will then want to stop all operations against the data and build the index

Hi Krishnaveni

There are 2 answers to this. The easy but wrong way , and the more correct way

The easy way would be to take the piece of the string before the space character, and then remove all nonNumeric chars

set output = $ZSTRIP($PIECE(input," ",1),"*AP")

The better was is to convert to the canonical date format, then convert back to the format you want.  Relevant documentation page: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

set internaldate = $ZDATETIMEH(input,3)

set outputdate = $ZDATE(internaldate,8)

If you just want a very basic conversion (i.e. not converting to a canonical date type first), then this will work

set dt = "2024-05-31T17:33:08+01:00"

set formatteddt=$ZSTRIP($PIECE(dt,"+",1),"*WPA")

write formatteddt

20240531173308

So, there's 2 ways to read this, either we want an "exists" check, or following the SQL, we want a count of all instances.   This snippet can be set to do either case based on the existscheck boolean.  Ideally though, you would have an index defined, and this could be read much more efficiently than having to scan an entire global

set count=0
set existscheck=0 //Set to 1 if we only want to find first instance
set targetValue=1329
set key = ""
for   {
    set key = $ORDER(^DataTest(key))
    quit:key=""
    if targetvalue = +$LG(^DataTest(key),2) do $INCREMENT(count)
    quit:existscheck&&count
}
w !,"Count value is "_count

You absolutely can do this.   Each namespace is set with a Globals DB and a Routines DB.   The Globals are your default data storage, and the Routines are where your code lives

Further to this, there are an array of mapping features allowing your data and code to be spread over multiple databases.   You can read more about this here: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Having just done the same thing today, following Marc's comment (which is the same code in the documentation for MIMEParts) should get you what you need.

As it stands, I'm pretty sure you are just passing a handle to a stream to the FormData, rather than referencing the content of the stream.  This section of the example will correctly populate the HTTP Request body:

  // Write out Root MIME Element (containing sub-MIME parts) to HTTP Request Body.
    Set writer = ##class(%Net.MIMEWriter).%New()
    Set sc = writer.OutputToStream(tHttpRequest.EntityBody)
    if $$$ISERR(sc) {do $SYSTEM.Status.DisplayError(sc) Quit}
    Set sc = writer.WriteMIMEBody(rootMIME)
    if $$$ISERR(sc) {do $SYSTEM.Status.DisplayError(sc) Quit}

A handy way to find the process is to check your lock table.  These processes will typically take out a lock based on the Task ID.   This can be used to find the process, examine it and kill it if required.

It's also possible in some cases for the process to die and not update the task, and this can account for no processes matching this criteria

Based on this error: SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure , you probably want to enable SSLv3 on your SSLConfig. It's showing as disabled in your screenshot

This type of request is handled via your contract arrangements, so the best route is to engage your support service who will be happy to get you the assistance you require

HI Ben, 

I believe this is implemented specifically on each mail server and client, so there is no standard for it: See https://www.chilkatsoft.com/p/p_471.asp for details

You can set these headers, but there's no guarantee the client or receiving server will take note of them

HTH

Chris

HI Denny

Trakcare publishes it's CSPs as Deployed, so a standard install will not contain a user friendly way to view them

HTH

Chris

HI Fabio

I've built it into my Authentication routine on my REST services, as all of my functionality goes through REST.  I created a simple Audit class, and had each call to the Authentication include information specific to which service called it.

HTH

Chris

Reposting as an answer to get this removed from the "Unanswered questions" list

HI Rui

Unicode 0x3 is the ETX character, which can be used as newline in certain text editors.  Any control chars are disallowed in XML processing, so these should be stripped from whatever query you are using to drive this report

HTH

Chris

Yes, but using a relationship to do this would automate a lot of cross referencing.  For the example above, a 1-1 relationship would keep each side correct, when an update is made on either side

See http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... for more details

Hi Sofiane

I'm assuming you want to read this from a JSON payload.  You can follow the instructions in https://community.intersystems.com/post/lets-write-angular-1x-app-cach%C... to implement a fromJSON method, after reading the payload from the HTTPRequest

HTH

Chris

Hi Manoj

There's example code of reading a JSON string from a POST request, and then transforming it to an object in

https://community.intersystems.com/post/lets-write-angular-1x-app-cach%C3%A9-rest-backend-part-9

Hope that helps

Chris

Hi Confused

If you're a Trak customer, your best option is to raise a TRC to have the appropriate Support team assist.  However, IE11 isn't a fully supported platform for Layout Editor, though it will work.  You will need the Microsoft DHTML Editing Component at a minimum, this can be obtained from

https://www.microsoft.com/en-gb/download/details.aspx?id=8956

Hope this helps

Chris