Question
Pega Warning Table (pr_index_warnings) column 'pxiswarningjustified' possible values
As per the name of column('pxiswarningjustified'), it should contain either true or false as permissible values. If warning is justified value set as true which is ok.
But we have observed that lot of warning records are having 'null' value for this column and very few warnings records contains 'false'.
We are trying to get the acurate number of preflight warnings for our application ruleset rules. Is there any better way(apart from Guardrail report) to get the correct count of preflight warnings after upgrade to Pega 7.1.7 from Pega 6.2.
***Updated by moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***
Hi Yuvraj,
I am not sure about the enteries in your environment for "pxiswarningjustified".
Just to add on "to get the correct count of preflight warnings", You can try two ways :-
1. You can customised "pxRuleWarningsInAppAndFW" report definition based on your need. You can add an aggregate function on the column to get the count of the warnings and run the report.
2. Below query is to get the list of all warnings against ruleset versions
"SELECT
PXREFERENCINGRULESETNAME AS "RuleSet",
PXREFERENCINGRULESETVERSION AS "Version",
PXREFERENCINGCLASSNAME AS "Applies-To",
PXREFERENCINGOBJCLASS AS "RuleType",
PXREFERENCINGRULENAME AS "RuleName",
PXWARNINGNAME AS "Warning",
PXWARNINGSEVERITY AS "WarningSeverity",
PXWARNINGTYPE AS "WarningType",
PXWARNINGDETAILS AS "WarningDetails"
FROM
pega1.Pegarules.PR_INDEX_WARNINGS
WHERE
PXREFERENCINGRULESETNAME IN ('ImplApp', 'FW', 'Org', 'OrgInt')
AND PXREFERENCINGRULESETVERSION like '01-05-%'
AND pxIsWarningJustified IS NULL
ORDER BY
PXREFERENCINGRULESETNAME,
PXREFERENCINGRULESETVERSION,
PXREFERENCINGOBJCLASS,
PXREFERENCINGRULENAME;"
Kindly create index as well to enhance the performance the query as it may be slow due to large number of data retrieval.
create index pr_index_warnings_tidx1 on pr_index_warnings(PXREFERENCINGRULEINSKEY, PXOBJCLASS)
RUNSTATS ON TABLE pr_index_warnings
Kindly update me, if it helps.