Hi, 

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 

https://learning.intersystems.com/enrol/index.php?id=196 

https://learning.intersystems.com/enrol/index.php?id=1038

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?K...

https://learning.intersystems.com/enrol/index.php?id=959

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-callback

And for more detail information: Using Triggers
https://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

Best Regards,
Henrique

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

@Saptarshi Sengupta 

If you want to develop/design reports. Jasper Studios is what you looking for.

Free and simple

Hi, 

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 

https://community.jaspersoft.com/

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.