Skip to main content
Question

FSM 6 Update 10 - Request Sync Rule

  • February 17, 2022
  • 2 replies
  • 58 views

Forum|alt.badge.img+6
  • Sidekick (Employee)
  • 8 replies

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,

This topic has been closed for comments

2 replies

brian.gummin
Hero (Employee)
Forum|alt.badge.img+15
  • Hero (Employee)
  • 161 replies
  • February 18, 2022

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.


Jon Reid
Hero (Employee)
Forum|alt.badge.img+18
  • Hero (Employee)
  • 224 replies
  • February 18, 2022

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings