Is it possible to create not DB-specific LiveReports?

Hi,

I need to use date restrictions in our LiveReports but can't find if there is a not DB-specific way to operate with dates. For example, in Oracel I would use "TRUNC(sysdate)", but in MS SQL Server it's "CAST(getdate() as Date)", and Hana and PostgreSQL are having their own functions as well. So the question is is there a way to create a single LiveReport that will work with all supported databases?

Thanks,

Alex

Find more posts tagged with

Comments

sıɹɥɔ

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Alex,

LiveReports includes db-independent access to date/times for today/yesterday/tomorrow, this/next/last week, and this/next/last month. I'd suggest using those where possible.

It's not clear exactly what you're wanting to do but in general I'd try resisting the siren song of dbms vendor extensions and adopt standards where practical; in this case that means ANSI SQL. The term "CURRENT_TIMESTAMP" is standard and should be supported by major vendors.

-chris

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, January 20, 2016 9:00 AM
To: eLink Recipient
Subject: Is it possible to create not DB-specific LiveReports?

Is it possible to create not DB-specific LiveReports?

Posted by Gerasimov, Alexander On 01/20/2016 09:58 AM

Hi,I need to use date restrictions in our LiveReports but can't find if there is a not DB-specific way to operate with dates. For example, in Oracel I would use "TRUNC(sysdate)", but in MS SQL Server it's "CAST(getdate() as Date)", and Hana and PostgreSQL are having their own functions as well. So the question is is there a way to create a single LiveReport that will work with all supported databases?Thanks,Alex

Colin_Schmidt

There are specific ways MS SQL does things and there is the Oracle way. Having worked quite a bit in Oracle, I prefer it. When I worked at moving some LRs to MS SQL Server, I didn't like what I had to do to show certain field types. Oracle seemed more forgiving or adaptable. Concatenating fields: "||" in Oracle and "+" in MS/SQL....and numerous other ways of portraying data in the SELECT portion.

Just as UNIX is not the same in all platforms, regardless of ANSI or POSIX influence, you just have to adapt to the platform. I don't think there is a standard LINUX either, but the point of LINUX was to have something universal....as was "unix".

Oh, for the days long past. Proprietary OS's abounded separating us into various camps. What happened to Singer, ****, and a list of others I can't remember any more.

Colin J.

On Wed, Jan 20, 2016 at 5:51 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE Is it possible to create not DB-specific LiveReports? Posted byWebster, ChrisOn 01/20/2016 05:51 PM

Hi Alex,

LiveReports includes db-independent access to date/times for today/yesterday/tomorrow, this/next/last week, and this/next/last month. I'd suggest using those where possible.

It's not clear exactly what you're wanting to do but in general I'd try resisting the siren song of dbms vendor extensions and adopt standards where practical; in this case that means ANSI SQL. The term "CURRENT_TIMESTAMP" is standard and should be supported by major vendors.

-chris

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, January 20, 2016 9:00 AM
To: eLink Recipient
Subject: Is it possible to create not DB-specific LiveReports?

Is it possible to create not DB-specific LiveReports? Posted by Gerasimov, Alexander On 01/20/2016 09:58 AM

Hi,I need to use date restrictions in our LiveReports but can't find if there is a not DB-specific way to operate with dates. For example, in Oracel I would use "TRUNC(sysdate)", but in MS SQL Server it's "CAST(getdate() as Date)", and Hana and PostgreSQL are having their own functions as well. So the question is is there a way to create a single LiveReport that will work with all supported databases?Thanks,Alex
[To post a comment, use the normal reply function]
Topic: Is it possible to create not DB-specific LiveReports?
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from WestRockCompany (www.westrock.com) or itssubsidiaries, which may be confidential, privileged or otherwise protected fromdisclosure. The information is intended to be disclosed to and used by only thenamed recipient(s). If you are not the intendedrecipient, then your review, use, disclosure, printing, copying, ordistribution of this message or its contents is prohibited. If you havereceived this message in error, please notify WestRock immediately at postmaster@westrock.com, and delete themessage from your system. Unless previously authorized in writing, thismessage does not constitute an offer, acceptance, or agreement of any kind.Sender is not liable for damage, errors or omissions related to or caused bytransmission of this message. © WestRock Company.