Established Member.. Nilay___
Established Member..
367 views

portlet and data source conflict

Jump to solution

hi,

i created a module by using custom portlet definition.

Before creating data source from workbench i runned portlet's sql query on database. There were 83 results on db, but when i use this query in a portlet definition as a datasource; portlet's result and db result don't match. Portlet's result is 38, db result is 83 rows.

How may this happen, may i define column types wrong?

 

thanks....

0 Likes
1 Solution

Accepted Solutions
Highlighted
Established Member.. Nilay___
Established Member..

Re: portlet and data source conflict

Jump to solution

hi Alex,

 

thanks for your last offerings, i will take in consideration.

i tried your second recommendation and tried the exact data source query, data source adds rownumber<=200 limit, so i'm going to increase this value from conf file.

 

thanks for help.

View solution in original post

0 Likes
2 Replies
Absent Member.. AlexSavencu Absent Member..
Absent Member..

Re: portlet and data source conflict

Jump to solution

Hi,

 

1. my first guess is that the mapping is wrong in the portlet definition (maybe it is pointing to a different data source). To check this, go to edit portlet definition and check the data source name.

2. you can alter the SQL query in the datasource (to write FROOOOOM instead of FROM) to force PPM to show you the exact query that PPM is running - you can run this in your SQL query tool to compare the results.

 

Some more comments on your SQL:

1. It is a really bad idea to hard code IDs for your entities. If you do this in a DEV environment and then migrate to another environment, there is a fairly good chance that your query will not run properly, since the entities might not have the same ID in both environments. I would strongly suggest to always use entities names and/or references (where applicable).

2. It is a really bad idea (sorry 🙂 ) to post screenshots with live data and real persons - this is a conflict with any Non-Disclosure agreement you might have as an employee or contractor.

 

cheers

alex


--remember to kudos people who helped solve your problem
Highlighted
Established Member.. Nilay___
Established Member..

Re: portlet and data source conflict

Jump to solution

hi Alex,

 

thanks for your last offerings, i will take in consideration.

i tried your second recommendation and tried the exact data source query, data source adds rownumber<=200 limit, so i'm going to increase this value from conf file.

 

thanks for help.

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.