Designing Process Data Fields and custom Dashboard

  • 5 April 2017
  • 1 reply
  • 3 views

Hi,

 

I am looking for guidance, advice and experience on desiging process data fields.

 

I am looking to store initially around 10 fields as the process data fields such as id, name, address, date of birth etc and some text data. Based on the whitepaper for k2 blackpearl the guidance is to used process data fields to store ids only and then use smart objects to populate the data fields instead of creating multiple process data fields.

 

What is the practice based on the experience? Do you have any recommendations? What are the pros and cons for each approach?

 

The other goal is to create a custom dashboard which would display a list of work items. Some columns on the dashboard will be process data created by K2 such as datetime created and others are from provided process data fields.

We have a solution to display data from the process data fields using K2 API but if some of the columns have to come from a smart object can we then somehow combine the two?

 

The dashboard will also need functionality to sort and filter on various columns.

 

Would you have any recommendations on how to achieve this based on experience and best practice?

 

Thanks,

Nataliya

 


1 reply

Userlevel 4
Badge +13

Hi Nataliya


 


I found these links that might be off some help.


 


The process data fields are designed to contain values from multiple different data types not just integers (Id's), therefore the data fields should be ablte to accomodate, name, address, date of birth, etc. please see this article based on what data types are supported by the data fields: (https://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.6/webframe.html#reference-processactivitydatabrowser_adddatafield.html).


 





































BooleanA logical value including True, False, 0 and 1
DateDate value in the format YYYY-MM-DD
DecimalA numeric value that may or may not contain a fractional part
DoubleAny 64-bit floating-type real number
e.g. 1E4, 1267.43233E12, 12.78e-2, 12
IntegerStores whole numbers in the following range: -2,147,483,648 though 2,147,483,647
LongUsed to stored whole numbers from: -9,223,372,036,854,775,808 through to 9,223,372,036,854,775,808.
StringUsed to store standard ANSI text characters in strings of variable size
BinaryEncoded binary information

 


 


Additional Reference:


https://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.6.6/webframe.html#Data_Fields.html


 


Regards,


Raymond

Reply