The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

My custom portlet doesn't work

SOLVED
Go to solution
Highlighted
Sevilay
Collector

My custom portlet doesn't work

Hi,

i create a datasource and a custom list portlet.i bind this datasource to this custom portlet.When i copy the query in this portlet and run it in the sql navigator ,everthing is fine.Query works exactly.But when i preview this portlet or add it in a module,it shows no result.
i tried a lot.But i can't understand the reason.
Eventually i made the query very short.Even i remove the filters and complicated joins,there is a single table and 2 simple rows left in the datasource.But it doesn't work still.

Can anybody help me urgently?

Thanks in advance.
4 REPLIES
Mahen M
Honored Contributor

Re: My custom portlet doesn't work

Are you getting any errors?

Can you share the Query?

Regards,
Mahendran M
Sevilay
Collector

Re: My custom portlet doesn't work

Mahen hi again,

i found the problem.That is the "in" keyword at the where clause.it is very interesting but when i remove the "in" keyword ,it works.

i will try to make it more complex and make it as the drildown portlet.

This means i can ask another questions :)
But this is solved.

Regards.
Mahen M
Honored Contributor
Solution

Re: My custom portlet doesn't work

Glad It is resolved...

Regards,
Mahendran M
Sevilay
Collector

Re: My custom portlet doesn't work

i remove the "in" keyword from the where clause.
//Add this to "OnDomLoad" event