Written by

CHR (Liège - Belgium/Belgique)

Question Michel Bruyère · Sep 30, 2021

Portal's category.

#Caché #API #ObjectScript

Hello,

I’m looking for a way to find out which category of portal a connector belongs to. I looked at the class ‘Ens.Config.Production’ and ‘Ens.Config.Item’ but without success.

An idea about the ‘ObjectScript’ code to design?

Best Regards.

Product version: Caché 2018.1

$ZV: Cache for Windows (x86-64) 2018.1.4 (Build 505_1U) Thu May 28 2020 10:01:40 EDT [HealthShare Modules:Core:15.032.9035 + Linkage Engine:15.032.9035]

Discussion (11)2

Add reply

Comments

Marc Mundt · Sep 30, 2021

Category is indeed stored in Ens.Config.Item.

You can access it through SQL:

SELECT Category from Ens_Config.Item

Or using objects:

DEMO>set confItem=##class(Ens.Config.Item).%OpenId(316)

DEMO>write confItem.Category
Test1

0 0

Michel Bruyère Oct 1, 2021 to Marc Mundt

Thank you for your answer.

But what I want to have as a result is: by giving a class name (..%ClassName()) or package name ($CLASSNAME()), the name of the portal category is provided to me.

How to know the ID?

0 0

Marc Mundt Oct 1, 2021 to Michel Bruyère

You can query Ens_Config.Item on ClassName:

SELECT ID, Category FROM Ens_Config.Item WHERE ClassName = "EnsLib.HL7.Service.FileService"

But you'll want to keep in mind that a production can have multiple items that use the same class, so this query could return multiple rows all with different categories.

Category applies to the item as it is configured in the production, not to the underlying class it uses.

0 0

Vic Sun · Sep 30, 2021

Hello Michel,

Ens.Config.Item has a Category property. Is that what you are looking for?

sample:

TEST>s item=##class(Ens.Config.Item).%OpenId(244)

TEST>w item.Category
"test.cat"

0 0

Michel Bruyère Oct 1, 2021 to Vic Sun

Thank you for your answer.

But what I want to have as a result is: by giving a class name (..%ClassName()) or package name ($CLASSNAME()), the name of the portal category is provided to me.
How to know the ID?

0 0

Jeffrey Drumm Oct 1, 2021 to Michel Bruyère

Multiple Production Items will use the same class (for example, the HL7 TCP Services/Processes), and categories are a Production Item property. You would need to determine first which items are using that class, then get the categories from those items.

Is that what you're looking to do?

0 0

Michel Bruyère Oct 1, 2021 to Jeffrey Drumm

The class can be ' citadelle.labo.bs.FileXmlTransLaboIn ' in COS.

In case of a problem, an email is sent to the IT cell and currently, the category is a parameter of the connector.

Sample code (in French) :

SET msg.Body = msg.Body_"<br/><u>Infos pour le service EAI</u> :<br/>Le connecteur de 'Service' en charge de cette tâche est répertorié dans la catégorie '"_.."Catégorie"_"'.<br/>"

SET msg.Body = msg.Body_"Il se dénomme '"_..%ClassName()_"' et le package/classe : '"_$CLASSNAME()_"'.<br/><br/>"

I want to stop using this parameter.

0 0

Jeffrey Drumm Oct 1, 2021 to Michel Bruyère

The EnsLib.* classes don't have inherent categories. You can certainly add a Category property to classes that you create, though.

0 0

Marc Mundt Oct 1, 2021 to Michel Bruyère

If this code is being run in FileXmlTransLaboIn, you can get the name of the config item from %Ensemble("ConfigName") and then query based on that.

set configName=%Ensemble("ConfigName")
&sql(SELECT Category INTO :itemCat FROM Ens_Config.Item WHERE Name=:configName)

0 0

Michel Bruyère Oct 5, 2021 to Marc Mundt

Thanks.
I will use :

&SQL(SELECT Category INTO :itemCat FROM Ens_Config.Item WHERE Name=:%Ensemble("ConfigName"))

0 0

Michel Bruyère · Oct 1, 2021

Currently I can find out with this SQL query :

Select Category
From Ens_Config.Item
Where ClassName Like 'citadelle.labo.bs.FileXmlTransLaboIn%'

I would like to do this using the existing classes of 'Ens' or 'EnsLib'.

0 0