Dynamic reference for Link to URL fields

Hi,

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

Thanks,

Abhijeet

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.

Thanks,

David

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,

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

Hi David,

Any update on this ?

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

Thanks,

Abhijeet

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

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

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

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.

Then use the column formatter HTML.

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

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

Regards,

David

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

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

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