Dynamic reference for Link to URL fields

Abhijeet Teli shared this idea 1 month ago
Idea Logged

Hi Team,

Currently we are leveraging Link to URL field format for couple of reports and referring current column value in a link by Specifying ## in url,

Eg;

http://<Server>:<port>/ticketId=##

but we have a requirement to make it dynamic to achieve some use cases,

Use Case -

Our source system generates two ID's when any request gets created in Application,

1. DISPLAY ID

2. GUID.

Display Id is something visible on UI and should be displayed in Report but Source will not recognize it in URL and GUID is something system generated long alphanumerical value which doesn’t look good in Report its only acceptable in Report.

We are expecting we will put both fields in a Report and we will put hyperlinks on a Display ID but we provide ## reference of GUID column, So when user clicks on Display ID URL internally URL will pick up Value of GUID column in same Row,

It will make behaviour dynamic and provide flexibility to choose which column to hyperlink and what value to replace in URL.

Hope it explains the use case,

Let me know your thoughts.

Thanks,

Abhijeet Teli

Comments (7)

photo
1

Hi,

Can someone please look into it and check feasibility of this request ?

Thanks,

Abhijeet

photo
1

Hi Abhijeet,

I think I understand what you're after, though I'm unsure what sort of text you want to be dynamic.

I would like to get a good example of what sort of text you want to be dynamic, as most people just use a 'click here' etc...

So in your current use case, you would only be able to click on the GUID column, but the text would be something hard-coded across all-rows. However the Display ID next to it would still be dynamic.

E.g.

7d6c578746de1ad88c8843c773649065

7e9194b833828f1801b807a8db90f574

Thanks,

David

photo
1

Hi David, Hard coded value at link is already tried but its not something solving the issue, Here is the example what we are looking for. Below Report contains Article ID and InstanceID Where Article ID is display ID and InstanceID is GUID, dce0324551a810c3b81d02817a438e56 Below is the URL which we used to put on instanceID field and put a hardcoded text as Click here but this is not good user experience http://ServerName:port/ux/smart-it/TicketID=## -- http://ServerName:port/ux/smart-it/TicketID=AGGAA5V0GETIFAOMBBI7OLFG977OXM As you can see we cannot pass Display ID in URL as it wont be recognizable at application end. So we need a mechanism which allow us to choose which columns value go in URL, Current ## mechanism will only allow us to put current column value but sometime we need to pass other column value . So in above example i will Put URL on Article ID field and provide ## reference of InstanceID then we can hide instanceID field, Eg- Link to URL in Article ID but referenced to InstanceID http://ServerName:port/ux/smart-it/TicketID=##InstanceID It will also help on a use cases where we need to pass more than one value in URL. Thanks, Abhijeet

photo
1

Hi David,

Any update on this ?

Please let us know if you need any inputs from us.

Thanks,

Abhijeet

photo
1

Hi Abhijeet, Thanks for the extra info. Ok I see what you're after, but I still feel you can get this result from simply returning the data in a single column. The use of a calculated field will do this. Eg. Case when InstanceId is NOT NULL then 'InstanceId' Case when ArticleTitle='test 0004' then InstancdId+ArticleID. Else NULL So in this calc field, your telling YF what data to return in the column. Then when you format that column, you can still say "http://ServerName:port/ux/smart-it/TicketID=##"; and display as 'click here' I can raise a request for exactly what you're after, but since there are no current plans there would no ETA, and guarantee it will be implemented. What I'm suggesting is to look at the data you want to return, which will be appended to the URL, and how you can get this data returned via some sort of calculation. Is there a case where this simply wouldn't be possible? Thanks, David

photo
1

Hi David,

Thanks for the info.

Honestly We don't have any use case blocked due to lack of this enhancement its required to improve End User Experience. We are using exact same solution which you have suggested but its not user friendly, additionally it will not work if we apply a Suppress Duplicates option on 'Click Here' field because it will display only once assuming the all column contains 'Click Here' text,

So to improve usability we need this enhancement and it was asked by many of our Customers and internal teams,

Please let me know your thoughts.

Thanks,

Abhijeet

photo
1

Hi Abhijeet,

Fair point on the duplicate rows.

I've raised an enhancement request on your behalf, though please keep in mind this is still something that is not planned, so no ETA can be provided.

If this does get picked up in a future discussion when planning our releases we will update this idea.

Thanks for the detailed info you have provided.

Regards,

David