Forum Post: Lookup Field returns null from rbf_selectQuery but not from rbf_getRelatedIds

  • Thread starter Thread starter awbranch
  • Start date Start date
Status
Not open for further replies.
A

awbranch

Guest
I have 2 related objects. Employee and Company. Cardinality is "Many Employees to One Company". The Company lookup field in the Employee object has the integration code "company" The relationship name is "R1234". Suppose I have the following employees with their respective company ids. Employee: "John Doe" - ID: 100 - Company ID: 200 Employee: "Sue Smith" - ID: 101 - Company ID: 201 If I run an the following 2 queries for John Doe as follows: rbf_selectQuery("SELECT company FROM employee WHERE id = 200", 1, displayCompanyId); rbf_getRelatedIds("R1234", 100, displayRelatedCompanyId); Both displayCompanyId and displayRelatedCompanyId display 200 as expected. However if run the two queries for Sue Smith then displayCompanyId shows "null" while displayRelatedCompanyId displays 201. So essentially the rbf_selectQuery and rbf_getRelatedIds are out of sync with each other. If I view Sue Smith or the company with ID 201 in the admin interface everything looks fine. You can see her related company as expected. In my case, this problem happens for any employee assigned to company 201. Is this expected behavior. Why would it be inconsistent between different employees? Release 2.1.0.3 Build Date 02/18/2014

Continue reading...
 
Status
Not open for further replies.
Back
Top