BradR
My feedback
-
156 votes
An error occurred while saving the comment BradR
supported this idea
·
-
4 votesBradR
supported this idea
·
-
13 votesBradR
supported this idea
·
-
16 votesBradR
supported this idea
·
-
32 votesBradR
supported this idea
·
-
110 votesBradR
supported this idea
·
-
150 votes
An error occurred while saving the comment 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.
An error occurred while saving the comment 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
·
An error occurred while saving the comment 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.
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"?