06-26-2014 10:58 PM
I searched the docs but couldn't find an example of a URI searching on multiple criteria. For example, I want to return all Oracle libraries that are pre-assigned.
Using DMS, I ran the metabrowse and metafind commands. For metafind, I could enter SASLibrary?@engine='Oracle' and SASLibrary?@IsPreassigned='1', but couldn't work out how to combine the two.
Before Paul beats me to it, I'm sure the best solution is to license Metacoda's plugins ;-). In lieu of that, the syntax to combine criteria in a metafind URI, and esp. a link to the doc that I've somehow missed, would be greatly appreciated.
06-27-2014 03:04 AM
Hi Scott - try this.
It should show all currently assigned Oracle libraries:
select * from dictionary.libnames where find(engine,"ORACLE","I")
select * from dictionary.libnames where find(sysdesc,"ORACLE","I");
06-27-2014 03:56 AM
I meant the attributes based on the metadata. The use case is Oracle is down (so the libraries aren't allocated), and I want to turn off Pre Assigned in the SMC.
Or I just want to search the metadata for whatever reason, say for some custom attributes.
06-27-2014 05:05 AM
Try the XMLSELECT filter expression:
SASLibrary[ @Engine = 'ORACLE' and @IsPreassigned = '1' ]
If you have access to SAS Management Console you can also use our free Metacoda Metadata Explorer Plug-in. I wrote a blog post "Metacoda's Metadata Explorer Plug-in" about it a while back which includes a few example XMLSELECT filter expressions, and also a link to the SAS documentation that has more examples.