how to access scalar value returned from a sql query
Hi,
I have used sql connector to write a query and I need scalar values to be returned so that I can use them in a switch case to put my logic.
As there is one method get table to access the data which is returned in table format from a query but if we want to access the scalar value , do we need to mention in sql properties return type as scalar and just execute the query and I will be able to use output parameter? or is there any other method to access that?
I cannot test database connection now so not able to see that.
Thanks,
Reeti
Pegasystems Inc.
IN
Hi,
Please check below link. It may help you.
https://docs-previous.pega.com/database-management/pega-platform-database-overview
EPAM Systems, Inc.
ES
Hi Reeti,
Thanks for posting on PSC.
In your SQL connect rule,
{SQLPage:SQLBrowse} select <distinct> <YourScalarProp> from {Class:<YourMappedClass>} where <PropertyToBeComparedInDBTable> like {.<PropertyContainingKey>}
It depends on your query, it will work if it only one result is returned and could be used in your switch as per my understanding, though open for rectification.
Hope it answers your query, kindly notify if it does by marking this post as answered/helpful for tracking purpose.
Regards,
Asif
EPAM Systems, Inc.
ES
But I am really not much clear about how you want to use the result in the switch. Please elaborate on that.