70
Is it possible with any methods in AL to fetch all of the records from a table using the table number? I'd like to be able to do this in an API call that way if I'm trying to access/set a property with a lookup I can make the query to fetch all records related to the lookup number.
Hii,
see below, if you want to get all records from the given table id
var
RecRef: RecordRef;
MyFieldRef: FieldRef;
RecID: RecordId;
begin
RecRef.Open(18);
if RecRef.Find('-') then repeat
//your code here
until RecRef.Next()=0;
end;
Hi Mohamed,
Thank you for responding. This does work for returning a specific record with field #1 value = '30000', but is it possible to return ALL records on the table?
hi you can use :
var
RecRef: RecordRef;
MyFieldRef: FieldRef;
RecID: RecordId;
begin
RecRef.Open(TableNumber);
MyFieldRef := RecRef.Field(1);
MyFieldRef.Value := '30000';
if RecRef.Find('=') then begin
RecID := RecRef.RecordId;
RecRef.Get(RecID);
end;
end;
Hi Akshay,
Thanks for the response.
Maybe I'm not implementing the method correctly, but that doesn't seem to be fetching a record. Whenever I try making my procedure return any type besides "Text", the API call returns "Resource not found for the segment {Codeunit_Method}".
I tried returning a text of RecRef.Field(num).Name + RecRef.Field(num).Value but most of the time that just returns a field name with empty value.
Hi,
Please check below reference link
docs.microsoft.com/.../recordref-get-method
Thanks
Verify, If this answer helpful to you
#1
YUN ZHU
365
Super User 2025 Season 1
#2
Mansi Soni
242
#3
Gerardo RenterÃa Ga...
226
Most Valuable Professional
Share
Report
All responses (
Answers (
