Dear
i have created the form and in this form i waht to filter the data based on selecting the enum, i have written code in the execute query but its not work and not fetch date in to the form. i have also written enum change mathod and there write the code to execute query
Please suggest me what to do?
public void executeQuery()
{
pendrecv pend,none,recv;
;
pend = pendrecv::Pending;
none = pendrecv::Empty;
recv = pendrecv::Received;
qb = this.query().dataSourceTable(tablenum(VendInvoiceJour)).findRange(fieldnum(VendInvoiceJour,purchid));
if (!qb)
if(manualstatus.valueStr() == enum2str(pend))
{
qb = this.query().dataSourceTable(tablenum(VendInvoiceJour)).addRange(fieldnum(VendInvoiceJour, purchid));
qb.value(sysquery::valueNotEmptyString());
qb = this.query().dataSourceTable(tablenum(VendInvoiceJour)).addRange(fieldnum(VendInvoiceJour, accountinvid));
qb.value(sysquery::valueEmptyString());
}
else if(manualstatus.valueStr()==enum2str(none))
{
qb = this.query().dataSourceTable(tablenum(VendInvoiceJour)).addRange(fieldnum(VendInvoiceJour,ledgervoucher));
qb.value(sysquery::valueEmptyString());
}
else if(manualstatus.valueStr()==enum2str(recv))
{
qb = this.query().dataSourceTable(tablenum(VendInvoiceJour)).addRange(fieldnum(VendInvoiceJour, purchid));
qb.value(sysquery::valueNotEmptyString());
qb = this.query().dataSourceTable(tablenum(VendInvoiceJour)).addRange(fieldnum(VendInvoiceJour, accountinvid));
qb.value(sysquery::valueNotEmptyString());
}
super();
}
public boolean modified()
{
boolean ret;
VendInvoiceJour_ds.executeQuery();
ret = super();
return ret;
}