Contolling The Filtering of records by using Show All(ctrl+shift+F7)

Business Central/NAV Developers Forum
1

Hi All,

The problem is i have filter the records by writing code on Onaftergetrecord() trigger of the form, what happens is until i am using the showall (ctrl+shift+F7) it works fine .but after using of (ctrl+shift+F7) it showing all records. i want to stop this. Help me in this.

Thanks in advance.

2

Check FILTERGROUPS function…

3

Just take this example.

Customer card and then ledger entries now if i am using showall (shift + ctrl +F7) all the ledger entries are appearing. which not to be done .is this possible .

Thanks in advance.

4

Did you try this?

5

yes, but it is not works , i have use code onaftergetrecord trigger but no change

6

How did you use?

Can you show us the code?

7

Customer Ledger entries on push()

  • OnPush()
    RecCustLedgerEntry.SETRANGE(RecCustLedgerEntry.“Customer No.”,“No.”);
    FORM.RUN(25,RecCustLedgerEntry,RecCustLedgerEntry.“Entry No.”);
    FILTERGROUP(0);
8

Please read help documents to know how to use filtergroups

http://www.mibuso.com/forum/viewtopic.php?t=16659

http://support.microsoft.com/kb/861744

9

Thanks for your patience.

10

Welcome

Please close the post If your problem solved.