First of all thanks for getting Back Kasun,Esentially what we are trying to implement is the same type of control that you mentioned for Surveys with Refrerence field,but we want to do it at the answer level. So for Example if we have a survey question with 4 Possible answers ,we want to have the flexibility for customers so that few customer would have all 4 options visible while the few others would have only 3 visble to them We already have implemented the solution with difft surveys on the basis of reference id but that is causing us to have a lot of duplicatea as we see that most customers have the same survey question and only the answer options are different.
And does anybody know how the reference field is to be mapped
Hi Lee, I made the changes so that the sync rule now triggers on the parent table and not the ext table but the main issue is still there,it is not replicating at time of initialization and only happens after the schedule runs at the specified frequency ,Do we need to add the reference of the sync rule somewhere else as well ?
Hi Lee, I have attached the screenshot here and also the query which is configured to run at initialization <hierarchy_select return_only_requested_attrs="true" max_rows="50000"> <primary_table>c_iot_device_ext</primary_table> <from> <table>c_iot_device_ext</table> <table>product</table> </from> <attrs> <attr>C_IOT_DEVICE_EXT.EXT_HOSTNAME</attr> <attr>C_IOT_DEVICE_EXT.EXT_IP_ADDRESS</attr> <attr>C_IOT_DEVICE_EXT.EXT_MAC_ADDRESS</attr> <attr>C_IOT_DEVICE_EXT.EXT_LATEST_TOTAL_COUNTER</attr> <attr>C_IOT_DEVICE_EXT.EXT_LATEST_COLOR_COUNTER</attr> <attr>C_IOT_DEVICE_EXT.EXT_LATEST_BLACK_COUNTER</attr> <attr>C_IOT_DEVICE_EXT.EXT_LAST_CONNECTION_DTTM</attr> <attr>C_IOT_DEVICE_EXT.DEVICE_ID</attr> <attr>C_IOT_DEVICE_EXT.EXT_IOT_MONITORING_TOOL</attr> </attrs> <where>
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.