81
Like
Share
ReportDear Friends,
When we talk about AIF outbounds, normally what comes first to our mind is using a query, and using the wizard to generate the required objects. But at times, we may face a situation, where standard table joins might not provide the desired data in the query.
To achieve this, we may need to write a code and take use of a temporary table, and mapping that with the query. But as we all know, regular tables are not suggested in these scenarios, and we face problems with scope of the temporary tables in these scenarios.
To achieve that successfully, we need to override the "prepareForQuery" method of the AxD class, and do a "setCursor" of the existing "QueryRun" object with the temporary table (which needs to be populated before that).
This will help us in achieving the desired result.
When we talk about AIF outbounds, normally what comes first to our mind is using a query, and using the wizard to generate the required objects. But at times, we may face a situation, where standard table joins might not provide the desired data in the query.
To achieve this, we may need to write a code and take use of a temporary table, and mapping that with the query. But as we all know, regular tables are not suggested in these scenarios, and we face problems with scope of the temporary tables in these scenarios.
To achieve that successfully, we need to override the "prepareForQuery" method of the AxD class, and do a "setCursor" of the existing "QueryRun" object with the temporary table (which needs to be populated before that).
*This post is locked for comments