Joining tables to display specific data for users

Justin · 2025-02-26T15:04:50+00:00

There was an error rendering this rich post.

Hello,

I am looking into my options when it comes to creating views that join together data from different tables, ie. ODHEAD + MPTRNS + DSPACK. Ideally the data from this view would be able to interact with M3 (potentially through MI calls)

What software solution would be my best option for this scenario? I have explored Experience Designer with custom XtendM3 extensions but that has its own drawbacks. Would Mongoose IdoCollections or Birst be something that I should look into?

Thank you!

Find more posts tagged with

Accepted answers

All comments

Alistair Johnson

Have you looked at CMS010 to create a configurable list, then CMS015 to expose that via an API? Note that in CMS010 your base table should be the one with the most detail e.g. ODHEAD:MPTRNS is a 1:many relationship, so you would (in this simple example) have the base table as MPTRNS and then join back to ODHEAD.

Justin

edited*

Justin

*reposting here. my other comment wasn't a reply

From what I read up on CMS010 it said that I would need to connect each key field in order to work properly. In the example below I tried connecting ODHEAD to MPTRNS but these key fields are not able to be connected. Is there a configuration step I am missing, or would I have to create/find new sorting options?

Elaine Stewart

Hi Justin, have you explored Vince Excel and the use of EXPORTMI to get the data you need?