Project and Portfolio Management Practitioners Forum
cancel

My custom portlet doesn't work

SOLVED
Go to solution
Highlighted
Sevilay
Honored Contributor.

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
Acclaimed Contributor.

Re: My custom portlet doesn't work

Are you getting any errors?

Can you share the Query?

Regards,
Mahendran M
Sevilay
Honored Contributor.

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
Acclaimed Contributor.
Solution

Re: My custom portlet doesn't work

Glad It is resolved...

Regards,
Mahendran M
Sevilay
Honored Contributor.

Re: My custom portlet doesn't work

i remove the "in" keyword from the where clause.