Count records altered in an update command

@RECORD which identifies how many records are affect by the previous action.

What I want to do is allow a user to run a livereport to re-enable a user.
So I have this SQL in a live report

update kuaf set UserPrivileges = 2063 where Name = %1 and UserPrivileges=2062

Where %1 is a tex box prompt for a username.

However when I run the code although it does update the user, it reports "No records found."
THis I believe is becasue it's not actually returning (Select) any records but I want it to report
1 record but I cannot figure out how to do this.

Hope someone can help

Find more posts tagged with

Comments

eLink User

Why would you do this without a supported API or web reports?

Sent from my iPhone

On Jun 1, 2015, at 9:41 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

eLink : Count records altered in an update command
Count records altered in an update command Posted bydslupek@rjmcleod.co.uk (Slupek, Darren)On 06/01/2015 10:40 AM

@RECORD which identifies how many records are affect by the previous action.What I want to do is allow a user to run a livereport to re-enable a user.
So I have this SQL in a live reportupdate kuaf set UserPrivileges = 2063 where Name = %1 and UserPrivileges=2062Where %1 is a prompt for a text boxHowever when I run the code although it does update the user, it but reports No records found.
I want it to report 1 record but I cannot figure out how to do this.

Hope someone can help
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

Darren_Slupek

We dont have webreports.

The live report performs the action I require - eg re-enabling a user.
However I want it to report what it has done rather than just say "No records found".

As a noob to this form and Livelink I may not be doing everything the best way

eLink User

I would not advise a Noob to directly manipulate the livelink database then you are supposed to use a proper API or tool

Sent from my iPhone

On Jun 1, 2015, at 10:42 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

eLink : Re Count records altered in an update command
Re Count records altered in an update command Posted bydslupek@rjmcleod.co.uk (Slupek, Darren)On 06/01/2015 11:35 AM

We dont have webreports.The live report performs the action I require - eg re-enabling a user.
However I want it to report what it has done rather than just say "No records found".As a noob to this form and Livelink I may not be doing everything the best way

[To post a comment, use the normal reply function]
Topic: Count records altered in an update command
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

Darren_Slupek

Well, that's not helping me very much
If Opentext thought it an absolute no-no to manipulate the database this way
then they would not have added the "Allow database modification" tickbox.
However, they did include the option and so it seems not unreasonable to go down this route?

Also

The SQL is relatively harmless - it can only enable disabled accounts.
The livereport itself is set to read only for the single user that is running it.
The user running the report has no capability of creating reports so they cannot copy it.
I have emailed the user a link that runs the query and so they will not see the code anyway.

Perhaps someone else could offer advice on how to alter my Livereport to make it work
rather than proposing alternatives methods. Even if it's not feasible, it would be nice to know.

Kyle_Swidrovich

Comments in this thread about not directly modifying Content Server database values and schema are absolutely correct.

That setting is not there for customers to manipulate core schema, but rather to allow customers to work with their own custom schema, if they have extended it.

Although you may believe a change to the database is small and relatively harmless, you are likely not aware of the numerous code paths that small change normally would take if it was done through product as opposed to being changed directly in the DB. Those code paths are necessary to update other areas of the database, search index, etc. Without taking them, your system will very likely have data integrity issues and could be put into an unsupportable state.

I’m not trying to induce fear here, but rather communicate reality.

I cannot stress enough the importance of using proper APIs to work with Content Server.

There are a variety of APIs available to manipulate user records (WebReports, Content Web Services, etc.)

Please use one of those to try to achieve your goal.

Regards,

Kyle