Double relation in Servoy Mobile (create)
Posted: Tue Mar 05, 2013 11:02 am
Hello,
We are currently developping a Mobile application for Sage CRM thanks to Servoy Mobile. I have a question about how to retrieve a field value thanks to a double relation on a Mobile form (in the ws_create).
I give you an example.
In Sage CRM, this is the way to retrieve the telephone number of a Contact (table Person):
Person
pers_personid
(…)
Phone_Link
plink_phonelinkid
#plink_recordid (here equivalent to pers_personid)
#plink_entityid (always equivalent to the value '13' pour the entity Person)
(…)
Phone
phon_phoneid
#phon_phonelinkid
phon_number (the field that we want retrieve)
(…)
So we made 2 relations to retrieve the telephone number of a Contact:
and
With the "data" object in parameter, we are able to read the info (ws_read), as well as update (ws_update) but we are unable to retrieve the value of the phone number in the ws_create. Do you have an idea of how to get it?
Thank you very much in advance.
Vincent
We are currently developping a Mobile application for Sage CRM thanks to Servoy Mobile. I have a question about how to retrieve a field value thanks to a double relation on a Mobile form (in the ws_create).
I give you an example.
In Sage CRM, this is the way to retrieve the telephone number of a Contact (table Person):
Person
pers_personid
(…)
Phone_Link
plink_phonelinkid
#plink_recordid (here equivalent to pers_personid)
#plink_entityid (always equivalent to the value '13' pour the entity Person)
(…)
Phone
phon_phoneid
#phon_phonelinkid
phon_number (the field that we want retrieve)
(…)
So we made 2 relations to retrieve the telephone number of a Contact:
and
With the "data" object in parameter, we are able to read the info (ws_read), as well as update (ws_update) but we are unable to retrieve the value of the phone number in the ws_create. Do you have an idea of how to get it?
Thank you very much in advance.
Vincent