Jdbc_static dealing with parameters from not existing fields

[Badger]

@Francesco_Esposito

I know that account and chaincode could not be in the event but I supposed that the query would treat missing fields as null.

If the parameter fields do not exist then it logs a warning and does not do the lookup. (See here and here.)

If this is the only lookup then you could wrap the jdbc_static filter in a test to see of the fields exist:

if [account] and [chaincode] { jdbc_static {...} }

If you want to suppress all warnings from the filter you could configure log4j to do that.

You can use mutate+convert to modify the fields to be integers.