Database view for interaction and task table

Meenal Gharat
Giga Guru

Hi All,

I have created database view for interaction and task table table.

But when trying to check no data is being displayed.

what should be the where clause?

find_real_file.png

 

find_real_file.pngI feel i have done mistake in where clause can someone please suggest where clause to join interaction and Task table

Thanks and Regards,

Meenal 

1 ACCEPTED SOLUTION

Hi Meenal,

I checked interaction table and there is no relation with task table.

You need a relation with task table to get data on database view.

Create a database view on interaction_related_record, interaction and task table to get data.

 

View solution in original post

7 REPLIES 7

Kieran Anson
Kilo Patron

Hi,

Interaction relation isn't stored on the interaction table however is on interaction_related_record.

Gowrisankar Sat
Tera Guru

 

Use this in where clause:

interaction_number=tas_sys_id

Hi Sativada ,

I tried has suggested yet no luck.

Thanks and Regards,

Meenal 

Hi Meenal,

I checked interaction table and there is no relation with task table.

You need a relation with task table to get data on database view.

Create a database view on interaction_related_record, interaction and task table to get data.