How can we report on record producer variables in hr case using database view? It shows me Application restricted error.

masoomsharma
Tera Contributor

‎03-08-2017 04:35 PM

I was creating a database view between question_answer and hr case which is in Human Resources Core application but it gives me error and doesnt allow me to create it. Any idea how can we do it?

0 Helpfuls
  • 2,388 Views
8 REPLIES 8

Harsh Vardhan
Giga Patron
In response to masoomsharma

‎03-09-2017 08:05 PM

Hi Masoom,



i tried on my system and it is working. now i am able to access "question_answer" table in my custom application scope.


can you please share the screenshot?



Thanks,


Harshvardhan


0 Helpfuls

masoomsharma
Tera Contributor
In response to Harsh Vardhan

‎03-10-2017 08:18 AM

Please find it below :


find_real_file.png



find_real_file.png


Preview file
20 KB
Preview file
31 KB
0 Helpfuls

Carl Fransen1
Tera Guru

‎06-25-2018 04:10 PM

Hi Masoom,

I've just created this on my UAT system - see screenshot below.  I was in the Global app and was able to join the tables together.  Hope that helps you out.

 

find_real_file.png

 

Cheers

Carl.

Preview file
34 KB
0 Helpfuls

Carl Fransen1
Tera Guru
In response to Carl Fransen1

‎08-13-2018 06:57 PM

Did this fix your issue?  If so please mark as correct or helpful so it can benefit others in the community.

0 Helpfuls