Filtering Out A BLOB Causes an Error

stapuff

I created a workflow that passes a database table name through a text input, dynamic input to modify the sql, return 1 record and process it to get the field names, data types, etc and marries it up to a data dictionary table for system descriptions. A quick painless process.

All was good until I ran into tables that have a BLOB as a data type.

Workflow started failing. Did a little investigation and found those BLOBs were not needed to go through the process so I thought adding a simple filter would do the trick.  Everything I tried failed to filter.... and an error would appear that BLOBs can not be filtered.

The temp remedy  - I had to add a select, find the field, and deselect it.

Any thoughts would be greatly appreciated.

Puff 

danilang

Hi @stapuff 

Depending on the flavour of SQL that your running your queries against, have you considered querying the  "INFORMATION_SCHEMA" tables (T-QSL) or "all_tables" and "all_tab_columns" (Oracle) or the equivalent.  These return text information about the tables and columns so you won't have any blob issues 

Dan