Could you share your code with us?
Hi @YURI MARX GOMES I have got a few topics that maybe could help you/help us with the certification exam
InterSystems IRIS Core Solutions Developer Specialist
Recommended preparation: Complete available IRIS development learning content
Classroom: Developing with InterSystems Objects and SQL
#Overview Benefits Features Platforms and Versions
#Development Introduction Introduction to classes and methods Packages Persistent and serial classes Errors
#Architecture Namespaces and databases Globals and routines System databases Naming conventions
#Classes OOP/SQL correspondence Classes revisited Multiple inheritance Class compilation $System
#Properties Properties Datatypes Accessor and mutator methods Reference properties Implicit joins Foreign keys Cloning objects Computed properties
#Unit Testing Unit testing Benefits Framework
#Collections Collections List collections Array collections Object collections Data population
#Relationships Relationships Many-to-many relationships Performance options
#Streams and Files Streams Files
#Queries Sets of results Embedded SQL Dynamic SQL SQL stored procedures Command line shell Views Other SQL features
#Indexes and Tuning Indexes Indexing options Collation Index types Query performance tuning Index methods
#Methods Inherited methods Scripting languages Method attributes OOP callback methods SQL triggers ProcedureBlock methods Code mode Special method syntax #Debugging Debugging with Studio Debugging with ZBreak
Hi @Luiz Henrique Carvalho Martarelli
You can take a look at this post: Trigger or Callback?https://community.intersystems.com/post/trigger-or-callbackAnd for more detail information: Using Triggershttps://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_triggers
If you have interested, the Developer Community has a Discord with a dedicated Channel for Portuguese Speakers. https://discord.gg/dzzPDvY
Hi @John Lisa
You can use IRIS Management Portal. There is a built-in tool to extract information using SQL.
The Path is: System Explorer > SQL
Inside the SQL Explorer, you can change to your preferred Namespace and have access to your tables, as you can see in the image below:
Hope that helps.
Best Regards, Henrique
If you want to develop/design reports. Jasper Studios is what you looking for.
Free and simple
If you want to try J-Report, here is a link for the trial version:
https://www.jinfonet.com/product/download-jreport/For an OpenSource alternative, you can take a look at Jasper Reports Community Edition
I used to work with Jasper Reports to generate PDF reports for my customers. To connect to InterSystems IRIS, use the ODBC and voilá.
As mentioned by @Carmen Logue , if you tell us your reporting requirements, that should be easier to discuss alternatives.
To leave a comment or answer to post please log in
Please log in
To leave a post please log in