Reference Query - External from a regular BAQ?

[jdtrent (Joe D Trent)]

Hey,

It looks like I can’t reference an external BAQ from a regular BAQ, or the reverse.

I have an application now in Classic that runs an internal BAQ and an external BAQ and then joins them in C# code. I’m recreating the application in Kinetic and would like to join the two queries in one BAQ.

Otherwise, I guess I’ll have to take the C# code and convert it into a function. And then figure out how to return the dataset to the application.

Any tips?

Thanks,

Joe

[kve (Kevin Veldman)]

It’s fairly easy to execute a BAQ in a function and getting the results as a DataSet. Im pretty sure External BAQ is pretty much the same, but it does use a different BO/Service.

@kve

CallService<DynamicQuerySvcContract>( svc => 
{
    var dsQuery = svc.GetByID( queryName );  // BAQ Name

    if ( dsQuery == null ) 
        return;

    var p = svc.GetQueryExecutionParameters( dsQuery );
    Results = svc.Execute( dsQuery, p );
});

Joining DataSets is pretty straightforward, especially if they have identical columns.

There are a bunch of posts on here on getting and using DataSets as DataViews in App Studio, so this shouldn’t be too tough.

[klincecum (Kevin Lincecum)]

@kve

use a different BO/Service

I don’t think so?

[jdtrent (Joe D Trent)]

Thanks, folks.

I already have the C# code from the classic customization that will have to be massaged.

I was mainly hoping I could write a single BAQ that would combine the internal and external BAQs instead of doing the join in C# and all, but it looks like that won’t work.

I haven’t tried to get a datatable back from a function but I do have a path to try.

The datatable resulting from the join, will (I hope) pop back to the application. My plan is to use a kinetic-rest widget to put the return object table into a dataview and bind that to the grid.

We’ll see how that works out.

Joe