Content Management and Capture

Content Management and Capture

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  Custom field in Job Monitor

    Posted Fri January 03, 2020 07:50 AM
    Edited by System Admin Wed July 15, 2020 10:12 AM
    Hello,
    I would like to ask for an advise.
    I created custom column in Job Monitor in ICN according to instructions found here https://www.ibm.com/support/knowledgecenter/en/SSZRWV_9.0.0/com.ibm.dc.admin.doc/dcajm002.htm.
    But I need to have that column to be of type DateTime. If I set data type datetime in db (mssql), in ICN it still appears as string, which means when I try to create filter with that column as condition, I only have options Like, equals, does not equal. There should be before, after and range (as for Job Start column).
    Is there any option to set column type to DateTime in ICN? 
    Is there any option to set format of column in Job Monitor in ICN? (In db the format is like MM.dd.yyyy and in ICN it appears as dd.MM.yyyy. If I change calendar type in ICN, displayed format of that custom column does not change).
    We use ICN 3.0.5 and Datacap Web Plugin 915.
    Thanks in advance.

    ------------------------------
    Jana Heršková
    ------------------------------


  • 2.  RE: Custom field in Job Monitor

    Posted Mon January 06, 2020 03:36 AM
    Hi Jana,

    for custom job monitor fields you can only use string or integer datatype fields in the database. You can use string for you date value. I did this also in the past. At first time I did this like you but IBM support told me that only string and integer is supported. 

    ------------------------------
    Benjamin Just
    ------------------------------

    Original Message


  • 3.  RE: Custom field in Job Monitor

    Posted Thu January 09, 2020 03:55 AM
    Hello Benjamin,
    thank you for your answer.

    ------------------------------
    Jana Heršková
    ------------------------------

    Original Message


Related Content