How do I query different Sites in an IDO Extension Class using LoadCollection(Request/Response)Data?

A project I'm working on requires me to check values in our other Sites if the data needed is not found in the current Site. I know I can use the AppDB class to get q SQL connection to the database server & execute T-SQL that way. However, I'd like to try and stick to IDO Extension Class method calls to do this. Is there a way that I can do this, or do I have to essentially have my code log into the other sites and issue an request against that log in?

Find more posts tagged with

Syteline Development

Accepted answers

Legacy Contributor

Can't you use the existing _all tables? There should be enough information to get the info from the correct site.

depm - 646 - Scripting in relational modeling.mp4

All comments

Legacy Contributor

Try creating a SubCollection.

csi901.inforcloudsuite.com/.../lsm1454148021046.html

www.increaseitvalue.com/.../

Stephen Cena

Are Subcollections form side only? If so, they currently wouldn't work for me as I'm server site. That doesn't mean I can't move my code into the Form from the IDO and leverage the Subcollections there.

BradleyBrown

You can use nested request/responses to emulate the parent/child relationships in .Net code.

Stephen Cena

I'm not familiar with nesting the requests/responses, but it does sound like what I need. Do you know of any code samples/documentation I can look at?

burnsg

Can you make an All table and get to your site specific data that way?

Stephen Cena

Greg: That was my problem. In this instance, I'm looking at an Infor IDO which does have a _all component. I'm not use to looking at those. In this case, it solved my problem.

However, I am still interested to know how I would query other Sites via IDO Ext Class if it's possible. Never hurts to have the tools in your belt

Legacy Contributor

Can't you use the existing _all tables? There should be enough information to get the info from the correct site.

depm - 646 - Scripting in relational modeling.mp4

Legacy Contributor

You wouldn't do it directly. The _all table approach is the proper way to do it. I've done the AppDB approach for non-replicated sites, but it's a hack at best.

Stephen Cena

It being a hack was what I was expecting to hear. I keep forgetting about the _all tables when it comes to native Infor data/tables. The only other way I could see to do it (which is hack-y) would be to use the REST/Web interface in C# and login/make calls against IDO methods that way. Janky for sure, but it could work.

Learning more and more about this software every day. Thanks to everyone who comments on all my questions. I appreciate all the help and criticism as it helps improve my skills.

Legacy Contributor

In response to the latest comment - it is possible to get data from other sites from SQL. We need to do this based on my users' requirements. When I do this I run the SetSiteSp for the <other> site, then run an SP in that site, then reset SetSiteSp for my <original> site.

Copyright © 2025 Infor. All rights reserved.