Filter datasource in form

Sample code :

Override ExecuteQuery method in datasorce and put this query before Super()

this.query().dataSourceTable(tableNum("RsPcm_EmployeeReqPaymentTable")).addRange(fieldNum(RsPcm_EmployeeReqPaymentTable,Status)).value(SysQuery::value(RsPcm_VendorActivityPaymentStatus::Draft)); 

Cannot edit a record in User to person relationship (DirPersonUser). Update on a valid time state table is not allowed without specifying a ValidTimeStateUpdateMode.

This table need update in validTimeStateUpdateMode field.

while you update the record you need to define [table].validTimeStateUpdateMode also.

sample code :

DirPersonUser           personusertable;

    ;

    

    select forUpdate personusertable

    where personusertable.RecId == 5637174578;

    ttsBegin;

        personusertable.PersonParty = 5637286583;

        personusertable.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);

        personusertable.update();

    ttsCommit;

https://hellodax.com/2015/06/25/error-update-is-not-allowed-without-specifying-validtimestateupdatemode/

Semua data Purchase Requisition yang Approved tidak muncul di Release Approved Purchase Requisitions

Dikarenakan ada record yang terentri dengan field2 kosong di PurchRQFCaseTable.

Trouble shoutingnya : Delete record kosong itu.