What does SETRANGE fucntion does in C/AL code?

(0) Share

Report

Posted on by Sulav Thapaliya

What does SETRANGE function does in the object?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

Mohana Yadav 60,969 Super User 2025 Season 2 on at

Like (0)

Report

RE: What does SETRANGE fucntion does in C/AL code?

can you be more clear please?

Was this reply helpful? Yes No
Sulav Thapaliya 12 on at

Like (0)

Report

RE: What does SETRANGE fucntion does in C/AL code?

what is the use of setrange function?

At what condition do u use this function?

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

RE: What does SETRANGE fucntion does in C/AL code?

the setrange function is a record function used in c/al to filter records.

e.g. lets say you declare variable CustRec with datatype record and subtype Customer.

CustRec.SETRANGE("No.", '100'); filters all records of table customer to that one record, which has in field No. value 100. after that command you'll need a find function to activate that filter like CustRec.FindFirst.

for further details follow

msdn.microsoft.com/.../dd355053(v=nav.70).aspx

msdn.microsoft.com/.../dd338835(v=nav.70).aspx

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 60,969 Super User 2025 Season 2 on at

Like (0)

Report

RE: What does SETRANGE fucntion does in C/AL code?

Please read this Microsoft help

msdn.microsoft.com/.../dd355053.aspx

Please contact in your office for the training.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: What does SETRANGE fucntion does in C/AL code?

Hi,

In simple terms, it's used for filtering the data.

SETRANGE("Posting Date",01012015D,31012015D) will filter all the records in this date range.

Was this reply helpful? Yes No