Skip to main content
Solved

define specific URL in stream message-API for event action


Forum|alt.badge.img+7

Dear all!

I am using the following code (it is just a poart of it) in an event action (Execute Online SQL) to inform people via stream message when they have been linked to a project task:

 

client_sys.Clear_Attr(attr_);     
client_sys.Add_To_Attr('FROM_', person_info_API.get_user_id('&NEW:RESPONSIBLE'), attr_); 
client_sys.Add_To_Attr('TO_NAMES_', USER_ID_, attr_);
client_sys.Add_To_Attr('HEADER_', 'You have been assigned.', attr_);
client_sys.Add_To_Attr('BODY_', 'You have been assigned in activity-sequence '||'&NEW:ACTIVITY_SEQ'|| ' to task' ||'&NEW:TASK_ID'|| ' Description: '||'&NEW:NAME'|| ' Thanks!', attr_);
client_sys.Add_To_Attr('URL_', 'ifsapf:frmActivity', attr_);

Transaction_SYS.Deferred_Call ('FND_STREAM_API.Create_Event_Action_Streams','PARAMETER', attr_, 'Inform PM');

 

Unfortunately the right window for the actual activity does not open when the user is clicking on the stream message as the URL is just generelly defined as seen above in green. 

 

Is there any chance to make the URL more specific, i.e.:

client_sys.Add_To_Attr('URL_', 'ifsapf:frmActivity?ACTIVITY_SEQ=$&NEW:ACTIVITY_SEQ$', attr_);

 

Anyone can support me with this?

 

Would be super interesting to know.

 

Thanks a lot!

 

Mattis

Best answer by eqbstal

IFSmattis,

Thanks to Johannes, I think that you should implement it as follows:

client_sys.Add_To_Attr('URL_', 'ifsapf:frmActivity?external_search=ACTIVITY_SEQ%3d' || &NEW:ACTIVITY_SEQ, attr_);

Steve

View original
Did this topic help you find an answer to your question?

4 replies

krestensb
Sidekick (Customer)
Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 40 replies
  • June 6, 2020

Why dont you use the Action Type=Streem Message and the url designer?


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 672 replies
  • June 8, 2020

IFSmattis,

I’m in favor of the solution of krestensb. However I understand that you want to use Execute Online SQL if there are more steps involved.

I think that you should try the following:

client_sys.Add_To_Attr('URL_', 'ifsapf:frmActivity?ACTIVITY_SEQ=' || &NEW:ACTIVITY_SEQ, attr_);

Steve

PS. Tried this myself (entering ifsapf:… directly in the address line), and even this doesn't work. Odd.


Novacura_jst
Hero (Partner)
Forum|alt.badge.img+7
  • Hero (Partner)
  • 49 replies
  • June 8, 2020

Hey Steve,

 

maybe you need to encode the = or use the external search function. We had some issues opening views with data from Novacura Flow (=external source) and when we used the external Search syntax it works. Maybe URLs in Stream messages are treated the same? I don’t really have the time to try it currently but there is a bunch of things you can try in the help below (no idea which environment it is the help from, i just googled it):

http://ifsappsrvprd01.australiasoutheast.cloudapp.azure.com:58080/ifsdoc/f1doc/Foundation1/050_development/022_user_interface/045_ee_dev/080_external_search/

 

Johannes


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 672 replies
  • Answer
  • June 8, 2020

IFSmattis,

Thanks to Johannes, I think that you should implement it as follows:

client_sys.Add_To_Attr('URL_', 'ifsapf:frmActivity?external_search=ACTIVITY_SEQ%3d' || &NEW:ACTIVITY_SEQ, attr_);

Steve


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings