rchandler

Help to retrieve data from PI OLEDB database

Discussion created by rchandler on Oct 22, 2012
Latest reply on Oct 23, 2012 by spilon

I am new to PI development. Currently I am developing a query  to return data.

 

I find that in snapshot , I can query data out, something like this: 

 

 

 

elemnt        attribute           time                        value

 

3SS 90%   Comment        ****                     ****
3SS 90%   DateTime        ****                     ****
3SS 90%   Description     ****                     ****
3SS 90%   Group              ****                     ****

 

 

 

I want to convert this this format in PI OLEDB commander:

 

element     time    Comment     DateTime   Description   Group

 

3SS 90%  ****       ****                  ****              ****                      ****

 

Does PI OLEDB have some specail way to turn   this table around?

 

Any suggestions will help me a lot. Thanks in advance!

 

 

 

 

 

 

Outcomes