Solved

MWO survey answer set logic

  • 13 April 2022
  • 9 replies
  • 172 views

Userlevel 5
Badge +12

Hi all.

Could someone help me to understand the answer_set logic?

I have a MWO survey that has been answered 4 times in the same day by the same employee.

But the answer set has repeated 2 times.

If this logical is correct, How could I group a snwer set in this situation?

I thought the logic was 1,2,3,4

 

At the end of the day, I need to create a quickreport setting a parameter with one of the answers like the example bellow.

I’m using this way in the select to do this but considering the answer set.

min(v2.item_description) over (partition by c.emp_no,  trunc(c.DATE_CREATED), c.answer_set ) as car

Tks a lot for help

icon

Best answer by lopespetro 19 July 2022, 15:40

View original

9 replies

Userlevel 5
Badge +12

Hi @lopespetro We use answer set to group answers when same survey is being answered by multiple times. It appeared a bug here. Please report a issue with a clear test plan.

 

Cheers,

Bandula

Userlevel 5
Badge +12

Hi @lopespetro We use answer set to group answers when same survey is being answered by multiple times. It appeared a bug here. Please report a issue with a clear test plan.

 

Cheers,

Bandula

Hi @Bandula , Tks for the info 

Case created.

G2326577

Tks for attention.

Userlevel 5
Badge +12

Hi @lopespetro 

Please add below info to the case to recreate the problem by support team.

  • App Name (if Native Apps are using to answer)
  • Client version 
  • Set up Survey type (eg. Task, Employee, ??)
  • Did you set ‘start always new’ flag ?

Thanks

 

 

Userlevel 5
Badge +12

Hi @lopespetro 

Please add below info to the case to recreate the problem by support team.

  • App Name (if Native Apps are using to answer)
  • Client version 
  • Set up Survey type (eg. Task, Employee, ??)
  • Did you set ‘start always new’ flag ?

Thanks

 

 

Hi @Bandula , sorry, forgot about that.

Already included them.

Tks

 

Badge

Thanks for sharing, I found a lot of interesting information here. A really good post, very thankful and helpful that you will write many more posts like this one.

Userlevel 5
Badge +12

Hi All and @Bandula . Rnd has released this BUG and seens OK now.

Just to clarify, from now on, all the answers are grouped in answer set with a different ID if the same user answer the same eform the same day and the date/time are the same for all of the lines sync as IT was before in the old mWorkOrder app?

Tks a lot

 

Userlevel 5
Badge +12

With this fix, when answering it get new answer set Id to avoid duplicate Answer sets. if you need further clarification please check with GSO via LCS case. 

Userlevel 5
Badge +12

With this fix, when answering it get new answer set Id to avoid duplicate Answer sets. if you need further clarification please check with GSO via LCS case. 

Great. Thanks a lot @Bandula!

I notice the the date/time created can be different, but the answer set is OK now.

Br.

Lopes

Userlevel 5
Badge +12

Hi All, follow the fix:

Bug ID          163937          Bug Title               MWO Aurena Native – Survey Answer Set Duplicates for Employee Surveys

 

Reply