alanr's blog

Is there any way to do a mass update of data in iMIS?

Hi,

  I need if possible to do a mass update of all the email address for each of the employees of a company which is one of our contacts in iMIS. Given the ID of the company, I could easily get a list of the IDs of it's employees, but is there any way using the iMIS front end to do a mass update of the email addresses, which are fields of a Business Object? For example, does anyone know if this could be done by an IQA or by a Report of some kind?

Is there any way to match to a value in an IQA LEFT JOIN sources clause?

Hi,

I have two NetContact Business Objects, holding firms and employees, linked via a CsRelationship Business Object. I want to first collect all the firm records in  which have the relation type 'CR_PARTN', and I particularly want to keep track of firms that DO NOT have a relation of type 'CR_PARTN' (for them, the CsRelationship.Relation field will be NULL). I then want to link all of these firm records on the left-hand side to the employees in the second NetContact, matched by CsRelation. I should hopefully end up with a collection of firms linked by the relation CR_PARTN to employees and some firms with NULL relations, meaning that they do not have any CR_PARTN relationship with any employee.

Syndicate content