Hi community,
inside Innovator the "SQL" ItemTypes contains some Procedures, Functions and other things used for internal purposes:
It´s also possible to add own custom items. Common for example is the use of procedures that can be called e.g. this way:
Item callframe = this.newItem("SQL","SQL PROCESS");
callframe.setProperty("name","update_has_files_flag");
callframe.setProperty("PROCESS","CALL");
callframe.setProperty("ARG1", source_it.getProperty("name"));
callframe.setProperty("ARG2", source_id);
callframe = callframe.apply();
In my case I want to store a pretty huge SQL query as function within the SQL ItemType. Unfortunately I don´t know how to call these kind of functions from my Method. Does any one has an idea how we can use Functions?
Many thanks for your help!
Angela