Question

Custom tables' fields are not shown in Mobile Client

  • 15 April 2022
  • 4 replies
  • 137 views
I
Rank
Userlevel 2
Badge +5

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?

4 replies

H
Rank
Userlevel 5
Badge +13

Hi @ioannamourtzaki,

 

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

 

J
Rank
Userlevel 1
Badge +6

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.

 

I
Rank
Userlevel 2
Badge +5

K

I
Rank
Userlevel 2
Badge +5

Hello all, thanks for the answers!

@Hasara Dinu, we added the custom table to the “Task” sync rules (in the Related Query) but we still cannot see the custom fields in the mobile. 

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>

Reply


Terms & ConditionsCookie settings