Alan Fitch
11/17/2021, 10:26 PMburkybang
11/18/2021, 4:11 AMAnna
11/18/2021, 11:40 AMCustomer Payments
data. Any clue of where I can find it?? I checked Transactions and not succesfull...NS
11/18/2021, 2:14 PMZach Rumancik
11/18/2021, 5:32 PMsearch.createColumn({ name: "installmentnumber",join: "installment",})
Diogo
11/19/2021, 3:16 AMJosh Godfrey
11/19/2021, 9:49 PMTO_DATE('11/19/2021 16:01:00','MM/DD/YYYY HH24:MI:SS')
I get no results.
{
"q": "SELECT * type FROM DeletedRecord where recordtypeid = 'customrecord_plx_role' and deleteddate >= TO_DATE('11/19/2021 16:01:00','MM/DD/YYYY HH24:MI:SS')"
}
However, when I pass in TO_DATE('11/19/2021 13:01:00','MM/DD/YYYY HH24:MI:SS')
it finds the deleted record.
Query:
{
"q": "SELECT * type FROM DeletedRecord where recordtypeid = 'customrecord_plx_role' and deleteddate >= TO_DATE('11/19/2021 13:01:00','MM/DD/YYYY HH24:MI:SS')"
}
Response:
"count": 1,
"hasMore": false,
"items": [
{
"links": [],
"context": "UIF",
"deletedby": "493811",
"deleteddate": "11/19/2021",
"iscustomlist": "F",
"iscustomrecord": "T",
"iscustomtransaction": "F",
"name": "Sukhdev Test ",
"recordid": "106",
"recordtypeid": "customrecord_plx_role",
"scriptid": "customrecord_plx_role",
"type": "CUSTOMRECORD"
}
],
"offset": 0,
"totalResults": 1
}
Mister Miyagi
11/22/2021, 1:12 PMWatz
11/23/2021, 11:04 AMDiogo
11/25/2021, 10:05 AMGareth
11/25/2021, 8:02 PMIsis Herrero
11/26/2021, 10:55 AMMattias Uppström
11/27/2021, 10:42 PMAlan Fitch
11/28/2021, 6:33 AMN/render
module.
I see that it has to be a query object. Is there a way for me to easily translate suiteql into a query object?
Second is there necessarily a one to one mapping between suiteql and a query?Gareth
11/28/2021, 7:02 PMAlan Fitch
11/28/2021, 7:35 PMIN
clause. I'm not sure about where you can find a list though.Gareth
11/28/2021, 9:56 PMIsis Herrero
11/29/2021, 7:51 AMAzi
11/29/2021, 6:35 PM.asMappedResults
, can I get the type of the record like by N/search
for record loading purposes afterwards?Zach Rumancik
12/01/2021, 6:52 PM<machine name="installment" type="edit" fields="seqnum,duedate,amount,amountdue,status,id,paymentsapplied">
<line>
<amount>480.81</amount>
Matt Bernstein
12/02/2021, 6:30 PMReason: UNSUITABLE - Unsupported data type 'TIMEOFDAY'
Mister Miyagi
12/06/2021, 2:00 PMredfishdev
12/07/2021, 5:36 AMredfishdev
12/07/2021, 1:42 PMredfishdev
12/08/2021, 2:58 AMIsis Herrero
12/08/2021, 8:50 AMAlan Fitch
12/09/2021, 8:54 PMDivyansh Sultania
12/14/2021, 11:00 AMlet allocationScheduleQueryResults = query.runSuiteQL({
`query: select id, name as text from generalallocationschedule
,
}).asMappedResults();`Bill S
12/14/2021, 3:07 PMCaiman
12/15/2021, 12:59 PM