Project and Portfolio Management Practitioners Forum
cancel

Is it possible to increase the line number in the DataSource From Clause ?

Highlighted
Sevilay
Honored Contributor.

Is it possible to increase the line number in the DataSource From Clause ?

Hi,

i have a very complex query and it works in SQL Navigator.i want to make this query as a portlet.But there is a problem,i use crosstab ,left join and right join in that query,i have to make all the body of the query in a parantyhes after the from clause.
When i paste this part of the query in from clause ,not all the lines fit in it.I think there is a line quota,how can i increase this ?

Thanks in advance.
7 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

Hi,

You can create a database view out of your query and refer to the view in the data source...
Sevilay
Honored Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

Thanks Erik,

i will try it.
Sevilay
Honored Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

Erik, by the way how can i pass parameters to this view?
i want to make 2 date field as a filter variable.When the user chooes these dates,the value of this parameters should pass into the query.But these date field parameters are not in the final select fields.
i hope i can explain the situaiton.
Thanks.
Erik Cole
Acclaimed Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

You'll need to have them as columns in the view so you can filter with them, but you don't need to select (display) them.
Sevilay
Honored Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

Because of the structure of the query,i can't put them in the select part of the query.
Can i post it you indivudually if you don't mind ?
Thanks.
Michael.Ebert
Super Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

Hi,

you can' increase the field size.
But you can put the remaining lines into the field for the where clause.
PPM concatenates both field (from and where clause) when querying the database.

Regards,
Michael
Sevilay
Honored Contributor.

Re: Is it possible to increase the line number in the DataSource From Clause ?

Hi Michael,

i know this and still my query doesn't fit into overall lines of the where clause.
There is also a limit for the lines.

Also there is no need anymore,i'll give the report in excel format.

Thanks for your interest.