How to read association value in a webreport?

In my webreport I want to read a value returned by RUNSQL subtag which returns an association. But in my report output, it's giving me the whole V{<ID>, <2000>} blob. I tried everything. If I put "ASSOC:ID" sub tag, the output is empty. Help please?

Here's my Live Report
select ID from kuaf where name = 'admin'

my web report tag, this variation outputs the full V{<>} blob
[LL_REPTAG_$LiveReport_GetKUAFID RUNSQL /]

this version outputs blank
[LL_REPTAG_$LiveReport_GetKUAFID RUNSQL ASSOC:ID /]

Note that my WR tag is placed inside the repeater section, not sure if that matters.

I want to use this value in another tag, which is why I want the numeric value only. Any pointer is appreciated.

Find more posts tagged with

WebReport

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

GregPetti

The RUNSQL sub-tag is returning a "RECARRAY" which is to say an array of records. Even if you only expect one row, you will have to index it. E.g..

[LL_REPTAG_$LiveReport_GetKUAFID RUNSQL RECARRAY:1:ID /]

[LL_REPTAG_$LiveReport_GetKUAFID RUNSQL RECARRAY:1 RECORD:ID /]

If you have more than one row, you can use the [LL_WEBREPORT_FOR tag to loop through them and an LL_WEBREPORT_IF tag to screen out the rows you don't want.

Cheers

Greg

All comments

appuq

check if the non-working place LiveReport is set to autolivereport vs the working one, compare the way the Live Reports are set up

If you say Live Report it will only return the column you specify autolivereport is the method by which it will return the columns

GregPetti

The RUNSQL sub-tag is returning a "RECARRAY" which is to say an array of records. Even if you only expect one row, you will have to index it. E.g..

[LL_REPTAG_$LiveReport_GetKUAFID RUNSQL RECARRAY:1:ID /]

[LL_REPTAG_$LiveReport_GetKUAFID RUNSQL RECARRAY:1 RECORD:ID /]

If you have more than one row, you can use the [LL_WEBREPORT_FOR tag to loop through them and an LL_WEBREPORT_IF tag to screen out the rows you don't want.

Cheers

Greg

GregPetti

I should note that there are better ways to do this besides RUNSQL (this sub-tag is often disabled on customer systems as it is disabled by default).

If all you need to do is return a column from a SQL query that returns one row you could associate the LiveReport as a datasource and the use

[LL_WEBREPORT_DATASOURCE /]

which basically does the same thing. Or (assuming only one row is returned) just put a line like this in a row section like this:

[LL_WEBREPORT_STARTROW /][LL_REPTAG=ID /][LL_WEBREPORT_ENDROW /]

This automatically loops through the rows so you get row #1 automatically and the =ID tag looks up the ID column.

Greg

appuq

@GregPetti gave you the right way, I misread your post as it was working in one environment vs another, so ignore mine 😊