Can I have NULL field as result of Database Query?

OL Connect Professional Workflow
5

I tried your query, with the table I had and it works in Workflow using the Database plugin. I am using Connect 2024.2.1.

See below:

SELECT * FROM 
(
SELECT 
'8_024' [REF#],
' INVENTORY_PART_TAB' [Table],
(SELECT COUNT(1) FROM ASSET_ITEM) [table total count],
NULL AS [Extra Field]
FROM ASSET_ITEM
) as blou

Can you share your query as written in the Database plugin?
Also, what is the returned emulation you’ve setup in the plugin? (To be found on the 1st tab of the plugin)

1 Like