Hello all,
We are facing the below problem:
We have the table “TASK” and the custom table “C_CARDPHONECOMPLETIONINFO”.
They have the below parent relation.
The problem is that in the mobile client, in the “Mobile Designer” screen we have selected “TASK” as our primary table, we are able to see the “TASK” fields, but we cannot see the “C_CARDPHONECOMPLETIONINFO” fields.
So my questions is:
Do you know if we are missing any step on this action?
Hi
Even though you created a task parent relationship with the newly created table, it will not sync to Mobile. You have to define that table in the sync rule(You need to create a new sync rule for your new table or add this new table to Task sync rule).
Thanks,
Hasara
Hello,
If I understood you correctly, you are expecting the behavior of the relationship “Extension”. This is the only instance where you can expect the custom fields you created in your custom table (C_CARDPHONECOMPLETIONINFO) to be present in the “Task” table.
The “Parent” relationship will not work here for your requirements stated above.
K
Hello all, thanks for the answers!
Plase find below the code from the Related Query.
Could you please help us to understand what we are doing wrong?
<hierarchy_select return_only_requested_attrs="true" max_rows="50000">
<primary_table>TASK</primary_table>
<from>
<table>TASK</table>
<table>PLACE</table>
<table>PLACE_ADDRESS</table>
<table>ADDRESS</table>
<table>CONTACT</table>
<table>REQUEST</table>
<table>REQUEST_CONTACT</table>
<table>REQUEST_UNIT</table>
<table>RECEIVING</table>
<table>RECEIVING_UNIT</table>
<table>PRODUCT</table>
<table>MODEL</table>
<table>PART_NEED</table>
<table>TASK_TEXT</table>
<table>REQUEST_TEXT</table>
<table>NON_PART_USAGE</table>
<table>PART_USAGE</table>
<table>PART_DISP</table>
<table>SURVEY_RESULT</table>
<table>TASK_STEPS</table>
<table>TASK_STEPS_ATTACHMENT</table>
<table>ATTACHMENT_ALIAS</table>
<table>TASK_UNIT</table>
<table>TASK_EVENT</table>
<table>TASK_CONTACT</table>
<table>SHIPMENT</table>
<table>TASK_ATTACHMENT</table>
<table>ATTACHMENT</table>
<table>TIME_CLOCK_EVENT</table>
<table>ESCALATION</table>
<table>CONTRACT</table>
<table>CONTR_TYPE</table>
<table>WARRANTY_COVERAGE</table>
<table>TIME_COMMIT</table>
<table>QUALITY</table>
<table>TASK_ASSIGNMENT_VIEW</table>
<table>TASK_RESOURCE</table>
<table>C_CARDPHONECOMPLETIONINFO</table>
</from>
<attrs>
<attr>TASK.*</attr>
<attr>PLACE.*</attr>
<attr>PLACE_ADDRESS.*</attr>
<attr>ADDRESS.*</attr>
<attr>CONTACT.*</attr>
<attr>REQUEST.*</attr>
<attr>REQUEST_CONTACT.*</attr>
<attr>REQUEST_UNIT.*</attr>
<attr>REQUEST_TEXT.*</attr>
<attr>RECEIVING.*</attr>
<attr>RECEIVING_UNIT.*</attr>
<attr>PRODUCT.*</attr>
<attr>MODEL.*</attr>
<attr>PART_NEED.*</attr>
<attr>TASK_TEXT.*</attr>
<attr>NON_PART_USAGE.*</attr>
<attr>PART_USAGE.*</attr>
<attr>PART_DISP.*</attr>
<attr>SURVEY_RESULT.*</attr>
<attr>TASK_STEPS.*</attr>
<attr>TASK_STEPS_ATTACHMENT.*</attr>
<attr>ATTACHMENT_ALIAS.*</attr>
<attr>TASK_UNIT.*</attr>
<attr>TASK_EVENT.*</attr>
<attr>TASK_CONTACT.*</attr>
<attr>SHIPMENT.*</attr>
<attr>TASK_ATTACHMENT.*</attr>
<attr>ATTACHMENT.*</attr>
<attr>TIME_CLOCK_EVENT.*</attr>
<attr>ESCALATION.*</attr>
<attr>CONTRACT.*</attr>
<attr>CONTR_TYPE.*</attr>
<attr>WARRANTY_COVERAGE.*</attr>
<attr>TIME_COMMIT.*</attr>
<attr>QUALITY.*</attr>
<attr>TASK_RESOURCE.*</attr>
<attr>C_CARDPHONECOMPLETIONINFO.*</attr>
</attrs>
<where>
<data_constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>eq</operator>
<right_operand>{TASK_ID}</right_operand>
</constraint>
<and/>
<constraint>
<left_operand>task.status</left_operand>
<operator>eq</operator>
<right_operand>OP</right_operand>
</constraint>
<and/>
<parens>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>OPEN</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>ASSIGNED</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>COMMITTED</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>ACCEPTED</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>ENROUTE</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>ARRIVED</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>IN PROCESS</right_operand>
</constraint>
<or/>
<constraint>
<left_operand>task.task_status</left_operand>
<operator>eq</operator>
<right_operand>RECEIVED</right_operand>
</constraint>
</parens>
<and/>
<constraint>
<left_operand>receiving.inventory_adjusted</left_operand>
<operator>eq</operator>
<right_operand>N</right_operand>
</constraint>
</data_constraint>
<join_constraint>
<constraint>
<left_operand>TASK.REQUEST_ID</left_operand>
<operator>equi</operator>
<right_operand>REQUEST.REQUEST_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.PLACE_ID_CUST</left_operand>
<operator>left_outer</operator>
<right_operand>PLACE.PLACE_ID</right_operand>
</constraint>
<constraint>
<left_operand>PLACE.PLACE_ID</left_operand>
<operator>left_outer</operator>
<right_operand>PLACE_ADDRESS.PLACE_ID</right_operand>
</constraint>
<constraint>
<left_operand>PLACE_ADDRESS.ADDRESS_ID</left_operand>
<operator>left_outer</operator>
<right_operand>ADDRESS.ADDRESS_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.CONTACT_SEQUENCE</left_operand>
<operator>left_outer</operator>
<right_operand>CONTACT.CONTACT_SEQUENCE</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST.REQUEST_ID</left_operand>
<operator>left_outer</operator>
<right_operand>REQUEST_CONTACT.REQUEST_ID</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST.REQUEST_ID</left_operand>
<operator>left_outer</operator>
<right_operand>REQUEST_UNIT.REQUEST_ID</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST.REQUEST_ID</left_operand>
<operator>left_outer</operator>
<right_operand>PART_NEED.REQUEST_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_TEXT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>NON_PART_USAGE.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>PART_USAGE.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.PRODUCT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>PRODUCT.PRODUCT_ID</right_operand>
</constraint>
<constraint>
<left_operand>PRODUCT.MODEL_ID</left_operand>
<operator>left_outer</operator>
<right_operand>MODEL.MODEL_ID</right_operand>
</constraint>
<constraint>
<left_operand>PART_USAGE.PU_ID</left_operand>
<operator>left_outer</operator>
<right_operand>PART_DISP.PU_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>SURVEY_RESULT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_RESOURCE.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_STEPS.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK_STEPS.TASK_STEP_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_STEPS_ATTACHMENT.TASK_STEP_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK_STEPS_ATTACHMENT.ATTACHMENT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>ATTACHMENT_ALIAS.ATTACHMENT_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_UNIT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_EVENT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.REQUEST_ID</left_operand>
<operator>left_outer</operator>
<right_operand>SHIPMENT.REQUEST_ID</right_operand>
</constraint>
<constraint>
<left_operand>SHIPMENT.SHIPMENT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>RECEIVING.SHIPMENT_ID</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>left_outer</operator>
<right_operand>RECEIVING_UNIT.RECEIVING_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_CONTACT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TASK_ATTACHMENT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK_ATTACHMENT.ATTACHMENT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>ATTACHMENT.ATTACHMENT_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TIME_CLOCK_EVENT.FOREIGN_KEY_NUM1</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>ESCALATION.FOREIGN_KEY_NUM1</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST_UNIT.CONTRACT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>CONTRACT.CONTRACT_ID</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST_UNIT.REQUEST_UNIT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>QUALITY.REQUEST_UNIT_ID</right_operand>
</constraint>
<constraint>
<left_operand>CONTRACT.CONTR_TYPE</left_operand>
<operator>left_outer</operator>
<right_operand>CONTR_TYPE.CONTR_TYPE</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST_UNIT.WTY_COV_ID</left_operand>
<operator>left_outer</operator>
<right_operand>WARRANTY_COVERAGE.WTY_COV_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>TIME_COMMIT.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>equi</operator>
<right_operand>TASK_ASSIGNMENT_VIEW.TASK_ID</right_operand>
</constraint>
<constraint>
<left_operand>REQUEST.REQUEST_ID</left_operand>
<operator>left_outer</operator>
<right_operand>REQUEST_TEXT.REQUEST_ID</right_operand>
</constraint>
<constraint>
<left_operand>TASK.TASK_ID</left_operand>
<operator>left_outer</operator>
<right_operand>C_CARDPHONECOMPLETIONINFO.TASK_ID</right_operand>
</constraint>
</join_constraint>
</where>
</hierarchy_select>
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.