Hi everyone, Related to FSM 6 UPD10, we realized that the REQUEST syncrule (Initial query) is mentioning two database views (‘task_assigment_view2’ and ‘task1_view’) that seems does not exist.
If I query for the related views I get the next error:
Please, see attached document with the XML SYNCRULE.
Can someone help me on this?
Thanks and regards,
+15
Those <table> references are defined as aliases in metadata. They do no exist in the data schema. You can find those table_name values on the FSM Metadata screen (if using a STUDIO license). Aliases are a mechanism in metadata to allow joining to the same table or view multiple times.
+17
To further clarify Brian’s comment, these views are metadata-only and do not exist in the database. There are used in the server code only to process hierarchy selects referencing the same table/view more than once in the same query.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
