Has anybody stumbled into something like this? I have found that the most frustrating feature of the database lookup functoid is that it only supports using one column to do the lookup.
Right now I’m using the DBFunktoid’s Stored Procedure runner to get data out of the database when I need to use where criteria on mutliple columns to get the appropriate record back, but I’m getting tired of writing small single table query SP’s in order to work with it. What I would like would be a Database Lookup Functoid that allows me to specify multiple ID columns and map into it multiple values from my source message, this would let me do quick lookups for the times when I don’t need a SP to get the information out.
Has anybody seen one? Google searching hasn’t helped me.