Setrange with an option field

sharon95 · 2017-03-08

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 · 2017-03-08

use
Table.setfilter

sharon95 · 2017-03-08

mohana_cse06 wrote: »

use
Table.setfilter

I get the error "a variable was expected"

RockWithNAV · 2017-03-08

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

sharon95 · 2017-03-08

RockWithNAV wrote: »

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

nothing works

mohana_cse06 · 2017-03-08

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

sharon95 · 2017-03-08

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 · 2017-03-08

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 · 2017-03-09

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 · 2017-03-09

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 · 2017-03-09

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

Setrange with an option field

Answers

Categories