Question

2
Replies
1725
Views
Dilipan Venkatesan (DilipanV105)
Atos Syntel
Consultant
Atos Syntel
IN
DilipanV105 Member since 2012 144 posts
Atos Syntel
Posted: June 9, 2017
Last activity: June 13, 2017
Posted: 9 Jun 2017 5:13 EDT
Last activity: 13 Jun 2017 9:33 EDT
Closed
Solved

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***

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.