Dynamic reference for Link to URL fields

Abhijeet Teli shared this idea 6 years ago
Completed

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

Replies (11)

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

photo
1

HI Abhijeet,


The devs have had a look at this task and believe what you're after is already possible using a different calc field.

We actually think it gives you everything you're after and more. It also takes 'duplicate rows' into consideration.


The example below uses the Ski Team DB, but its something that can be translated to any data set.

The calc field is built using the base URL you need, then adding any additional columns, and lastly choosing the data that is displayed as the hyperlink.


69b456c4144c429f261496464b8cd168


Then use the column formatter HTML.


3823caf768173f49fe1289e17aceaca1


You should end up with something like this (note the raw format vs the html formatted one)

235afc0e9331f49b27d47234889ed707


Please let me know if this doesn't give you what you were after!


Regards,

David

photo
2

HI David,

We already tried it,

only problem with this one is, it does not understand custom parameter, our URL's contains some information which will come from custom parameters defined in Configuration, eg;

http://${SERVER_NAME}:${PORT}/ticketId=##


if there is a way to make this guy understand Custom parameter substitution then we are good.


Thanks,

Abhijeet

photo
1

Thanks Abhijeet,


The devs are looking at another option which does involve a code change.

Will update you by next week on the progress of that.


Regards,

David

photo
1

Hi Abhijeet,


Sorry for the delays.

Ok so the devs have managed to code a change that will help you out.

You can get the builds from the links below:


http://files.yellowfin.bi/downloads/interim/7.3/yellowfin-20170818-full-bmc.exe

http://files.yellowfin.bi/downloads/interim/7.3/yellowfin-20170818-full-bmc.jar

http://files.yellowfin.bi/downloads/interim/7.3/yellowfin-20170818-update-bmc.exe

http://files.yellowfin.bi/downloads/interim/7.3/yellowfin-20170818-update-bmc.jar


To use this functionality:

-Use the column formatting 'Link to URL'

-You can use ## to build the dynamic link


-The display text box will allow you to pull in data from the other column by using double curly braces, YF will consider it as the linked request.

For example if the value is "1" then application will link the column having index value 1 with the corresponding column.

You can then hide the linked column if you like. If the index value is not proper than it will just return blank.

Also attached a .gif if it in use.


Please let me know how it all goes for you.


Regards,

David

Replies have been locked on this page!