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 

[Meenal Gharat]

Hi Gowrsankar,

It worked thanks for your response.

Thanks and Reards,

Meenal 

[Russell Park]

@Meenal Gharat I came across this article and wondering if you could share a few screen shots for the database view you setup.  This is exactly what I am looking for!  Thanks for any help you can provide.

Russell

[Meenal Gharat]

Hi Sativada,

I tried implementing above it worked....But if I'm creating Interaction Manually whose state is NEW it doesn't display's the record the database View.

Also If I create Interaction manually and it has associated Task then it worked all fine.

Any suggestion would be helpful.

Thanks and Regards,

Meenal gharat