News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... RunPageView Syntax for...

Small and medium business | Business Central, N...

Answered

RunPageView Syntax for either of 2 string options AL BC NAV

(0) Share

Report

Report

Posted on by Community Member

Hello,

I am translating my company's database from CAL code to AL code and trying to filter to either for these 2 strings, however I am getting an error on the OR in ('897 SHIPPI'|'') section. The error is "Syntax error, ')' expected AL AL0104"

RunPageView = SORTING("Document Type", "Type", "No.", "Variant Code", "Drop Shipment", "Location Code", "Shipment Date")

WHERE("Customer Blocked" = CONST(false),

"Work Center" = CONST('897 SHIPPI'|''));

Thanks for your help!

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Alok.kulshreshtha 934 on at

Like (0)

Report

RE: RunPageView Syntax for either of 2 string options AL BC NAV

hi,

Change CONST to FILTER than it should work.

Regards,

Alok

Please Verify my answer if you find my post helpful.

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans