is this a valid search formula?
CASE WHEN {call.co...
# suitescripta
Ali
02/07/2020, 4:22 PMis this a valid search formula?
CASE WHEN {call.completeddate} > {messages.messagedate} THEN {call.completeddate} ELSE {messages.messagedate} END
🤔 1
d
Diego Modesto
02/07/2020, 4:23 PMMay you need convert {call.completeddate} into DATE with TO_DATE()... but, Its only thing I think.
a
Ali
02/07/2020, 5:37 PM@Diego Modesto thanks
result field is a Formula (Date)
how can I add text to the formula?
Ali
02/07/2020, 5:38 PMfor example
CASE WHEN {call.completeddate} > {messages.messagedate} THEN {call.completeddate} + 'Call' ELSE {messages.messagedate} + 'Message' END
Ali
02/07/2020, 5:38 PMis that possible?
d
Diego Modesto
02/07/2020, 5:45 PMIF entry in formula is DATE (call.competeddate) (I sayd about value result in SEARCH) this type need be the same
a
Ali
02/07/2020, 5:47 PMI want to compare all the dates
Ali
02/07/2020, 5:47 PMand find the latest one
Ali
02/07/2020, 5:47 PMif the latest one is a call print call date + 'Cal'
Ali
02/07/2020, 5:47 PMif that date is for a message print message date + 'Message'
Ali
02/07/2020, 5:47 PMis that possible?
b
battk
02/07/2020, 5:58 PMgeneral warning: searches with 2 joins tend to have duplicated rows
p
PNJ
02/07/2020, 6:00 PMTo concatenate use
||concat()a
Ali
02/07/2020, 6:00 PM@battk thanks
what's the solution in this case
I want to search for the customer messages and calls and find the latest one and print the data for the latest one
Ali
02/07/2020, 6:01 PM@PNJ thanks
because field is formula(Date) I think I can't use that
there is an error
b
battk
02/07/2020, 6:02 PMIts a general warning
a
Ali
02/07/2020, 6:03 PMwhit this formula
Copy code
CASE WHEN {call.completeddate} > {messages.messagedate} THEN {call.completeddate} ELSE {messages.messagedate} ENDAli
02/07/2020, 6:03 PMbut not the rest
b
battk
02/07/2020, 6:03 PMYou might be able to get away with it if you are only interested in the latest
a
Ali
02/07/2020, 6:04 PMyes I'm only interested in the latest one
b
battk
02/07/2020, 6:04 PMYou shouldnt be using a date formula if your output column is text
a
Ali
02/07/2020, 6:04 PMthat's the issue when I want to use the text formula
Ali
02/07/2020, 6:04 PMI can't use Maximum summary to select the latest one
Ali
02/07/2020, 6:05 PMI'm using the formula + Maximum summary type + formula(date) field
to be able to show the latest communication
Ali
02/07/2020, 6:06 PMif I want to use text I can't use Maximum
b
battk
02/07/2020, 6:11 PMYou probably want to use the max function instead
battk
02/07/2020, 6:11 PMbattk
02/07/2020, 6:11 PMsummary types are for displaying data
battk
02/07/2020, 6:13 PMDont use summary types for logic
a
Ali
02/07/2020, 6:15 PMsomething like this
Copy code
CASE WHEN MAX({call.completeddate}) > MAX({messagesto.messagedate}) THEN MAX({call.completeddate}) ELSE MAX({messagesto.messagedate}) ENDAli
02/07/2020, 6:15 PM?
Ali
02/07/2020, 6:17 PMit doesn't work with Formula(text) field
b
battk
02/07/2020, 6:30 PMyou would want to use the analytic form
a
Ali
02/07/2020, 6:32 PManalytic form?
b
battk
02/07/2020, 6:35 PMlook at the Analytic Example from the docs
a
Ali
02/07/2020, 6:36 PMI was trying to find out the example in the doc but, I can't see that
Ali
02/07/2020, 6:38 PMalso at the end, I want to export that and use in code. can we do that with analytic form too?
b
battk
02/07/2020, 6:44 PM2 Views