I (agrup=1) {

            S COD = query.Get("pscodigo")

            I (COD="") S COD = "000" DESC = query.Get("psnome")

            I (DESC="") S DESC = "NAO DEFINIDO" (ordenacao=1)

            S K2=DESC_"^"_COD S K2=expert.completaString(COD,0,6)_"^"_DESC

}

S K3 = descrProd_"^"_codProduto_"^"_idProduto S ^mtempJOB(controladorjob,K1,K2,K3)=$LB(...)

Sometimes the studio consumes a lot of memory and crashes during some processes.

In summary, I need to do an ordering within another order in a report.

I have the ordering of the main grouping, and I need to sort the items in that grouping.

Thank's!

Yes, we create a component in javaScript, it sends a CACHE function to the text file, the internal function created in CACHE, this text is converted to base 64, and then we save the text (url of the file) .

ClassMethod enviarAnexo(idEncriptado As %String, nomeArquivo As %String, streamArquivo As %CSP.CharacterStream) As %String
{
    #dim id AS %String
    #dim resposta AS %String = ""
    #dim exception AS %Exception.AbstractException
    #dim estimativa AS EstimativaPrecoVenda    

    try {
        set id = ##class(%CSP.Page).Decrypt( idEncriptado )        
        if (..%ExistsId(id)){
            set estimativa =  ..%OpenId(id)            
             do estimativa.anexo.send(nomeArquivo, streamArquivo)            
             do estimativa.%Save()
            set resposta = $$$OK
        }
    } catch exception {
        set resposta = $$$FormatText("%1 - %2",exception.Name, exception.Data)
    }
    
    quit resposta
}

Method send(nameFile As %String, streamFile As %CSP.CharacterStream) As %Status
{
    #dim stream As %FileBinaryStream    
    set stream = ##class(GlobalBinaryStreamUtil).convertDataStream( streamFile )
    
    do ##class(GlobalBinaryStreamSpec).validateNameFile( nameFile )
    do ##class(GlobalBinaryStreamSpec).validateExtensionFile( nameFile )
    do ##class(GlobalBinaryStreamSpec).validateSizeFile( stream.Size )
    
    do ..strnameSet( ##class(GlobalBinaryStreamUtil).sanitizeName(nameFile) )
    do ..objfile.CopyFromAndSave( stream )
    
    quit $$$OK
}

ClassMethod convertDataStream(streamFile As %CSP.CharacterStream) As %FileBinaryStream
{
    #dim stream As %FileBinaryStream
    #dim text As %String
    
    set stream  = ##class(%FileBinaryStream).%New()
    if ($isObject(streamFile)){        
        set text = streamFile.Read( streamFile.Size )
        do stream.Write( ..convertTextPlain( text ) )
    } else {
        do stream.Write( ..convertTextPlain( streamFile ) )
    }
    quit stream
}

ClassMethod convertTextPlain(streamFile As %String) As %String [ Private ]
{
    #dim textPlain As %String
    #dim exception AS %Exception.AbstractException
    
    try {
        set textPlain = $SYSTEM.Encryption.Base64Decode(streamFile)
    } catch exception {
        if ( exception.Name = "<ILLEGAL VALUE>"){
            set textPlain = streamFile
        } else {
            throw exception
        }
    }
    quit textPlain
}

ClassMethod sanitizeName(nameFile As %String) As %String
{
    quit $translate(nameFile," ","_")
}

We managed to find a stopgap solution that proved interesting:

in component

<Select>
     <Option value = "COMMERCIAL ANALYSIS"> </ option>
</ Select>

We added the value of the displayList that is in the Property.

In this way we managed to do the system to display and save the information without any problems.

Do you think it can cause some other problem?

If you find any other way to be better, I'll be waiting.

Yes I tried to do this, but the select component used here is not the standard, then I would have to insert this tag within the component.

I will examine this possibility.

Thank you!

The values are reported on the screen by cspbind property.

Property spdstatusfinalizado As %Integer(CAPTION = "Status do pedido finalizado", DISPLAYLIST = ",ANÁLISE COMERCIAL,ANÁLISE FINANCEIRA,EM CARTEIRA", VALUELIST = ",1,2,5") [ InitialExpression = 1 ];