Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • 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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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