Hello everyone, I have a working DIH setup with a couple of long and complicated MySQL queries in data-config.xml. To make it easier/safer for myself and other developers in my company to edit the MySQL query, I’d like to remove it from data-config.xml and store it in a separate file, and then call to that from data-config.xml.
Is there anyone who’s currently doing this right now and could share what method was used to accomplish this? At some point on this list I saw someone mention that they had done just what I’m trying to do by putting the query in a separate SQL file as a MySQL stored procedure, and then calling that procedure from the query=”” portion of data-config.xml, but I don’t quite understand how/at what point that SQL file with the stored procedure would be read by DIH. Does anyone know how this would be done, or have any other suggestions for how to move the query into a separate document? Thanks in advance, Peter
