Question 4 Replies 112 Views × Close popover Bachir Radwan (BachirR6) Murex (SAS) Murex (SAS) LB View Profile Send Message BachirR6 Member since 2016 2 posts Murex (SAS) Posted: April 12, 2016 Last activity: April 15, 2016 Posted: 12 Apr 2016 3:58 EDT Last activity: 15 Apr 2016 4:42 EDT Closed Hello Guys, i'm trying to index some PEGA PR Tables in order to get information regarding cases, opportunities... My question is how to concatenate any case ID or Opportunity ID with a pre-defined URL entry, so when i search a company name "My Company", the result would be something like: "http://test/MyCompanyCaseID" or "http://test/MyCompanyOpportunityID". Why this question, because PEGA actually generate a dynamic URL every time you try accessing a certain information. Data Integration Reporting × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 5 years ago Posted: 14 Apr 2016 9:34 EDT × Close popover Santanu Bhattacherjee (Santanu) PEGA Manager CRM - Field Service Pegasystems Inc. IN View Profile Send Message Santanu PEGA replied to BachirR6 Hi, can you please elaborate your use case once ? What are the steps involved here etc. This will help us to analyze the query further. Posted: 5 years ago Posted: 14 Apr 2016 10:35 EDT × Close popover Bachir Radwan (BachirR6) Murex (SAS) Murex (SAS) LB View Profile Send Message BachirR6 Murex (SAS) replied to Santanu Hello, i'm installing Open Search Server, and i want to index PEGA's opportunities tables (for example). therefore, once a user will type a company name, the result should give something like "http://pegatestenv/OPPORTUNITY". i noticed that building a static URL to concatenate the opportunity ID (which is PZINSKEY in pega database) is a bit difficult and without any security thank you. Posted: 5 years ago Posted: 15 Apr 2016 4:00 EDT × Close popover Santanu Bhattacherjee (Santanu) PEGA Manager CRM - Field Service Pegasystems Inc. IN View Profile Send Message Santanu PEGA replied to BachirR6 Rajiv Nistala any pointer ? Posted: 5 years ago Posted: 15 Apr 2016 4:42 EDT × Close popover Rajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profile Send Message nistr PEGA replied to Santanu I am not sure I still understand the use case. Maybe a simple declare expression on a different property can create the URL by concatenating the opportunity id (based on the example) with a static string.