Dynamics Community Forum Thread Details

I need to provide Or Condition filter between fields(Accepted and Received) of my data source in the form. both fields are of Enum type and I need to provide value Yes to both fields.

I have applied filter on Document_type, Renewed and Validity_Date , these three are working but Received and Accepted are not working after opening the form.

[Form]
public class PwC_Insurance_Monitoring_Form extends FormRun
{
PwCAlertMessageforValidityDate regclass;
TransDate validityFromDate;
TransDate validityToDate;
PwCAlertMessageforValidity selection;
PwC_TRI_PIS_SAFE_DOCUMENT document;

/// <summary>
///
/// </summary>
public void init()
{

super();
if(element.args().parmObject())
regclass = element.args().parmObject();
selection = regclass.parmselection();
validityFromDate = regclass.parmvalidityFromDate();
validityToDate = regclass.parmvalidityToDate();
PwC_TRI_PIS_SAFE_DOCUMENT_ds.executeQuery();

}

[DataSource]
class PwC_TRI_PIS_SAFE_DOCUMENT
{
/// <summary>
///
/// </summary>
public void executeQuery()
{
QueryBuildDataSource querybds;
QueryBuildRange QueryBuildRange;
querybds = this.query().dataSourceTable(tablenum(PwC_TRI_PIS_SAFE_DOCUMENT));
querybds.clearRanges();
querybds.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT,RENEWED)).value(enum2Str(PwC_TRI_PIS_PreExecutionAccepted::No));
querybds.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT,DOCUMENT_TYPE)).value('INSURANCE');
querybds.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT,VALIDITY_DATE)).value(SysQuery::range(validityFromDate , validityToDate));
queryBuildRange = querybds.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT, DataAreaId));
queryBuildRange.value(strFmt('((ACCEPTED == %1) || (RECEIVED == "%2"))', any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes), any2int(PwC_PIS_ReceivedType::Yes)));

// queryBuildRange = querybds.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT, DataAreaId));

//query=this.query().dataSourceTable(tableNum(PwC_TRI_PIS_SAFE_DOCUMENT));
//query.clearRanges();

//queryBuildRange.value(strFmt('((ACCEPTED == %1) || (RECEIVED == "%2"))', any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes), any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes)));

//query.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT,ACCEPTED)).value(strFmt('((ACCEPTED == %1) || (RECEIVED == "%2"))', any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes), any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes)));
//queryBuildRange.value(strFmt('((ACCEPTED == %1) || (RECEIVED == "%2"))', any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes), any2int(PwC_TRI_PIS_PreExecutionAccepted::Yes)));
//query.addRange(fieldNum(PwC_TRI_PIS_SAFE_DOCUMENT,RECEIVED)).value(enum2Str(PwC_TRI_PIS_PreExecutionAccepted::Yes)); */

super();

}

}

[Control("Button")]
class Insurancerenewletter
{
/// <summary>
///
/// </summary>
public void clicked()
{
PwCInsuranceMonitoring_Class tViewCalculation;
;
tViewCalculation = new PwCInsuranceMonitoring_Class();
super();
tViewCalculation.variables_InsuranceMonitoring_Report(validityFromDate,validityToDate,PwC_TRI_PIS_APPLICATION.APPLICATION_NO);
}

}