Question
Atos Syntel
IN
Last activity: 13 Jun 2017 9:33 EDT
Use of Get row key checkbox in Report Definition
What is the use of Get row key checkbox in Report definition, i can see that the key gets added to the sql select when checked but what is the use of that.
sql query when Get row key unchecked
SELECT "PC0"."pyuseridentifier" AS "pyUserIdentifier" , "PC0"."pyusername" AS "pyUserName" , "PC0"."pyaccessgroup" AS "pyAccessGroup" FROM personaledition.pr_operators "PC0" WHERE ( "PC0"."pyorganization" = ? ) AND "PC0"."pxobjclass" = ? ORDER BY 2 ASC, 3 ASC, 1 ASC
sql query when Get row key checked
SELECT "PC0"."pyuseridentifier" AS "pyUserIdentifier" , "PC0"."pyusername" AS "pyUserName" , "PC0"."pyaccessgroup" AS "pyAccessGroup" , "PC0"."pzinskey" AS "pzInsKey" FROM personaledition.pr_operators "PC0" WHERE ( "PC0"."pyorganization" = ? ) AND "PC0"."pxobjclass" = ? ORDER BY 2 ASC, 3 ASC, 1 ASC
***Updated by moderator: Lochan to update Categories***
Accepted Solution
Pegasystems Inc.
IN
HI Dilipan,
Yes,When "Get Row Key" is checked, the key of the table (usually the pzInsKey property, for internal classes) is included among the columns listed in the select clause.
Including the row key depends on one's requirement.
For example,In report browser,when user clicks on any row of the grid in the report the corresponding case gets opened.If you want to suppress this behaviour then "Get row key" has to be unchecked.
Incessant Technologies
IN
Hi,
"Get Row Key" is used to get the pzinskeys of the records we get from the table. Mostly we use it when we want to eliminate duplicates in the report as this option gets pzinskey and objclass in combination. When we select Get Row Keys option we dont have remove duplicates option in the query tab cause both serve the same purpose.
Thanks.
Accepted Solution
Pegasystems Inc.
IN
HI Dilipan,
Yes,When "Get Row Key" is checked, the key of the table (usually the pzInsKey property, for internal classes) is included among the columns listed in the select clause.
Including the row key depends on one's requirement.
For example,In report browser,when user clicks on any row of the grid in the report the corresponding case gets opened.If you want to suppress this behaviour then "Get row key" has to be unchecked.