FSM Business Rule XML Error

​@TDCANJANA Hi,

What do you have in the output parameter?, could you share, how the metadata is setup. Is the field that you are trying to get data from set as force select? Did you refresh cache after creating the metadata? if you could include screen shots of the business rule I might be able to better home in on the issue.

Best Regards,

Morris

Hi ​@Morris ,

No the field is not set up as a force select. Yes I did refresh cache after creating the metadata. I can also query the same view from FSM SQL Query Tool. My question is what are the steps that I should follow after I create a database view? Is it just creating the same in the Custom Metadata or something else?

This is how the metadata is setup.

In the output parameter I have a xml in the below format. With this xml I am trying to fetch a data from a field in this view and insert it in some other tables: 

<hierarchy_select>
 <primary_table>table_name</primary_table>
 <from>
 <table>table_name</table>
 <table>…</table>
 </from>
 <attrs>
 <attr>table_name.column_name</attr>
 <attr>…</attr>
 </attrs>
 <where>
 <data_constraint>
 <constraint>
 <left_operand>table_name.column_name</left_operand>
 <operator>operator</operator>
 <right_operand>value</right_operand>
 </constraint>
 </data_constraint>
 <join_constraint>
 <constraint>
 <left_operand>table_name.column_name</left_operand>
 <operator>operator</operator>
 <right_operand>table_name.column_name</right_operand>
 </constraint>
 </join_constraint>
 </where>
</hierarchy_select>

Hi ​@TDCANJANA,

The simple answer is yes, after the view is created in the database the metadata for the view must be added in FSM, otherwise it would not be able to utilize the views information. Also keep in mind that a view can be used with a business rule, however the view will not be able to trigger a business rule. 

Hope this answers your question.

Best Regards,

Morris