Daniel, I've never tried using stored procedures so can't really help here, but if it works at all, then d2rq:sqlExpression is probably the thing to use.
Did you try running the command line tools with --verbose or --debug? This should show the SQL queries that D2RQ is executing. Maybe this helps with figuring out why things are not working. Best, Richard On 3 Oct 2013, at 10:37, daniel.mich...@estudiante.uam.es wrote: > Hi all, > > I've been trying to map the results of a stored procedure instead > of tables. I've tried using the "SQLExpression" tag, but I wasn't > able to get anything. Is it supposed to work? In this case I should > be doing something wrong, of is there anything prepared for that? > > For more details, the stored procedure I'm trying to map is the > next one (as I query for it in the database): > > get_traceroutes(ARRAY['agent_id', 'destination_id', 'first', > 'last', 'hops', 'hop_count', 'tool_id'], 'agent_id = 11824 AND > destination_id = 1416 AND hop_count > 20','2012-09-09 > 14:30:09','2012-09-13 14:30:09') AS foo(agent_id integer, > destination_id integer, first timestamp without time zone, last > timestamp without time zone, hops ip_hop_t[], hop_count integer, > tool_id integer)) > > Thank you in advance. > > Best regards, Daniel > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk > _______________________________________________ > d2rq-map-devel mailing list > d2rq-map-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk _______________________________________________ d2rq-map-devel mailing list d2rq-map-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
