Active Query Builder support area

Number of metadata filter limits ?

Avatar
Andrew Kennard
  • updated
  • Completed

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

Replies 15
Avatar
0
Andrew Kennard

Setting the default_database like this under default schema does not seem to have an effect ?

<?xml version="1.0" encoding="UTF-8"?>

<default_schemas>
<item name="dbo" case_sens="0" />
</default_schemas>
<defaut_database>
<item name="Mydatabase" case_sens="0" />
</defaut_database>
<view>
<database>
<item name="Mydatabase" case_sens="0" />
</database>
<schema name="dbo" case_sens="0" />

....

Avatar
0
Andrey Zavyalov, PM

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.

Avatar
0
Andrew Kennard

Actually the first problem might be the Dataflex studio editor seeing field as a key word and sometimes making it Field

Avatar
0
Andrew Kennard

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

Avatar
0
Andrey Zavyalov, PM

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.