30 Kasım 2011 Çarşamba

AXAPTA Query: empty records, not empty records, use enum at query value

We have to put parameters when we want to do a complex addrange  at query. But it's not necessary with some situations:

Not empty records:
    qbds.addRange(fieldnum(custtable,name)).value(sysquery::valueNotEmptyString()) ;
Empty records:
    qbds.addRange(fieldnum(custtable,name)).value(sysquery::valueEmptyString()) ;
Records are not equal 10000:
    qbds.addRange(fieldnum(custtable,accountnum)).value(sysquery::valueNot("10000") ) ;
Ranges:
    qbds.addRange(fieldnum(custtable,accountnum)).value(queryrange("1","10000") ) ;
Enum:
            qbds.addRange(fieldnum(B_RMARequestTable, RefType)).value(queryvalue(B_RMAReqRefType::RepairJournal));

Hiç yorum yok:

Yorum Gönder