Report data source script access to element of another data source

Ignition
, ,
1

My report has a query data source of the form,

SELECT TOP 1 VALUE 
FROM my_table 
WHERE orderNum = ?

On the report Design tab it shows up in the Data Sources:
image

I want to script a derived value. How do I access InnerLabel.VALUE from my script? I've tried variations of

    innerLabel = data['InnerLabel'].getCoreResults().getValueAt(0, 'VALUE')
    data['InnerLabelGTZero'] = innerLabel

but InnerLabelGTZero doesn't appear in the Data Sources list. I suspect that I'm not accessing VALUE correctly. (type(data['InnerLabel']) seems to be a 'class'.)

Any ideas? Thanks!

2

Huh. Did you configure InnerLabel as a scalar query?

3

Hi, Phil.

No, I'm using a Report Data SQL query and that's not an option - is it?

image
image168×168 19.8 KB

4

Hmm. Conflated with UI bindings. Sorry.

I think what I'm seeing is no row returned at all.

5

I just threw this together and it worked right off the bat

data['tbegin'] = data['query2'].getCoreResults().getValueAt(0,'TimeBegin')

Where query2 is a simple

select top 1 ['TimeBegin'],['TimeEnd'] from table

I am with Phil in I think your select isn't returning a row?

image

6

I suspect you're both right. I'm finding debugging in Reports a bit tedious!

7

A common pitfall is to override the builtin data variable inside a report script. Similar to using system for a variable name in a script.

Probably not your issue, but good to be aware of.