Finance | Project Operations, Human Resources, ...

Facing Issue

(1) Share

Report

Posted on by Community member

PaymMethod
Name	PaymMode
Cash	CASH
Cheque	CHEQUE
Online	ONLINE
Post Dated Cheque	PDC

I want to fetch data from PaymMethod table
Then I want to count PaymMode from PaymMethod and store into a variable named as “int

Size”}

Then I want to add PaymMethod into list
I want to query data from retailtransactiontable, retailTransactionSalesTrans and retailTransactionPaymentTrans based on 1^st element of list.
When second time query run it will fetch from retailtransactiontable, retailTransactionSalesTrans and retailTransactionPaymentTrans based on 2^nd element of list and so on.

Class final test
{
               Int Size;
               List MyList = new List (Types::string);
               Size= select count(PaymMode) from PaymMethod.
Int array[size];
For(1=0, i<size, i++)
               Select paymMode from PaymMethod
               MyList.addend(PaymMode, PaymMode)

Finaly I want to run this query to fetch the data on base of payment method from retail transaction sales trans.
Select * from retailtransactionsalestrans where Paymentmethod == conpeek(MyList ,1)
When 2^nd query run it will fetch data from retailtransactionsalestrans where paymentmethod= conpeek(Mylist,2)

How can I achieve that

I have the same question (0)

All responses (4)

Answers (0)

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (1)

Report

Can you please provide more details and show us the actual code you wrote? -- so that we understand more?
Also what are you trying to do after you select from retailTransactionSalesTrans?

Trying to make it work based on the code you provided without changing it alot, and assuming I understood what you are tying to achieve. Then you can loop through the list, and inside it, do the "select retailTransactionSalesTrans where retailTransactionSalesTrans.Paymentmethod == listEnumerator.current()"

maybe sth like this:

ListEnumerator myListEnumerator = MyList.getEnumerator();
if(myListEnumerator)
{
while (myListEnumerator.moveNext())
{
select retailTransactionSalesTrans where retailTransactionSalesTrans.Paymentmethod == myListEnumerator.current();
}

}

Thanks,
Layan Jwei

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (1)

Report

Dear User, please use a title for your thread that describe the topic. "Facing Issue" is way too vague; that could be a title of every single thread (and this forum would become unusable, because no one would be able to locate relevant threads).

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (1)

Report

Hi,
Have you tried to write the code for the function you want to achieve? If so, you can share the code so that you can get help better.
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report

My understanding is to count the number of PaymMode from PaymMethod table which will add to a list or array. Then you need to loop through that list and for every list iteration, you need to select value from retailtransactiontable, retailTransactionSalesTrans and retailTransactionPaymentTrans.

My 1st question is if you are selecting number of PaymMode, assuming there are 3, then it gives 3. So, first element would be 1. So, you cannot get any record here with 1 as it is not a unique key in these tables to identity the buffer.

If in case you need to make a list with the records of that PaymMethod table, then you will have unique key to identity the buffer.

My 2nd question point is you I think you cannot pass a list in place of a container.

So, your code is correct but with some syntax errors like passing list instead of a container.

So, code flow would be to select records of PaymMode, creating correct List type, then looping through list and selecting value form the mentioned 3 tables.

Was this reply helpful? Yes No