Clarity

This is helpful - sharing with our support team.  Thank you!

Dale !

Props to another_martink: Beer!

---

I owe you a beer!

Many thanks!

Hi!! I'm on Clarity v13.2 trying to create a link to project hierarchy tab, and I'm facing the same error message on app-ca.log

WARN 2014-08-22 11:52:19,464 [http-bio-80-exec-242] caching.SecurityObjectCache (clarity:admin:7527023__CF513833-6A2B-4BCB-858C-CB06C6CCEB28:service.billOfInvestments.project) Invalid security object key: INVRECORDINV

And from Clarity UI:

Have you been able to find a workaround? I know that it worked for some people in v13.3 and 13.4. Have any of you had the chance to try it as well?

I appreciate your findings! Thanks a lot

Flo.

The error suggests that you to not have the appropriate access to the Hierarchy tab of the subpage.

Please correct the access and try again.

NJ

Hi NJ, I do have access to the page. I can get in without errors when opening the tab from any project. The error is only threw when trying to use the link.

Thanks

Flo

Redirection URL (link posted by Martti) is probably the easiest approach to this. The same concept applies to the Timesheets, Action Items and other URL's which are not available OOTB or not exactly what you expect it should be doing. I have used this approach several times and works flawless. Make sure the redirection portlet and page has global access to all. When the user clicks on the link, there will be a small delay as the redirection will take you to the new page. But once it caches, then it is almost invisible.

best practice -

1. The URL in the NSQL should be relative "/niku/nu#action:revmgr.costplandetailList&id=5311405" instead of the complete URL. The way you would program this is "/niku/nu#action:revmgr.costplandetailList&id=" || to_char(project_id) ||"...the text from the actual URL ...&plan_id=" || to_char(cost_plan_id)" AS cp_link

2. In the portlet, do not display this field as it will be a long string. And name it "Internal Cost Plan Link URL" so that the users are not trying to figure out what it is.

This approach will work for on-demand as well as on-premise.

Hi! I'm having difficulties applying Martti's solution, and I'm not sure if I'm following the right steps because I create the link and then I understood I need to change the action for the link and need to set through a sql sentence to open the hierarchy page. In order to achieve this I first run a select against the odf_links so I can get the ID for the link. I then update the  odf_links with the ID for the action.

Select * from niku.odf_links where code ='project.link_h'

update niku.odf_links set action='project.link_h' where id=5056001;

So I end up having something like this:

I think I'm doing something wrong, because when going to Clarity and checking for the action set for my new created link, I don't see project.link_h

Thanks!

Flo

Flo, don't update studio tables, you may break Clarity and invalidate your database. It is not supported.

What he suggested was for you to include a concatenation of strings and attributes in NSQL to dynamically build your link and then use a html redirect to jump to that location.

I believe we could also do that with actions in v13+ But need to investigate further.

Thanks Alexandre for your advice. Do you know if there is any guide that I can study so I can try to add the concadenated URL?

Thanks!

Flo

I'll send you an example tomorrow ;)

Thank you!!

I'm running late - trying to find the example for you. Sorry about that...

No problem, I wait. Hope you find it

Thanks!

OK, so here it goes (easier to create a new example)... see if that works for you:

1) Create the Query.

SELECT @SELECT:DIM:USER_DEF:IMPLIED:FP:FP.ID:PLAN_ID@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:FP:FP.NAME:PLAN_NAME@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:FP:FP.CODE:PLAN_CODE@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:FP:I.NAME:INV_NAME@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:FP:I.CODE:INV_CODE@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:FP:I.ID:INV_ID@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:FP:'/niku/nu#action\:revmgr.costplandetailList&id='||I.ID||'&odf_return_to=npt.overview&plan_id='||FP.ID:LINK@

FROM INV_INVESTMENTS I
  INNER JOIN FIN_PLANS FP
    on FP.OBJECT_CODE = 'project'
    and FP.OBJECT_ID = I.ID
    and FP.PLAN_TYPE_CODE='FORECAST'
WHERE    @FILTER@

2) Declare the Link on the Query - notice the action is "URL Redirect to a Clarity Page" - you need to check whether you have that page in your system. If not, let me know.

Notice the "url" parameter will be your "LINK" attribute, the one you created in your query (in Bold Italic above).

3) This is the portlet

4) This is how you define the Cost Plan Link (do NOT mark Open as Pop-up):

Let me know if that's clearer

Alex

Thanks Alexander!! I'll give it a try and will let you know.

Regards

Flo

Alexander,

Is this an oracle query? because i'm getting an error message from Clarity

Error:NPT-0103: Error al intentar ejecutar la consulta. Mensaje nativo: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '|'. SQL Text: SELECT FP.ID PLAN_ID ,FP.NAME PLAN_NAME ,FP.CODE PLAN_CODE ,I.NAME INV_NAME ,I.CODE INV_CODE ,I.ID INV_ID ,'/niku/nu#action:revmgr.costplandetailList&id='||I.ID||'&odf_return_to=npt.overview&plan_id='||FP.ID LINK FROM INV_INVESTMENTS I INNER JOIN FIN_PLANS FP on FP.OBJECT_CODE = 'project' and FP.OBJECT_ID = I.ID and FP.PLAN_TYPE_CODE='FORECAST' WHERE 1=? and 1=1 .

Also, I have run a select from the FIN_PLANS table, and it does not show any records, is that ok?

Thanks!

Flo

Yes, you will need to convert it to the corresponding sql server syntax.

Problem is problem || which means concatenate...

Hi Alex,

Sorry I've been busy with other issues and wasn't able to try your suggestion. I was able to create the query on Clarity but it seems I don't have this page:

2) Declare the Link on the Query - notice the action is "URL Redirect to a Clarity Page" - you need to check whether you have that page in your system. If not, let me know.

Notice the "url" parameter will be your "LINK" attribute, the one you created in your query (in Bold Italic above).

I'll send it to you tomorrow, really easy to create. I remember having published it a while ago in the old communities site, but I bet it's no longer there :)

Hi Alexandre,

I also didn't find the Action Redirect to a Clarity Page, I'm using 12.1 release.

Could you please send me how did you created the page please ?

Thank you

Here you go, FloGoya and otahri

1) Create a HTML Portlet called "URL Redirect to a Clarity Page" (or something like that) with the following text:

<html>

<script>

var url = window.document.URL;

var redirect = url.substring(0,url.indexOf("niku/")-1)+ url.substring(url.indexOf('url=')+4);

location = redirect;

//alert(location );

</script>

</html>

2) Create a Portlet Page Without Tabs called "URL Redirect to a Clarity Page" (or something like that). It should be marked as "Linkable".

3) Add a Link Parameter called "url" with id "url" to your page (this name is important - as it relates to the code on step 1).

4) Add your portlet to the page.

Voi-là Habemus Page Redirect!!!

Hi Alex,

this code helped me, but when I try to go back, it returns to the redicert page and not to the list.

I changed the code to open a new window. So while the new window is opening, the redirect back to the list.

<html>

<script>

var url = window.document.URL;

var redirect = url.substring(0,url.indexOf("niku/")-1)+ url.substring(url.indexOf('url=')+4);

//location = redirect;

window.open(redirect, '_blank');

window.history.back();

</script>

</html>

This is another option for using this portlet.

Regards,

Bruno Piaui