I'm wondering if it's possible to do a very general database query in EViews?
For example, I would like to be able to use @wquery like this:
@wquery("mydb", "* matches *Exports* and freq=Q", "name")
The key feature of the above code is the first wildcard (*) term in "* matches *Exports*".
My understanding is that I need to specify the first wildcard (*) term, which is typically something like "name" or "description".
The problem with this functionality is that it requires me to know the specific attribute of interest. As a user of a large database with many attributes, I won't necessarily know this information.
For example (hopefully understandable without providing a workfile): let's say my database contains two series called series1 and series2. Series1 has an attribute called "Table.Description" with a value of "Trade Exports Table". Series2 has an attribute called "Statistic" with a value "Exports of Goods". How do I write a general search for "Exports" so that the query returns both series1 and series2? Assume that I do not know the two attributes.
Thanks for the help!
- Graeme