Project

General

Profile

Bug #1686

Calculate tag_Case on Desktop Side

Added by Maurício Dos Santos over 9 years ago. Updated over 9 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
-
Target version:
-
Start date:
12/02/2015
Due date:
% Done:

0%

Component:

Description

Today the tags<>case relationship are imported on the initialization of the unit, but it is better to calculate it at the end of the importing. Also, it needs to calculate the tags every time a case is modified (including its exams, treatment...)

History

#1 Updated by Maurício Dos Santos over 9 years ago

  • Priority changed from High to Normal

#2 Updated by Maurício Dos Santos over 9 years ago

Increase the window width.

#3 Updated by Maurício Dos Santos over 9 years ago

Maurício Dos Santos wrote:

Increase the window width.

ignore this comment.

#4 Updated by Maurício Dos Santos over 9 years ago

  • Priority changed from Normal to High

#5 Updated by Maurício Dos Santos over 9 years ago

  • Priority changed from High to Immediate

#6 Updated by Maurício Dos Santos over 9 years ago

  • Status changed from New to Feedback

Problem:

Tags SQL are written in MySQL and Desktop uses HSQLDB so some tags cannot be calculated on desktop, like tags that uses MySql functions.

#7 Updated by Maurício Dos Santos over 9 years ago

As a palliative solution I decided to update tags when synchronizing, receiving from server the link between tags and cases. Check with Ricardo if this is the better way.

#8 Updated by Maurício Dos Santos over 9 years ago

  • Status changed from Feedback to In Progress

#9 Updated by Maurício Dos Santos over 9 years ago

Tentei implementar essa solução me baseando no lasttransactionid do caso, para isso, sempre que as tags de um caso forem atuqalizadas o lasttransactionid do caso deve ser atualizado.

Porem isso faz com que, por exemplo, ao editar ou criar uma tag todos os casos ligados a esta tag tenham seu lasttransactionid atualizado fazendo com que sejam todos enviados ao desktop na proxima sincronização..

Considerando que um caso tem 54 linhas dentro do xml, preferi em todas as sync atualizar TODOS os links entre casos e tags, considerando que as unidades que vão usar o desktop não vão possuir muitos casos... Cada link entre caso e tag ocupa apenas uma linha.

#10 Updated by Maurício Dos Santos over 9 years ago

  • Status changed from In Progress to Feedback

Done, check Ricardo's opinion.

#11 Updated by Maurício Dos Santos over 9 years ago

  • Status changed from Feedback to Resolved

Also available in: Atom PDF