|
|
Rank: Member
Groups: Member
Joined: 1/14/2010
Posts: 28
Location: UK
|
Hi all, quick question, how do you search for tags which have been edited/created on a specific date? I have asked the tag search tool to search on creationdate but whatever format i enter the date, nothing comes back. some of you may know a better way of doing this, but the reason i need to do this is we have a number of users now all "playing" with the tags so to help me, i'd like to be able to do daily checks on tags created, or better yet find out a list of tags edited at any given time, like yesterday or a week last monday etc any help would be great. cheers guys, Pho 
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hi Pho, To do this manually, in the tag search dialogue go to the Advanced Search tab. Then just enter your query as something like: PIpoint.ChangeDate >= '01-Aug-2010 00:00:00' AND PIpoint.ChangeDate <= '02-Aug-2010 00:00:00' That will give you any point changed on the 1st of August 2010. You could further restrict your results to a point source or some other criteria, depends on how you want to monitor it. If you want to monitor from code, then you would form a similar query using the GetPoints method: myServer.GetPoints("ChangeDate >= '01-Aug-2010 00:00:00' AND ChangeDate <= '05-Aug-2010 00:00:00'") Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 1/14/2010
Posts: 28
Location: UK
|
arh yes good thinking! thanks for that
|
|
|
Rank: Member
Groups: Member
Joined: 1/14/2010
Posts: 28
Location: UK
|
hi all, i'm still having issues with this. now i'm just trying to pull out a list of tags created by a certain user. basic search i use Creator, the person's ID and search. It finds nothing. using advanced i use this: PIpoint.Creator = 'ID1234' and that doesn't find anything either yet i know the person has been creating tags in pi. any ideas?  with regards to the Date idea, the advanced optino didn't find anything. it only seems to find tags using basic search for the standard fields.
|
|
|
Rank: Member
Groups: Member
Joined: 1/14/2010
Posts: 28
Location: UK
|
ok i found what works... the old * needs to be in there...  think i had a Durhhh moment there! 
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hi Pho, Where did you stick the *? If you know the user id then you shouldn't need a wildcard. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 1/14/2010
Posts: 28
Location: UK
|
RJK Solutions wrote:Hi Pho,
To do this manually, in the tag search dialogue go to the Advanced Search tab.
Then just enter your query as something like:
PIpoint.ChangeDate >= '01-Aug-2010 00:00:00' AND PIpoint.ChangeDate <= '02-Aug-2010 00:00:00'
That will give you any point changed on the 1st of August 2010. You could further restrict your results to a point source or some other criteria, depends on how you want to monitor it.
If you want to monitor from code, then you would form a similar query using the GetPoints method:
myServer.GetPoints("ChangeDate >= '01-Aug-2010 00:00:00' AND ChangeDate <= '05-Aug-2010 00:00:00'")
hi guys, i'm having real trouble trying to do the above. whatever i put in, always comes back empty. I have even tried the exact query as above, and nothing yet i know we ahve tags created daily. any advice? thanks
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 5/28/2009
Posts: 75
Location: Cheshire, UK
|
Pho, I too could not find any points when I specify certain additional search criteria. It was suggested by our support contractor that it is a 'feature' of using an older version of PI! This is supported by the message I get if I try to search by Point Class - "PI 3.3 or greater si required to restrict search by Point Class". However I just retried searching by specifiing a descriptor (wildcarded - "01*") and an ExDesc and it worked! However (Mk II) I am unable to retrieve points if I add certain additional columns to the results area; ExDesc is OK but use ChangeDate and nothing is returned! I have tried Rhys' suggestion (PIpoint.ChangeDate >= '01-Aug-2010 00:00:00' AND PIpoint.ChangeDate <= '02-Aug-2010 00:00:00') and could not get it to work either.  Miles PI DataLink 3.1.5 MilesUK
ProcessBook v3.0.15.3
|
|
|
|
Guest
|
