TASK3 IN 5.MODULE - JUNIOR DEVELOPER EXAM

For students who study 1C Junior course.

#1
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Mr. Rupasov, I have completed Task3 ın 5.module as true,but system says that it is not completed.Can you see that please?

Also,5.Module nearly will finish.Can you control the module and can you say the wrong things me please.

Edited: Mesut Kahraman - Oct 08, 2020 06:14 PM
 
#2
People who like this:0Yes/0No
Active user
1C:Professional
Rating: 6
Joined: May 8, 2013
Company: 1C Company

Hi Mesut,

This is what happened with this task. Here is the original Sales dynamic list query:

Code
SELECT
   Sales.Number AS Number,
   Sales.Date AS Date,
   Sales.AmountPaid AS AmountPaid,
   Sales.PaymentMethod AS PaymentMethod
FROM
   Document.Sales AS Sales


You added a parameter in there, and this is what you got:

Code
SELECT
   Sales.Date AS Date,
   Sales.Number AS Number,   
   Sales.AmountPaid AS AmountPaid,
   Sales.PaymentMethod AS PaymentMethod
FROM
   Document.Sales AS Sales
WHERE
   AmountPaid >= &Parameter
ORDER BY
   AmountPaid DESC


The problem is that in your query Date and Number fields are swapped. Our auto-check algorithm is sensitive to the fields order, so it sees it as a different query. Please, restore the original order of this two fields (Number goes first, Date goes second) and everything should work.

We'll think of making the auto-check algorithm order-insensitive in the future.

Thank you,
Konstantin

Edited: Konstantin Rupasov - Oct 09, 2020 12:21 AM
 
#3
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Thank you very much!

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.