How To Use Blocked Field??

abuzar_shaikh · July 14, 2014, 6:45am

dear user,

i am using navision 2013 i have added the blocked field in the table as a boolean,now i want the blocked values not to be shown on order page but the values should be shown on the table??

amol_salvi · July 14, 2014, 7:55am

set filter on page for blocked is no

manisharma31 · July 14, 2014, 9:52am

Set Visible value of the Blocked field to No. in the property.

Then the field will not be visible on the page.

abuzar_shaikh · July 14, 2014, 10:08am

abuzar_shaikh · July 14, 2014, 10:11am

see in this image blocked is ticked but it is still showing the data on the page,i don’t want the page where boolean blocked is ticked.

manisharma31 · July 14, 2014, 10:15am

Did you tried Amol’s solution ?

You need to write code to filter the records or set the filter property on the page.

abuzar_shaikh · July 14, 2014, 10:20am

yes i tried,Actually i wrote this code on On validate Of blocked

IF Blocked THEN

SETFILTER(Blocked,’<>%1’,Blocked);

abuzar_shaikh · July 14, 2014, 12:00pm

Thank u Amol Sir & Manish Sir the issue has been resolved [:)]…on open page i have put this code

SETFILTER(Blocked,’%1’,FALSE)

and it worked

manisharma31 · August 8, 2014, 10:11am

This you would have also achieved by setting the SourceTableView property of the page.