Dynamics Community Forum Thread Details

Hyperlink function add * on filter

Hello,

I want to use System.HyperLink function to show a specific record in new tab.

My code looks like this :

        DataTypeManagement.GetRecordRef(Rec, RecRefLink);
        RecRefLink.SetRecFilter();
        UpdateURL := GetUrl(ClientType::Web, LeadingCompany, OBJECTTYPE::Page, Page::"RM Vendor Card Update", RecRefLink, true);
        Hyperlink(UpdateURL);

I am on the vendor card, No. '1149'.

When i debug, the updateURL variable value is :

https://localhost:443/adt/?company=PRE_PROD&page=50005&filter='No.' IS '1149' AND 'Date Filter' IS '''''..31/01/22''

We can see filter on No. = 1149

But when HyperLink is running, my browser open a new tab with url :

https://localhost:443/adt/?company=PRE_PROD&page=50005&filter='No.' IS '1149' AND 'Date Filter' IS '''''..31/01/22'

and after one second my page is refresh and url become :

https://localhost:443/adt/?company=PRE_PROD&bookmark=21;FwAAAAJ7BTEAMQAxADQAOQ==&page=50005&filter=Vendor.'No.' IS '@*1149*' AND Vendor.'Date Filter' IS '''''..31/01/22'&dc=0

I can see * are added at the start and the end of No. filter.

Problem i have another record who's started by this string '11149' and the page open this record.

How to solve this problem ?

I think use another filters like name or ... but it's not very clean.

pageextension 50101 MyExtension extends "Item List" { actions { addfirst(processing) { action(TestHyperlink) { Caption = 'Test Hyper Link'; ApplicationArea = All; PromotedCategory = Process; Promoted = true; Image = Open; trigger OnAction() var Cust: Record Customer; begin Cust.Reset(); Cust.SetRange("No.", '10000'); if Cust.FindSet() then Hyperlink(GetUrl(ClientType::Current, CompanyName, ObjectType::Page, Page::"Customer List", Cust, true)); end; } } } }

Quick Links

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