Is there a limit to the number of MetaDataFilterItems that one can add to filter a list of views ?
I'm wanting to filter by a 'list' of specific filenames rather than wildcard filters 'vw%' etc
Is there a low limit or is it effectively unlimited ?
Thanks
I've downloaded the Metadata editor and had a go at doing this and have found some bugs
Although the Metadata editor produces valid XML the field elements are sometimes <field> and other times <Field>
When LoadFromXML reads this information it looks like it is expecting <field> because all of the <Field> elements are missing
The second problem is that the SQL created from tables loaded using the 'online' database produced a statement like
Select qvwMoney.Finance_Period, qvwMoney.Donation_Amount .......
Where as if it is loaded from the XML it produces
Select [Mydatabase].dbo.qvwMoney.Finance_Period, [Mydatabase].dbo.qvwMoney.Donation_Amount ....
Whilst both are obviously valid it meas I cannot simply save the SQL string from one method and load it into the other even though they are both for the same database
Thanks
Actually the first problem might be the Dataflex studio editor seeing field as a key word and sometimes making it Field
Well, if the first problem does not relate to our software, then the answer is needed only for the second one...
To solve the second problem please specify the "defaut_database" element inside the "metadata" element in XML file by handand set it's value to "Mydatabase". Also you can set it programmatically using the ActiveQueryBuilderX.MetadataContainer.DefaultDatabase property.
Setting the default_database like this under default schema does not seem to have an effect ?
<?xml version="1.0" encoding="UTF-8"?>
....
Sorry, my mistake. There's a typo in my message. Please correct "defaut_database" to "default_database".
Thanks, I thought it was me :)
I'm still not quite there in terms of I still cannot set the LayoutSQL from 'online' version to a version that has been loaded from the XML
Still digging
Setting or getting the LayoutSQL property has no connection with operations perfomed with the Metadata Container...
OK the specific problem with this particular query seems to be a difference in one field in online/offline modes that is returneed in the string from LayoutSQL
ONLINE
qvwMoney.Source
OFFLINE
qvwMoney.[Source]
Interestingly a field called qvwMoney.[Group] is [] in both cases
If I add/remove the [] in the debugger then I can load SQL created in one into the other
Hello,
There is no limit on the number of metadata filter items; you can add as many items as you wish. But if you have a list of objects to show, it might be a good idea to load metadata from the pre-generated XML file. You can download the Metadata editor tool from the download page. Using it, you can load metadata from your database, remove unwanted objects and then save this information to the XML file. You can load it using the MetadataContainer.LoadFromXMLFile method or you can save the content of this file in resource and load as a string using the MetadataContainer.LoadFromXML method.