Hi
Any one know how to get and filter item table c...
# suitetalkapir
Rishikesh
09/02/2020, 4:32 PMHi
Any one know how to get and filter item table custom fields with type as multiple select using suiteQL in Rest suitetalk
b
battk
09/02/2020, 5:15 PMi dont think that getting multiple select fields is any different than any other fields
battk
09/02/2020, 5:15 PMthat said, like with any beta product, you probably want to be doing it on the latest version of netsuite, 2020.2
battk
09/02/2020, 5:17 PMfor filtering, you probably want to build your filter in the suiteanalytics ui and then export it to sql, the function used is custom
r
Rishikesh
09/03/2020, 3:58 AMThanks
It is working for other field
but when i try to get multiple select field it gives
{
"type": "https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",
"title": "An unexpected error occurred. Error ID: kema454c1bvfkwyrm4aw6",
"status": 500,
"o:errorCode": "UNEXPECTED_ERROR"
}
b
battk
09/03/2020, 1:21 PMthats an error for netsuite support
r
Rishikesh
09/03/2020, 2:02 PMSo how can i solved it any idea
b
battk
09/03/2020, 2:03 PMUnexpected errors are for netsuite support to solve
battk
09/03/2020, 2:04 PMThere is unlikely to be much else you can do other than trying on an account on 2020.2
battk
09/03/2020, 2:04 PMWhich is again an action with support
r
Rishikesh
09/03/2020, 2:05 PMThanks I will try 🙂
4 Views