You’re offline. This is a read only version of the page.
69
I have a sql statement and my client runs this sql monthly basis and he decided that he wants this in nav. I created a temp page and a report for them to enter a date range(request page) then I want to display but I can't display the way I want.
for example here my sql statement
Share
Reportdbo.[Companyname$Purch_ Inv_ Line].No_ LIKE '122350%' OR
dbo.[Companyname$Purch_ Inv_ Line].No_ LIKE '122370%' OR
dbo.[Companyname$Purch_ Inv_ Line].No_ LIKE '7%')My solution is
IF PurchInvLine.FINDSET THEN
REPEAT
IF (Type = Type::"G/L Account") AND
((COPYSTR("No.",1,6) IN ['122350', '122370']) OR // Problem is here I know. If I don't have anything here I can display everything
(COPYSTR("No.",1,1) = '7'))
BEGIN
// Populate Temp Table //
Rec := PurchInvLine;
INSERT;
END;
UNTIL PurchInvLine.NEXT = 0;
UNTIL PurchInvHeader.NEXT = 0;I can do the rest but I can't filter properly. What am I missing? I am a beginner btw
*This post is locked for comments
I have the same question (0)
Hi,
for what exactly do you want to apply a filter?
Alternativly, you could do something like this also:
All responses (
Answers (
PurchInvLine.SETRANE(Type, PurchInvLine.Type::"G/L Account");
PurchInvLine.SETFILTER("No.", '122350*|122370*|7*');
IF PurchInvLine.FINDSET THEN
REPEAT
// processing of PurchInvLine-records here
Rec := PurchInvLine;
INSERT;
UNTIL PurchInvLine.NEXT = 0;
