Did anyone ever create a DQL tester for DQL as used in D2?
Very often something's wrong with a query using property value placeholders ($value, $repeatingvalue, etc.) and to figure out what's wrong we usually copy the query into an editor, manually substitue the values for the properties and then execute the query to check its results. Once you've corrected the query such that it delivers the results as desired you have to convert it back to use the value placeholders.
What would be really nice is if we had a "D2 DQL" tester where you can just paste the query as it comes from D2 into a text control and the tester then identifies the properties, prompts the user for the corresponding value(s) and lists them in text controls so you can also modify them, substitutes the values as appropriate and then executes the resulting query. You should be able to modify the initial query in the text control and execute the modified query using the previously supplied or modified values and be prompted for any additional ones from the modified query.
Purpose is to be able to copy the corrected query back into D2 without further modifications.
I'm not a development guru myself and I'm sure someone out there would be up to creating such a thing which should be useful to the community.
Roland Renetseder
Business Technology Architect
Novartis Pharma AG
