go to post Henrique Dias · Nov 11, 2020 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
go to post Henrique Dias · Jul 24, 2020 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 Best Regards,Henrique
go to post Henrique Dias · Jul 16, 2020 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
go to post Henrique Dias · Feb 3, 2020 @Saptarshi Sengupta If you want to develop/design reports. Jasper Studios is what you looking for. Free and simple
go to post Henrique Dias · Jan 27, 2020 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.
go to post
Hi,
Could you share your code with us?
go to post
Hi @YURI MARX GOMES
with the certification exam
I have got a few topics that maybe could help you/help us
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
go to post
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
go to post
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
go to post
@Saptarshi Sengupta
If you want to develop/design reports. Jasper Studios is what you looking for.
Free and simple
go to post
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.