[Openinteract-help] Using SPOPS across multiple tables

[Peter D. <pet...@us...>]

I've been trying to use SPOPS to retrieve fields from multiple tables, could
you advise me on the best way to do this ?

It works fine for searching but I had difficuly getting fields from a
secondary table, because they were not part of the primary SPOPS object. One
way round it was to use the field alter in the SPOPS configuration file to
assign the value to a new field, e.g when searching on a task but needing a
related contact name.
    'field_alter' => {
      'tk_contact_name'       => 'contact.cn_name',

This worked alright on fetch but I couldn't get at contact name and SPOPS
failed on the update even though I didn't want to update the secondary
table.

Thanks,
Peter
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003