Community Poll

Posted on July 8, 2019 by MarissaRogers

What Motivates You to Participate Here in the PSC?

Passion to help others
27% (27 votes)
Learn Pega
32% (32 votes)
Participate in Ask the Expert sessions
2% (2 votes)
Get answers to my questions
24% (24 votes)
Get recognized as Participant of the week
5% (5 votes)
Network with Pega professionals
6% (6 votes)
Check out what's new at Pega
4% (4 votes)
Total votes: 100
Groups audience: 
Pega Support
Closed

clob data in pega

Discussion posted by RAJUS002 on July 29, 2009

How to write xml data into a CLOB column in the database from pega **Moderation Team has archived post** This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please writ ...

Database management
Reply posted on July 30, 2009 by RAJUS002

Thanks for your reply. I do have this information but i need a better approach. I believe having java code for database operation in pega is not a good approach. In my case the xml is huge more than the limit.

Closed

pxLockHandle property

Discussion posted by AkashAgarwal on July 10, 2009

What is the purpose of pxLockHandle property on pyWorkPage. Does it always have the same value as pzInsKey? **Moderation Team has archived post** This post has been archived for educational purposes. Contents and links will no longer be updated. If you ha ...

Database management
Reply posted on July 13, 2009 by MARIK-1Pega

quote: Originally posted by AkashAgarwal Thanks for your reply. One more related query. When a work object is opened in review mode, pxLockHandle contains the pzInsKey of the work object. Does that imply that Pega locks the work object when opened in...

Closed

Obj-List criteria

Discussion posted by mikeward on July 11, 2009

I need to be able to obtain a list of items based on a SUBSTR value within pzInsKey... The following query returns the needed data via sqlplus: select pzinskey from pc_data_workattach where pxobjclass = 'classname' and (pzinskey like '%2009 ...

Database management
Reply posted on July 11, 2009 by MIRATPega

It looks like you are just filtering on the creation date time of the work object, which is an exposed datetime column 'pxCreateDateTime' that you should be able to just do any standard date filtering on, instead of relying on parsing a...

Closed

Unable to see properties for Page Class

Discussion posted by DUTTAU01 on July 8, 2009

I have data classes defined in separate rule set. When I create a page list to a work classp, using the data class created earler, the propertise of data class, dont show up when I expand the page class under the work class. Any clue, why this unexpected ...

Database management
Reply posted on July 9, 2009 by BYRNBPega

To clarify-- the properties don't show up as expected in the Application Explorer? or don't show up somewhere else? Where?

Closed

Group of value list

Discussion posted by RAJESH.PEGA on June 19, 2009

Hi, is there any way i can create a group of value lists. Example Group Group("Key 1") valuelist(1) valuelist(2) Group("Key 2") valuelist(1) valuelist(2) valuelist(3) Group("key 3") valuelist(1) valuelist(2) Please let me kno ...

Database management
Reply posted on June 19, 2009 by RAJESH.PEGA

Thanks. I figured it out. I created a class with a single property of Value List type. Then i created a page group with that class. i got the same data structure i needed

Closed

Question on saving properties

Discussion posted by AVATAPAS on June 15, 2009

I have a requirement where there is a class A. This class (and its wrapper classes) has let’s say 10 properties. I want to persist only 5 properties. Rest I want to use them for presentation layer. I know we can use params and local variables but we can’t ...

Database management
Reply posted on June 16, 2009 by GARFJ

AVATAPAS wrote: I want to persist only 5 properties. Rest I want to use them for presentation layer. Is there any harm in persisting the others? Would they use too much space? I can think of one example where your presentation property would be...

Closed

Assignment Status

Discussion posted by SURURYKURESH on April 13, 2009

Hi We have a requirement in our project where pyAssignmentStatus property has values greater than 32 in almost all the statuses And for displaying the Worklist,Workbasket and many other reports to display pending actions for users we are using views and w ...

Database management
Reply posted on June 3, 2009 by MARIK-1Pega

pyAssignmentStatus does not need to hold the text that the user sees in the report. pyAssignmentStatus merely contains the key to a Rule-Obj-Fieldvalue (fieldname pyStatusLabel), and the fieldvalue's localized label field can contain as much text...

Closed

Work object migration from 4.2 sp6 to 5.4 SP2 CPM

Discussion posted by PENMETSH on May 8, 2009

Can anyone please suggest some methodologies for the Migration of Work Objects from 4.2 SP6 to 5.4 SP2 version and we have CPM HC 7.2 version on top of 5.4 SP2.So the Work Object migration should support CPM HC class structure as well.If anyone has any do ...

Database management
Reply posted on May 8, 2009 by HERTC

Duplicate posting – please reply instead to the following: /node/20059