Posts by Guillaume Lepretre on InterSystems Developer Community

Question

Guillaume Lepretre · Mar 24, 2020

Validating XML file with DTD

HI,

I want to validate my XML file with a DTD file.

I found this https://community.intersystems.com/post/validating-xml but it's with the SAX parser...

Is there an easier solution?

Intersytems Ensemble version 2017.2

Regards,

Guillaume LEPRETRE

#XML #Ensemble

1 1

0 284

Question

Guillaume Lepretre · Dec 4, 2019

[Ensemble] Req table with big data

Hello,

I've got a table with many attributes and data. There is 10 000 000 registrations approximatly.

I need to make a research on this table with filters, paging, and order.

You can see an example of my SQL request :

SELECT * FROM ( SELECT TOP ALL * FROM ANCV_Data.Titre WHERE etatTitre = 'Emis' ORDER BY numRemise desc) v WHERE %vid BETWEEN 1 AND 25

Cause there are many data on my table, my SQL req is too long if I don't have index on my attributes BUT there are many associations possible...

#SQL #Ensemble

0 1

0 234

Question

Guillaume Lepretre · Oct 18, 2018

Use parameter in Select Component

Hello everyone,

I want to fill data into my select component with sql request and parameter.

I tried to follow this example https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...

I need to call a method because my parameter can be different. I tried something like this but it doesn't work...

#Caché #SQL #ZEN

0 2

1 294

Question

Guillaume Lepretre · Jun 20, 2018

[Intersystems 2017] Use the email alert request

Hello,

I used the operation : EnsLib.EMail.AlertOperation to send mail to handle error. However, I want to get more information about the error (session ID message, the date, the namespace... etc).

what is the best way to do it?

I tried to add informations in OnAlertRequest method as below but I need to change mail operation from all namespaces...

#Business Operation #Error Handling #Ensemble

1 4

0 553

Question

Guillaume Lepretre · May 14, 2018

Get request header (REST API)

Hello,

In all web services, i need to my get login and token. So with Postman, i tried to call a HTTP request where I put the login/token in the header :

I tried to get data from Http request header. The REST APi use %CSP.REST. I tried something like that :

But it didn't work..

Someone can give me some example or other method ?

Regards,

#API #Ensemble #REST API #Caché

0 2

0 1.8K