Question for the group, my item has a custom list ...
# suiteqli
Israel
12/01/2020, 5:03 PMQuestion for the group, my item has a custom list property, using SuiteQL I can query it, but only get the actual ID value, I want to match/map to get the Name of the assigned value, but I'm unable to query the custom list table or join it. Am I missing something? [Edit solved: more access rights shennanigans]
t
tdietrich
12/01/2020, 5:08 PM@Israel The table that the custom list is stored in should be named something like "customlist_listid." Are you able to query that?
i
Israel
12/01/2020, 5:13 PMi tried a few things, the ID as defined in the custom list ... "customlist_XXXX_list" and the name used in the workbook "custitem_XXXX" when debugging via chrome network debug
Israel
12/01/2020, 5:13 PMall of indicate that the table/record is not accessible
Israel
12/01/2020, 5:14 PMaka "Invalid search type" from select * from customlist_XXX and custitem_xxxx
t
tdietrich
12/01/2020, 5:15 PMDo you see it in the Records Catalog ( via Setup > Records Catalog )?
i
Israel
12/01/2020, 5:17 PMyep, but i might have to swtich to my app's role to see what the issue is.. since i login as admin normally, i'll probably do that now
Israel
12/01/2020, 5:29 PMYep, I was missing the "Custom List" right under Setup for my Role