[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

help formatting the array / data

I have the following jquery code
$(document).ready(function () {
	var BankRows = "";
        var prefRows = "";
        var detailBankInfo;
        var BankactionInfo = {
            'entityCount' : {^SFT:PAC:BankList_Count^},
            'actualEntityId' : {^SFT:TRN:Bank ID^},	 
            'actualAppId' : {^SFT:APL:Applicant ID^}, 
            'actualType' : "{^SFT:TRN:Bankaction Sub Type^}", 
            'entityList' : []									 
			
        };
        if (BankactionInfo.entityCount == 0) { BankactionInfo.entityCount = 1; }

        if ({^SFT:PAC:ProductID|TRN:ProductPackage:blankreplace(0)^} > 0)
        {
	        {^DRP:PAC:BankList_Count|TRN:ProductPackage()
		   
			   detailBankInfo = {
                    'id' : "{^UDT:BankCode^}",
                    'entityCode' : 'TRN',
                    'type' : "{^CFT:TRN:CreditPayroll^}",
                    'BankType': "{^UDT:BankSubType^}"
                };
				 BankactionInfo.entityList.push(detailBankInfo);
            /DRP:PAC:BankList_Count^}
        };
	
        BankRows = createBankListing(BankactionInfo);
        $('#BankListing').append(BankRows);
    });

Open in new window


that generates the following array/data
transInfo =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               };
            
        transInfo =  {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       
          transInfo =  {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                };
           
           transInfo =  {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                };
            
            transInfo =  {
                    
                    'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window


the first section of code retrieves the results from the db and loops through the reults and spits each record/data set out as a separate array.

My question is ... what do i need to change in the jquery section to output the data as follows?

transInfo =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               }, {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"
                }, {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                }, {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                }, {
                   'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window


Thanks
0
nriddock
Asked:
nriddock
  • 4
  • 3
1 Solution
 
Michel PlungjanIT ExpertCommented:
You first script does not match the output. I do not see a loop and I see no transinfo anywhere
Also you likely want
Transinfo = [
   {
    },
    {
     }
];
0
 
nriddockAuthor Commented:
Sorry for the mixup. Heres the updated code

$(document).ready(function () {
	var BankRows = "";
        var prefRows = "";
        var detailTransInfo;
        var transactionInfo = {
            'entityCount' : {^SFT:PAC:BankList_Count^},
            'actualEntityId' : {^SFT:TRN:Bank ID^},	 
            'actualAppId' : {^SFT:APL:Applicant ID^}, 
            'actualType' : "{^SFT:TRN:Bankaction Sub Type^}", 
            'entityList' : []									 
			
        };
        if (transactionInfo.entityCount == 0) { transactionInfo.entityCount = 1; }

        if ({^SFT:PAC:ProductID|TRN:ProductPackage:blankreplace(0)^} > 0)
        {
	        {^DRP:PAC:BankList_Count|TRN:ProductPackage()
		   
	detailTransInfo = {
                    'id' : "{^UDT:BankCode^}",
                    'entityCode' : 'TRN',
                    'type' : "{^CFT:TRN:CreditPayroll^}",
                    'BankType': "{^UDT:BankSubType^}"
                };
				 transactionInfo.entityList.push(detailTransInfo);
            /DRP:PAC:TransList_Count^}
        };
	
        BankRows = createBankListing(transactionInfo);
        $('#BankListing').append(BankRows);
    });

Open in new window


This is the output it produces
detailTransInfo  =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               };
            
        detailTransInfo =  {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       
          detailTransInfo  =  {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                };
           
           detailTransInfo =  {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                };
            
            detailTransInfo =  {
                    
                    'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window


This is how i need the output
detailTransInfo =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               }, {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"
                }, {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                }, {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                }, {
                   'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window

0
 
Michel PlungjanIT ExpertCommented:
I do not understand what code this is. What's with the ^ ??

Assuming it is some kind of template scripting language I guess

THIS:               {^DRP:PAC:BankList_Count|TRN:ProductPackage()

is a loop

so something like


if ({^SFT:PAC:ProductID|TRN:ProductPackage:blankreplace(0)^} > 0)
        {
              {^DRP:PAC:BankList_Count|TRN:ProductPackage()
               
                  var x = {
                    'id' : "{^UDT:BankCode^}",
                    'entityCode' : 'TRN',
                    'type' : "{^CFT:TRN:CreditPayroll^}",
                    'BankType': "{^UDT:BankSubType^}"
                };
                         transactionInfo.entityList.push(x);
            /DRP:PAC:TransList_Count^}
        };
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
nriddockAuthor Commented:
the ^ symbol signifies the code directly following is a "token" - internal code the vendor uses as a form of placeholder / variable., etc.

Ill give it a try. Thanks for all your help!
0
 
nriddockAuthor Commented:
its yielding the same results

its still writing
detailTransInfo  =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               };
            
        detailTransInfo =  {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       

Open in new window

i need it to merge or combine the multiple "detailTransInfo" sections into one big "detailTransInfo"
detailTransInfo  =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               }; {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       

Open in new window

0
 
Michel PlungjanIT ExpertCommented:
I am sorry. Since I do not know the nature of the code you post, I cannot help  you.
Please let us know what framework you are using
0
 
nriddockAuthor Commented:
i figured out a different method
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now