Toggle Sidebar
  • Recent updates
    • Post is under moderation
      Currently only Single User Fields can be defined as owner of an item per state. It would be helpful to be able to select a Sub-Relational Field that points to a user-field in an AUX or Primary Table a...s owner. In case you're clasifying the items by any relational-field (AUX-Table) and depending on that choice there are different responsible persons to handle the issues, Sub-Relational fields are perfectly suitable to show always the correct responsible person. Unfortunately this user field can not be used as the owner of the item as it's a Sub-Relational field, which leads you to use scripts instead of built-in functunality. I would appriciate to see this option coming. It would help us a lot. More
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Karen Easton
      Karen Easton unlocked the badge Great Reader
      Great Reader
      Loves reading through articles.
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Karen Easton
      Karen Easton is now following Dustin Hohnstein
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Karen Easton
      Karen Easton liked a video contributed by Dustin Hohnstein
      Demonstration of the SBM Time Processing System Process Application
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Advanced SQL (Pass-through SQL) WHERE clauses in reports do not support "query at run-time". Allow me to prompt for multiple values at report run-time and use those in an Advanced SQL WHERE clause. Al...low prompting the user for string values to be passed to Advanced "pass-through" SQL report WHERE clauses. Using an example from the Reports Guide for "Finding Items Submitted by Members of a Group". Here is the example from the Guide: @WHERE tablename.TS_SUBMITTER IN ( SELECT TS_ID FROM TS_USERS WHERE TS_USERS.TS_ID IN ( SELECT TS_USERID FROM TS_MEMBERS WHERE TS_MEMBERS.TS_GROUPID IN ( SELECT TS_ID FROM TS_GROUPS WHERE TS_GROUPS.TS_NAME = 'Technical Support' ) ) ) Here is the example using Query At Runtime for the name of the group instead of the hard-coded value "Technical Support": @WHERE tablename.TS_SUBMITTER IN ( SELECT TS_ID FROM TS_USERS WHERE TS_USERS.TS_ID IN ( SELECT TS_USERID FROM TS_MEMBERS WHERE TS_MEMBERS.TS_GROUPID IN ( SELECT TS_ID FROM TS_GROUPS WHERE TS_GROUPS.TS_NAME like '%{Enter group name or partial name}%' ) ) ) That report would prompt the user "Enter group name or partial name". The response would be substituted into the WHERE clause where it is surrounded by "%" wildcards. More
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Karen Easton
      Built on SBM 11.2 Provides basic tracking of projects, milestones and tasks Milestones and tasks are created from the project record. Embedded reports on the project display related tasks & miles...tones Includes workflows, fields, forms and reports Project workflow decisions route based upon whether the actual due date was met and sets a binary field. Form actions to display status icon and size indicator icon. More
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Karen Easton
      Karen Easton unlocked the badge Points Achiever
      Points Achiever
      Earn points on the site.
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Currently, subrelational fields are available when creating notification rules, but they aren't available when specifying the Delay Parameters on Escalations.
      Stream item published successfully. Item will now be visible on your stream.
  • No blogs available.

  • DateTitle
    10/04/2017 Logical Tab Stops

Recent Tweets