I’ve not tried this, but would using an “AS” in your SQL to rename the conflicting columns work? For example,
SELECT id as MxID, createddate as MxCreatedDate FROM …
Then use MxID and MxCreatedDate in your NPE.
Try using aliases in your sql statement. The alias must match the column name in your object result.
For example: SELECT type AS 'TypeAlias' FROM table;
Edit: beaten by Robert, I can confirm this works!
Hi Robert and Ruud,
It worked exactly as you say!
Thank you both for taking the time to reply, it’s much appreciated.
Regards,
Greg
Hello Guys,
It does work for me unfortunately. I get the error below
Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.RuntimeException: The entity type 'NativeMobile.wp_posts' does not contain the primitive 'ID' as specified in the query.
at NativeMobile.Get_wp_posts (JavaAction : 'Execute query')