Small bug/restriction in show URL

[jcallahan]

Looking back, I guess I understood Johnny's solution was to update the stored value in the database table using the REPLACE() function rather than what he actually suggested.

So yeah, my "even better" is what he suggested..

[hancockm]

"Even better solution- used REPLACE() function over the source column on SQL statement in data source definition.

That way the column value in the database agrees with to the actual IFS object name."

jcallahan,

The way you wrote that reply appears you are using the same solution he offered.

Could you give an example showing how your type of REPLACE() function is better than his REPLACE() function.


Thanks,

[jcallahan]

Even better solution- used REPLACE() function over the source column on SQL statement in data source definition.

That way the column value in the database agrees with to the actual IFS object name.

[jcallahan]

Johnny:

Thanks. Suspected hash was a reserved value.

replacing # with the encoded value %23 resolved my issue.

[Johnny Major]

You could update your Data Source to replace the '#' with the encoded value of '%23' if you cant remove it from your file name.

Example SQL:

REPLACE(IFSFileNameFIeld, '#', '%23')

[Johnny Major]

Unfortunately, # is a reserved symbol and considered a URL.hash so we suggest removing the '#' from your file names.

[jcallahan]

When attempting to serve a pdf where the name includes the character #,
the iFrame flashes briefly with the pdf and then displays an error message "requested URL portion-of-the-filename-up-to-the-# was not found on the server"



Valence Framework 5.2.20191218.0