Add display method as field in a ListPage form Grid

(0) Share

Report

Posted on by Rati Sharabidze

612

Hello,

I need to add a display method as field in a grid of VendTableListPage form. So far,I achieved it but the problem is that it is not connected with other greed items,even when I change the sorting,it keeps on the same place. How can I make this display method,which is a table method, be a field of a datasource in a AOT query?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (28)

Answers (1)

Rati Sharabidze 612 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

You are welcome. You got the point but it depends on your client. I could not use display methods, so I did what I've told u.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Since the grid ‘personalize’ function allows you to add a column from a joined table, I would have expected there was a way to make it work without having to resort to modifying the table! But thanks for responding.

Was this reply helpful? Yes No
Rati Sharabidze 612 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Hi amysvt,

I added a field to the table which is recalculated every time the form opens.

Best regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Hi Rati:

I'm having a similar issue to what you described. I'm on the Vendor Transaction grid (VendTrans), and added a PO column (PurchId joined from VendInvoiceJour). The correct purchase order number for the highlighted row shows on the first row only. Did you ever figure out how to get your value on the row of the matching item?

Thanks

Was this reply helpful? Yes No
Dauvis 170 on at

Like (0)

Report
RE: Add display method as field in a ListPage form Grid

I find that I have better luck with display methods written like this.

display BankIBAN ActiveIbanNumber(VendTable _vendor) { VendBankAccount vendBankAccount; select BankIBAN from vendBankAccount where vendBankAccount.ExpiryDate >= DateTimeUtil::utcNow() && vendBankAccount.VendAccount == _vendor.AccountNum && vendBankAccount.AccountID == _vendor.BankAccount; return vendBankAccount.BankIBAN; }

Was this reply helpful? Yes No
Verified answer

Rati Sharabidze 612 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

I did it,I simply added the field directly but I used outer join

Was this reply helpful? Yes No
Rati Sharabidze 612 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Yes

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Are you sure that you have bank account that have expiry date greater then today for vendor you are checking and also vendor has this account selected in bank account field ?

Was this reply helpful? Yes No
Rati Sharabidze 612 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Yes,bankaccount is empty in debug

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Add display method as field in a ListPage form Grid

Are you sure that you have correct data and you compiled and restored your form ?

Is it empty in debug ?

Was this reply helpful? Yes No