How can we hide some field filters from table filter?

jithin01 · July 30, 2012, 6:02am

I am filtering one field value on Open Form(). But I wanted to hide those filters from table filter to hide from the view of users. Please help me to complete this requirement.

mohana_cse06 · July 30, 2012, 6:47am

Can you be more clear?

jithin01 · July 30, 2012, 7:31am

Hi Mohana,

While opening GL entries form, some entries which is posted by using a particular Journal Batch Name(say ‘AUTOJV’) should be filtered out. I have done this by using SETFILTER(“Journal Batch Name”,’<>%1’,‘AUTOJV’); in On Open Form() trigger and it is working fine. But those filter is appearing in table filter. It should be hide from the view of some users and it should be appear for the key users to remove that filter(AUTOJV).

Thanks,

Jithin.

jithin01 · July 30, 2012, 7:38am

Hi Mohana,

While open GL entries form, some posted entries which is posted by using a particular Journal Batch Name (say AUTOJV). This is done by using SETFILTER(“Journal Batch Name”,’<>%1’,‘AUTOJV’); in On Open Form() and it is working fine. The filter is appearing in table filter while opening the form. It should be hide from the view of some users and it should be appear for some key users to remove the filer(AUTOJV).

Thanks,

Jithin.

mohana_cse06 · July 30, 2012, 7:40am

Disable System permission 3220 - View, Table Filter for those users…

jithin01 · July 30, 2012, 8:54am

Sorry sir. I din’t understand. Where I have to set this permission.

mohana_cse06 · July 30, 2012, 8:59am

In Roles assigned to him on Windows/Database Authenticatin

Tools–>Security–>Winwos/database Authentication–>Roles

anilpardesi · July 30, 2012, 9:26am

Can you try :

FILTERGROUP(2);

filters…

FILTERGROUP(0);

amol_salvi · July 30, 2012, 9:41am

I would suggest better create sepeatre batches for every user.

Add UserId field in Gen.Journal Batch Table
Change code in CU 230 Function Name LookupName

GenJnlBatch.SETFILTER(GenJnlBatch.“User ID”,’=%1’,USERID);

For Super User If you want to show all batches then you can do following

Add Show All batches in User Setup Table
Change code in CU 230 Function Name LookupName

recUsersetup.SETFILTER(recUsersetup.“User ID”,’=%1’,USERID);

IF recUsersetup.FIND(’-’) THEN

IF NOT recUsersetup.“Show All Batch” THEN

GenJnlBatch.SETFILTER(GenJnlBatch.“User ID”,’=%1’,USERID);

Hope this will help you.

jithin01 · July 30, 2012, 9:52am

Hi Anil,

This is working fine. But I couldn’t understand what is happening behind. What is the normal use of FILTERGROUP?.

Now that filter is not appearing for all the users. How can I give user wise filter?

Regards,

Jithin.

jithin01 · July 30, 2012, 9:55am

Hi Mohana,

Still I couldn’t findout those roles. Kindly give some more explanations…

mohana_cse06 · July 30, 2012, 10:02am

You should contact your senior