Dynamics Connector 12.11

# Merge Document Fields

This script demonstrates how to merge the values of document fields.

When you extract data from a repository, the connector can produce documents that have multiple values for a single field, for example:

    #DREFIELD ATTACHMENT="attachment.txt"
    #DREFIELD ATTACHMENT="image.jpg"
    #DREFIELD ATTACHMENT="document.pdf"

This script shows how to merge the values of these fields, so that the values are contained in a single field, for example:

    #DREFIELD ATTACHMENTS="attachment.txt, image.jpg, document.pdf"

## Example Script

    function handler(config, document, params)
    	onefield(document,"ATTACHMENT","ATTACHMENTS")
    	return true;
    end

    function onefield(document,existingfield,newfield)
    	if document:hasField(existingfield) then
    		local values = { document:getFieldValues(existingfield) }

    		local newfieldvalue=""
    		for i,v in ipairs(values) do
    		    if i>1 then
    		        newfieldvalue = newfieldvalue ..", "
    		    end

    		    newfieldvalue = newfieldvalue..v
    		end

    		document:addField(newfield,newfieldvalue)
    	end

    	return true;
    end

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.11 | Last updated February 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Dynamics Connector 12.11

Topic Title: Merge Document Fields