TASK5 IN 5.MODULE-JOINS

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

In task5,My report is same the control report,but system says it is not completed.Why?

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

Hi Mesut,

There are two error in the first query (Cashiers + shifts worked). First of all, you should use the WorkingShifts document, not the ShiftSchedule register. It wasn't clearly said in the task description, so I fixed this.

Secondly, you needed to exclude cashiers without any shifts worked from the output using the JOIN clause. I added a new Cashier that has no WorkingShifts and now your output and the control output are different. If you're not sure how to filter the query output with JOIN, please, watch this episode.

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

I have write a query but not true.Can you look this?

 
#4
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Dec 2, 2018
Company: 1C Innovation VietNam

In your first query, you should use the Cashiers catalog to join with the WorkingShifts document (not the ShiftSchedule register) and get Cashier from the catalog. Moreover, you need to exclude cashiers without any shifts worked, so it should be document.WorkingShifts Left join catalog.Cashiers.
The same for the second query (catalog.Cashiers and catalog.Agreements).

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

The problem was solved.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.