Review Integrify and Get $25 on Amazon!

Edit Form Questions

Follow

Comments

2 comments

  • Avatar
    Rich Verjinski

    Tip:  When using the DB tab to populate options in a Checkbox, Radio Button or Select List... remember that the query results may include records that have been deleted (but are not really deleted in the underlying Integrify DB).   To accommodate this, check if the record has not been deleted by adding DELETED_DATE IS NULL to the where clause.

    Example:  
    SELECT INSTANCE_NAME
    FROM INSTANCE
    WHERE INSTANCE_NAME LIKE 'Process Name%' and DELETED_DATE IS NULL;

    Works like a champ!

    1
    Comment actions Permalink
  • Avatar
    Mike

    Great tip, Rich!

    0
    Comment actions Permalink

Please sign in to leave a comment.