4 Replies Latest reply: Sep 17, 2013 11:00 AM by User9976634-Oracle RSS

    Field Overflow

    946699

      Hello,

       

      I have a requirement to display the list of Beneficiaries in a paragraph on Print  (eg.,  You have these list of beneficiaries Beneficiary1, Beneficiary2, Beneficiary3 for your policy.) Number of beneficiaries vary depends on the Policy.

       

      I am familiar with table overflow but not the list. Could you please throw some light how can we achieve this in Documaker Studio?

       

      Thanks,

      Siva

        • 1. Re: Field Overflow
          Sruthi

          Hi Siva,

          Can you please give some more information about the requirement (input structure/expected output) so that somebody can help you with it.. You should be able to code the similar way as you do with table; depending on the input.

           

          Thank you,

          Sruthi Jayasimhan

          • 2. Re: Field Overflow
            User9976634-Oracle

            I'm not sure what "list" you might be thinking about. Later versions of Documaker - (perhaps 11.5 or later?) have a Table object that you can insert on your forms. The table row can have a trigger that will repeat the row based upon the count. See if you can locate the Table object within the Help - probably under the category of Content+Sections.

            • 3. Re: Field Overflow
              946699

              Thank you all for inputs. Here is the XML snippet of my input feed and the expected output.

               

              Input:

              <Beneficiary id="Beneficiary1">

                                    <BeneName>CHARLES</BeneName>

                                    <BeneAddressLine1>12345 LANE 1 </BeneAddressLine1>

                                    <BeneAddressLine2>-</BeneAddressLine2>

                                    <BeneState>NY</BeneState>

                                   <BeneZipCode>12345</BeneZipCode>   

              <Beneficiary>

              <Beneficiary id="Beneficiary2">

                                    <BeneName>TOM</BeneName>

                                    <BeneAddressLine1>45678 LANE 2</BeneAddressLine1>

                                    <BeneAddressLine2>-</BeneAddressLine2>

                                    <BeneState>NJ</BeneState>

                                   <BeneZipCode>12345</BeneZipCode>   

              <Beneficiary>

                           

              Expected Output:

               

              You have these list of beneficiaries "CHARLES, TOM" for your contract.


              Number of beneficiaries vary depends on the policy. So I wanted to use overflow to retrieve the beneficiary details. I am successful in displaying the beneficiary details in the below format using overflow logic at section level.

              CHARLES

              TOM


              But I am expecting the output as below:

              CHARLES, TOM


              Let us know if you have any questions.


              Thanks,

              Siva


               

                           

              • 4. Re: Field Overflow
                User9976634-Oracle

                Okay, I would not call that field overflow, but I see what you are trying to do. There is probably a limitation of approximately 1024 characters, but I think you would use a script that looks something like this:

                 

                %lt = XMLFind(%extract, ,"//Beneficiary/BeneName")

                if (XMLFirst(%lt))

                    x = XMLGETCURTEXT(%lt)

                    while(XMLNext(%lt))

                    y = XMLGETCURTEXT(%lt)

                     x = x & ', ' & y

                    wend

                end

                return(x);

                A given field or value that can be returned from DAL would be limited, so if you assumed 32 character names with a comma and space between each one, I think that means you could get up to 30 names in a field.