Project and Portfolio Management Practitioners Forum
cancel

HOw to add Maximum Number of lines in Portlet query.

Highlighted
PPMRam
Super Contributor.

HOw to add Maximum Number of lines in Portlet query.

Hi,

 

 

I have created one Protlet in PPM 9.1.Now I need to change the Portlet query for adding one condition then it will not allow. It will allow fixed length of text only instead of that it will not allow even a single line also. Please help me on this, how I can process it.

 

How can I add maximum no of lines in Where condition with in the portlet query.

Thanks in Advance.

 

 

Thanks,

Haritha

1 REPLY
Utkarsh_Mishra
Acclaimed Contributor.

Re: HOw to add Maximum Number of lines in Portlet query.

You can start you where clause from

 

FROM section and can also use upto ORDER/GROUP BY section.

 

it is not necesaary to write the SQL where clause in WHERE field in datasource. It can be strated from FROM fields and can goes upto order by.

 

Datasource just concatinate all these section, so just make sure that your SQL is correct.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)