How to enable or disable joined dataSources on the query

(0) Share

Report

Posted on by ALAhmed

910

Hi there ,

I need a method to enable or disable added datasources to the query, so, the name of the query is CustAccountStatement_FR.

i tried add init() method on the query as bellow :

public void init()
{
Query queryCust = new Query(queryStr(CustAccountStatement_FR));
if(!LedgerParameters::find().MyField)
{
// DimensionAttributeValueSetItemViewDS_ds.enabled(False);

//This.DimensionAttributeValueSetItemViewDS_ds.enabled(False);
queryCust.dataSourceTable(tableNum(TableName)).enabled(False);
}
super();
}

*This post is locked for comments

All responses (4)

Answers (1)

Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

RE: How to enable or disable joined dataSources on the query

Hi Alex

The right syntax is :

This.query().dataSourceTable(tableNum(TableName)).enabled(False);

So, don't create a new query, but use the query itself.
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

RE: How to enable or disable joined dataSources on the query

you can find many examples inside standard AX as well as on search engine. definitely that's feasible

olondono.blogspot.com/.../how-to-enable-or-disable-joined.html
ALAhmed 910 on at

Like (0)

Report

RE: How to enable or disable joined dataSources on the query

Yes ,It has True by default , but we have specific parameter on the ledgerParameter table and if is not checked disable the new DS added on the query and otherwise.
Denis Macchinetti 16,444 on at

Like (0)

Report

RE: How to enable or disable joined dataSources on the query

Hi Alex

Why you don't set the property direcly on the Datasource?