@Lee Pinchbeck Hi, Thanks for your good ideas!My parameter is not from an input field but the result of a calcul with a division. Best regards. Renaud
Hi Lee,Unfortunatly, it’s not working.In the expression column, I wrote : “ROUND(TASK.USER_DEF_NUM1/8)”A warning message indicated : The expression ‘ROUND(TASK.USER_DEF_NUM1/8)’ contains unexpected syntax. The exprexpression contains more operands than operators. Do you have any idea? Best regards. Renaud
Salut !J'ai essayé d'utiliser cette fonction mais cela ne fonctionne pas. C'est encore bleu !Avez-vous une idée?Merci
@Roel van Zwieten Which parameters? In color settings i try with the keyword “Red” and after the hexacode color (#D84256).and i used for the VALUE parameter the Code Value in the task_type table.Is there another parameters? in AppParam for example? or a limitation in colors choice (with official list...)?
Hello,Sorry for my late feed back but I let down the case.And finally, it works after reinstall the server… Something magical !There’s only one case that’s not work it’s with the value =”REPAIR”. Thanks for your help.
Thanks for you answer. I refresh the cache and close FSM sessions. But it doesn’t work. I always have the same message.
@Saranga Amaraweera @Rwjgoedhart @Shneor Hi,Thanks for your reactivity !But sadly, it’s not working… I have the same message.I can consult my view with the SQL Query (ex :select top(100) * from ac_task_duration_view).What i did and complete with your messages:1 - I create my view in SQL Server management2 - I add it in Custom Metadata with all column3 - I add the relationship with task in Custom Metadata:4 - In Ui designer, I create the relationship in the “Child Relation Editor” (and I can access of columns in the “Add screen fileds” 5 - I refresh the cash and restart the IIS. Is it right?Renaud
@Saranga Amaraweera thanks!@Shneor this is my script:CREATE VIEW AC_TASK_DURATION_VIEW ASSELECT TASK_ID,(SCHED_TASK_DUR_MIN/60) AS DUREE_HEURE_J,(SCHED_TASK_DUR_MIN/60)+ FLOOR((SCHED_TASK_DUR_MIN/60)/8)*16 AS DUREE_HEURE_JNFROM TASK The message has changed ! The erros is from here?
It’s working ! Thanks!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.