BradR

My feedback

  1. 69 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  PI Server » Asset Framework (AF)  ·  Flag idea as inappropriate…  ·  Admin →
    BradR commented  · 

    I would like to use a substitution parameter in the WHERE clause to reference one of a group of attributes in the template.

    select mycolumn from mytable where table-ref-column = @template-ref-column%which -one%

    %which-one% would contain a numeric value.

    Is there a way to reference an array of "template-ref-column" to obtain the correct data from "mytable"?

    BradR supported this idea  · 
  2. 4 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  PI Server » Asset Framework (AF)  ·  Flag idea as inappropriate…  ·  Admin →
    BradR commented  · 

    Is it possible that there is a work around? If the table column is type Interger, will PI AF recognize the Interger value as a substitute for the enumerated value?

    Each enumerated value in an enumeration set is assigned a corresponding numeric value. For example, 1 = CAT, 2 = DOG, 3 = BIRD, etc. If the column/row contains a 3, will PI AF recognize that as BIRD if retrieved via table lookup into an attribute defined as an enumeration set?

    BradR supported this idea  · 
  3. 2 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Vision » Authoring Displays  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  4. 3 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Server » Notifications  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  5. 2 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Vision » Look & Feel / Styling  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  6. 8 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Vision » Events (EF)  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  7. 3 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Vision » User Experience  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  8. 27 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Vision » Symbols  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  9. 3 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Vision » Symbols  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  10. 24 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  PI Server » Asset Framework (AF)  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  11. 37 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Server » Asset Framework (AF)  ·  Flag idea as inappropriate…  ·  Admin →
    BradR supported this idea  · 
  12. 72 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RESEARCHING / EVALUATING  ·  22 comments  ·  PI Server » Asset Framework (AF)  ·  Flag idea as inappropriate…  ·  Admin →
    BradR commented  · 

    I may have discovered a side effect using the analysis to populate an event frame with the formatted value. Each time the EF creates a child, it appears that PI re-executes the analysis. If both the raw numeric value and the formatted string are stored in the EF, they may be different.

    I have an analysis that executes every 15 minutes. It stores the raw numeric data and the formatted string in separate AF attributes. I have a second event triggered analysis that creates an event frame if the raw numeric value exceeds it's Hi Limit. The EF contains the raw numeric value as it was when the original EF was created but the formatted string contains the current value.

    The ability to format the string in String Builder would eliminate the need for two attributes and this potential discrepancy.

    BradR commented  · 

    Using the string builder interface is confusing. The best method that I've found is to click the right arrow ">", look for the function, reference, etc. that I need and then type it in on another line. I've worked with at least two support engineers that have had similar problems when helping me via a Bomgar session.

    BradR supported this idea  · 
    BradR commented  · 

    We would like to see a format string that formats a number to a string and inserts commas in the appropriate positions. Example number 9999999 formats to 9,999,999
    along with decimals, currency, etc. Our primary use is when data from an event frame is included in a notification.

    String builder could also be used to read the data from the PI Archive and format it into the Event Frame attributes as a string.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED