Setrange with an option field

sharon95

Why this isn't working?

Table.setrange("Reason for Archiving",'<>%1|<>%2|<>%3', Table."Reason for Archiving"::'Delete Manually',Table."Reason for Archiving"::'Delete Completed Document',Table."Reason for Archiving"::'Delete Manually without Posting');

Thank you!

mohana_cse06

use
Table.setfilter

sharon95

mohana_cse06 wrote: »

use
Table.setfilter

I get the error "a variable was expected"

RockWithNAV

Check out this link
http://forum.mibuso.com/discussion/14858/setrange-for-option-type-field

sharon95

RockWithNAV wrote: »

Check out this link
http://forum.mibuso.com/discussion/14858/setrange-for-option-type-field

nothing works

mohana_cse06

you need to use "" double quotes for option values like
Table."Reason for Archiving"::"Delete Manually"

sharon95

mohana_cse06 wrote: »

you need to use "" double quotes for option values like
Table."Reason for Archiving"::"Delete Manually"

ok, thank you, but what's the statement for saying "and" at the place of "|"?

vaprog

sharon95 wrote: »

ok, thank you, but what's the statement for saying "and" at the place of "|"?

Take a look at the help for SETFILTER Function (Record).

SuD

sharon95 wrote: »

Why this isn't working?

Table.setrange("Reason for Archiving",'<>%1|<>%2|<>%3', Table."Reason for Archiving"::'Delete Manually',Table."Reason for Archiving"::'Delete Completed Document',Table."Reason for Archiving"::'Delete Manually without Posting');

Thank you!

Use SETFILTER instead of SETRANGE..
eg.Table.SETFILTER("Reason for Archiving",'<>%1|<>%2|<>%3', Table."Reason for Archiving"::'Delete Manually',Table."Reason for Archiving"::'Delete Completed Document',Table."Reason for Archiving"::'Delete Manually without Posting');

DenSter

SETRANGE accepts only two parameters: a FromValue and an optional ToValue.You can only filter to a single value (by leaving out the ToValue) or to a range. Any other situation you have to use SETFILTER.

MSDN Help:
SETRANGE: https://msdn.microsoft.com/en-us/library/dd355053.aspx
SETFILTER: https://msdn.microsoft.com/en-us/library/dd354919.aspx

In your situation, you want to set a filter on 3 different values, and therefore you must use SETFILTER. You cannot use SETRANGE in your situation.

I don't think you mean to use AND on a single field value, because there will not be any records that have all three values at the same time.

Duikmeester

Also Table.SETFILTER("Reason for Archiving",'<>%1&<>%2&<>%3'