You can translate the question and the replies:

How to get the all views mandatory Filtes?

Hi Denodo Team, We need to get all the views that we have defined mandatory paramters, we need this metedata for further analysis, can you let us how we get it. Is there some file stored in Server side contained this kind of information? looking forward to this kind of information! Thanks.
user
16-07-2020 01:58:31 -0400

4 Answers

Hi, There's an enhancement request to add support for what you describe that’s currently being considered for a future update of the Denodo Platform. The enhancement would allow you to check for the metadata information about the mandatory fields of a view and would help you in differentiating the mandatory field from the other fields of a view. At the moment, I would suggest you collect the information about the mandatory fields and its associated views from the VQL of the metadata [export](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/exporting_and_importing_the_server_metadata/exporting_the_server_metadata/exporting_the_server_metadata#exporting-the-server-metadata). In the VQL file, you could search for the constraint '(OBL)'. Hope this helps!
Denodo Team
16-07-2020 05:04:52 -0400
Hi, I export our derived views, but I can not see the 'OBL' pattern, but below view definitely has the mandotory filters, see the derived view vql is something like below: CREATE OR REPLACE VIEW ldge_eu_rts_fx FOLDER = '/04-aa/bb/cc' AS SELECT fp_dge_rates_fx.rtgroup AS rtgroup, rtrim(fp_dge_rts_fx.fromuom) AS fromuom, rtrim(fp_dge_rts_fx.touom) AS touom, fp_dge_rats_fx.rttp AS rttp, fp_dge_rats_fx.effectdate AS effectdate, fp_dge_rats_fx.convrate AS convrate, fp_dge_rats_fx.effectivedate_from AS effectivedate_from, fp_dge_rats_fx.effectivedate_to AS effectivedate_to FROM fp_dge_rats_fx; ALTER VIEW ldge_eu_rts_fx LAYOUT (fp_ldge_eu_rts_fx = [20, 20, 233, 186]);
user
 Edited on: 08-09-2020 01:28:06 -0400
hi, can you please reply above?
user
 Edited on: 08-09-2020 01:28:06 -0400
Hi, If I had to retrieve the mandatory fields in Derived views, then I would use the DESC command *DESC VIEW <view name>* from the VQL shell. In the output, I would get the Mandatory field details under "capacities" in the output with the constraint (OBL). For example: > DESC VIEW ldge_eu_rts_fx; I would also review the documentation on [Output Schema of the DESC Commands](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands) to be more familiar with this. Hope this helps!
Denodo Team
27-07-2020 02:30:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here