Anyone got experience with a Map/Reduce based on SuiteQL? I'm running into a

Invariant check for stage 'INPUT' check failed for 'SELECT [5x] FROM [1x] GROUP BY [1x]

error. The query in itself is running fine (slow nevertheless). I've used the help way to return the suiteql in the input stage, just a different query.

Why are you trying to put the table name in quotes? If making a new script, use 2.1, and use string literals. It is much easier to read than concatenated strings

// Construct the SuiteQL query string
        var suiteQL =
            `SELECT
                TRANSACTION.tranid AS tranidRAW,
                TRANSACTION.trandate AS trandateRAW,
                BUILTIN.DF(TRANSACTION.postingperiod) AS postingperiodDISPLAY
            FROM
                TRANSACTION
            WHERE TRANSACTION.ID = ?`;

for example

This is a copy from the Suitescript help documentation, not my actual query.

I've never encountered that error but it seems to not like whatever grouping in your suiteQL (not very helpful)

Hmm, snippet failed. But funny thing is, I don't even have a grouping

don’t put quotes or ${} stuff in SuiteQL

I could try to see if it's working then, although I need to create a dynamic SQL based on custom records data

this looks like some strange mashup of freemarker syntax and regular SQL

It's working fine in other scripts btw

ok, maybe I’m just not familiar with that

${variablename}

syntax outside of freemarker

It is working, I logged it and ran it multiple times in Tim's tool. And the actual code is in a library used in other scripts where the same part is working as it should so it feels like a Map/Reduce quirck

Could be

Do you also return the query in itself or gather the results and use that in the return of the input?

the latter

I've used that as well and that is indeed working. Problem though is that I have more than 5k results and paging didn't work that well but I guess it's the only way due to return the query in itself doesn't seem to work

I wrote myself a wrapper module for SuiteQL so I can get more than 5k results 😉

Without promises I guess? Trying to use promises let to

Search error occurred: Invalid or unsupported search

so that seemed like a no-go as well. Back to the non-promises, cheers