Database view for interaction and task table

[Meenal Gharat]

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?

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

Thanks and Regards,

Meenal 

[Kieran Anson]

Hi,

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

[Gowrisankar Sat]

Use this in where clause:

interaction_number=tas_sys_id

[Meenal Gharat]

Hi Sativada ,

I tried has suggested yet no luck.

Thanks and Regards,

Meenal 

[Gowrisankar Sat · 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.