INFORMATION.SCHEMA

Maybe using the property parameter :

(CONTENT = "ESCAPE")

Controlling Transformations of Values - Projecting Objects to XML - InterSystems IRIS Data Platform 2020.3
 

Hi Jens,

You need to setup the port in the adapter settings.

In the method SendFormDataArray all adapter settings is passed to http request object.

Hi Lucas,

That I have been know, ISC don't have native tool for data masking.

Look at this open source project, maybe help you.

GitHub - TheSoftwareHouse/fogger

I never been used this tool.

Regards.

Cristiano José da Silva.

Hi Muhammad,

See the documentation: 

https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fincrement#RCOS_fincrement_seq

Regards

Cristiano Silva

Hi Prashanth,

You need to create another web application with Authentication Method equal unauthenticated.

Default web application:

Unauthenticated Web Application:

Samples of access:

Regards.

Cristiano José da Silva.

Hi Harshdeep,

The error invalid of is like a Java NullPointerException  or NullReferenceException of .Net.

Check if intFaceDao or InterfaceDaoa are valid objects. Put these macros in you code e execute a test.

$$$LOGINFO("Check intFaceDado " _ ..Adapter.intFaceDao) $$$LOGINFO("Check DaoInterfaceDado" _ ..Adapter.intFace.DaoInterfaceDao)

After execution, see in the Envent Log the result.

Regards

Hi Nilson,

Check the credentials (username and password) the error reported was "Access denied".

Hi Rochdi,

The HTTP error 500 indicates that something happened in the server that's cause a error.

I suggest you to do a test using postman or similar REST tool. If the works fine, maybe you can posted the JSON with some problem.

Another suggest, change your code :

 While ('File.AtEnd) {
    s Line=Line_File.Read(1000)_$char(10)
  }
  do Httprequest.EntityBody.Write(Line)

By:
  do Httprequest.EntityBody.CopyFrom(File)

Regards.

Hi Evgeny,

You can handle deploy of Production Items and Configurations with the classes of package: Ens.Deployment

More about deployment of productions

Other way you can implement Production Source Control.

Regards.

Hi @Nezla 

Complementing @David Hockenbroch answer, you need to change the If statement, because we can't compare TimeStamp directly, even in the internal format, because in the comparision they are treated like strings.

Use some one of these methods:

$System.SQL.Functions.DATEDIFF 

##Class(%Library.UTC).Compare

##Class(%Library.UTC)Diff

Hi Andy,

The "problem" is that the Fetch is executed on the Namespace thats the zen page reside, and the data global doesn't exists or not mapped. A simple solution change the method to:

Method DataExtractionCurrent(Output tSC As%Status, pInfo As%ZEN.Auxiliary.QueryInfo) As%ResultSet [ ZenMethod ]
{
  New$Namespaceset$Namespace = "DATAEXTRACTION"    
  
  #Dim result As%ScrollableResultSet = ##Class(%ScrollableResultSet).%New("%DynamicQuery:SQL")
  Set tSC=result.Prepare("SELECT * from FairWarning_Table_Local.Logs")
  Write !, tSC    //  value of 1Set tSC = result.Execute()
  Write !, tSC    //  value of 1Set tSC = result.%Save() // The class use temp globals that are mappedWrite !, tSC    //  value of 1Return result
}

Bellow a test if your code:

The suggested code:

Regards

Hi Kevin,

You can set programatically the value of property AppTimeout of the class %CSP.Session when the user login in the application.

Hi Maciej,

You can execute this query to achieve what you want:

SELECTName,
  Super,
  CASEWHEN Super [ 'InboundAdapter'THEN'InboundAdapter'ELSE'OutboundAdapter'END"Type"FROM"%Dictionary".ClassDefinition
  WHERE
    Super LIKE'%InboundAdapter%'OR Super LIKE'%OutboundAdapter%'

In the IRIS 2021.1

Hi Patrik,

For a better readability of code, switch the Quit command by Return in the portions of your code. where you relay want to return.

For example in this codesnippet in the While:

W !, "BEGENING OF LOOP FOR: "_rs.articleCode
			IF (rs.article = article)
			{
				SET unitCode = rs.unitCode
				QUIT
			}

This Quit, only exit form While not from Method. Other problem is that the last line with Quit without argument can cause a <FUNCTION> error because doesn't return any value.

If I'm not miss understood, you can add a third parameter to use internally of method to check if the method needs to run or not. For example if the condition to stop is the unitCode is not blank change the signature of method and add the following line in the beginning of method:

A possible version to method is:

ClassMethod workpieceUnit(mainArticle As%String, article As%String, unitCode As%string = "") As%String
{
    Return:(unitCode '= "") unitCode
    
	&SQL(SELECT unit->unitCode INTO :unitCode FROM production_article.composition WHERE mainArticle = :mainArticle AND article = :article)
	
	IF SQLCODE = 0
	{
		W !, "Has Value"Return unitCode
	}
	ELSE
	{
		SET sql = "SELECT article, unit->unitCode,  production_article.composition_sqlArticleCode(article, type) AS articleCode FROM production_article.composition WHERE mainArticle = "_mainArticle_" AND type = 1",
		 	 rs = ##class(%SQL.Statement).%ExecDirect(,sql)
		 
		WHILE rs.%Next()
		{
			W !, "BEGENING OF LOOP FOR: "_rs.articleCode
			IF (rs.article = article)
			{
				SET unitCode = rs.unitCode
				Return unitCode
			}
			
			// CHECK IF WORKPIECE HAS COMPOSITION
			&SQL(SELECTCOUNT(*) INTO :composition FROM production_article.composition WHERE mainArticle = :rs.article)
			
			IF (composition > 0)
			{
				W !, "START RECURSIVE"DO..workpieceUnit(rs.article, article)
			}
		}
			
		W !, "END OF LOOP"Return unitCode
	}
	
	Return""
}