Hi,
I have a fairly simple form that a few users are going to use to help clean up a database. Basically they will be running some searches to find records that are missing data and/or need to view/print an output of their frozen tank inventory by tank/stack/pie. I couldn't find any direct Servoy function that would grab the column names that were being searched on and the parameters being fed to those columns so tried to do some regexp using 'databaseManager.getSQL(foundset)' and 'databaseManager.getSQLParameters(foundset)'.
The REGEXP is pretty long but this works well as long as I am not searching for any null values. At that point a) getSQLParameters does not return any values at all (e.g. if one is searching for '2' in the 'tank' column and '^' in the 'amount' column it simply returns '[2]'). And b) the getSQL function does put in 'amount is null' but also puts in that the id for that table 'is not null'. (It can be a related search on one additional table). Having the 'is null' of course complicates the REGEXP but I could work that out; however I'm not sure why and when this extra 'is not null' check on the related table PK is thrown in.
Is there a simpler way to get that information? As they are doing searches and working on sets of records my plan was to automate a 'header' for their printouts that would tell them what their search was that yielded the found set. And of course I don't want to give them the whole SQL as that wouldn't mean much to them. I was thinking of simply something like:
Searched fields: tank = 4, stack = 13, pie = 2, amount = null
Thanks for any pointers (Servoy 6.0.5)