nFeed need to set a variable from a SQL query

peter-quach

{code}

#set( $cnt = (select count(*) from dbo.tableA) )

#if ($cnt > 0)
    select column1
    from dbo.tableA
#else
    select column1
    from dbo.tableB
#end

{code}

can I set a variable from a SQL query?

Nicolas Simon

Hello Peter,

Unfortunately this is not possible with the current version of nFeed. I would suggest to open a Change Request on the Valiantys Support platform -> https://valiatys.atlassian.net. Maybe the functionality will be implemented one day.