nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need sql query to pull the project name and availabilty

Sniper

Hi Team, I am new to this. We are using BIRT 2.6.2 version. We have merged the same with one of our application called as TMART. In TMART there is lot of applications that are getting monitored. So we need only the availability monitoring not any other parameter. When we ran this query we are getting the error as attached. Please find the attached script and error and let me know in case any modification is required.

Find more posts tagged with

Comments

Hans_vd

I'd say it's the $ and {} characters.What database are you querying?

Sniper

Hi Hans, Thanks for your quick reply. We are using oracle database for the querying.

Hans_vd

Ok, what are all these constructs? ${$USERID}{'Week'}${$DATETIME(${pmResults_Begin|'01/01/2000 00:00'})}${$DATETIME(${pmResults_End|'01/01/2020 23:59'})} Parameters?System variables?

Sniper

Hi Hans, These are parameters... But if you need i can provide the complete script... Actually this script is modified one... Let me know in case you need the complete script..

Hans_vd

Hi Sniper, Parameters need to be written as a ? in the query. So the query as it is in the file you uploaded will need to look like this:<div><pre class="_prettyXprint">SELECT projects.ProjectID_pk ProjectID, projects.ProjectName, tsd.MeasureName MName, SUM(tsd.ValCount) CountSeriesTime, SUM(tsd.ValSum)/SUM(tsd.ValCount) AvgValueFROM SCC_Projects projects INNER JOIN (SELECT DISTINCT pg.ProjectID_pk_fk FROM SCC_Projects_Groups pg INNER JOIN SCC_UserGroupRoles ugr ON pg.GroupID_pk_fk = ugr.GroupID_pk_fk WHERE ugr.UserID_pk_fk = ?) p2 ON (projects.ProjectID_pk = p2.ProjectID_pk_fk)INNER JOIN SV_V_Monitors_TimeSeriesData tsd ON projects.ProjectID_pk = tsd.ProjectID INNER JOIN SV_BusinessTransactions bt ON bt.MonitorID_pk_fk = tsd.MonitorID WHERE tsd.AggregationDescription = ?AND (projects.ProjectName = 'XYZ' OR tsd.MeasureName = 'Availability')AND tsd.SeriesTime >= ?AND tsd.SeriesTime <= ?GROUP BY projects.ProjectID_pk, projects.ProjectName, tsd.MeasureName, PerfTrt, PerfPageTimes, PerfCustom</pre></div>Now you need to add 4 dataset parameters.The parameters are bound in order of appearance in the query.

Sniper

Hi Hans, Thanks for quick reply. If you need i will upload the complete script so that you can re-design the script as above one.. Basically there are no parameter will be monitoring... Under a certain project name there will be multiple monitor for which availability is required.

Sniper

Hi Hans, Any update?

Hans_vd

What exactly is the problem right now?Do you have your query working?Any other exceptions the report runs into?

Sniper

There is no query we have currently... Thanks for the update... I am still working on the same. It seems to be i need to create a seperate parameter for the places that you marked as ? and then i can map the above query with BIRT. In case any issues will let you know..