Using a Store Procdure returns a count of rows rather than dataset

Ignition
,
1

Good morning Team,

I am using a stored procedure in MySQL to call a data set.

CALL CW_OEE_Ignition( :startDate ,  :endDate , :scanner)

When I enter data into the query I get the expected results.

When I use a binding it only returns the count of rows.

Can any help me out?

Thanks!

image
image883×885 139 KB

image
image1729×842 121 KB

2

Can you show a picture of the OEE/SWOEEScans Named Query? The reason why is the query type may be set to Scalar instead of Select.

1 Like
3

That was it, thanks!!!

I was trying some differnt things yesterday and forgot to change it back.