Is there a suiteql table that maps files attached ...
# suiteqls
Shawn Talbert
05/04/2022, 6:58 PMIs there a suiteql table that maps files attached to records?
b
burkybang
05/04/2022, 7:26 PMUse the Records Catalog. Find the record type you want. Then look under the Joins tab, and find Files.
s
Shawn Talbert
05/04/2022, 7:28 PMtried that before bothering to post the question, came up empty
b
burkybang
05/04/2022, 7:28 PMWhich record type?
s
Shawn Talbert
05/04/2022, 7:28 PMI'm looking for files attached to transactions
b
burkybang
05/04/2022, 7:31 PMAh, transactions. I usually just use a saved search for those. 🤷♂️
s
Shawn Talbert
05/04/2022, 7:33 PMaye, I guess I'm trying to figure out how to do the same as the native "File" join in saved searches instead in SuiteQL
b
burkybang
05/04/2022, 7:33 PMDid you mean to say SuiteQL instead of saved searches?
s
Shawn Talbert
05/04/2022, 7:33 PMexactly
Shawn Talbert
05/04/2022, 7:34 PMI'm guessing [hoping] there is some mapping table that just doesn't appear in an obvious place in the records catalog...
b
burkybang
05/04/2022, 7:34 PMYeah true. Sometimes that does happen. The world may never know.
burkybang
05/04/2022, 7:35 PMI'll be interested to know if you ever find it.
s
Shawn Talbert
05/04/2022, 7:35 PMI'm hoping some guru will stumble upon this thread and enlighten our world
j
jen
05/04/2022, 7:49 PMThe sidebar navigation in the Records Catalog is incomplete
jen
05/04/2022, 7:50 PMFYI
jen
05/04/2022, 7:50 PMfor example there is no entry for TransactionLine other than revRecEventTranLine
jen
05/04/2022, 7:50 PMbut if you manipulate URL you can find the normal transactionline entry
s
Shawn Talbert
05/04/2022, 7:50 PMright, I've noticed a few places where tables referenced in the details don't have an entry in the master list
j
jen
05/04/2022, 8:14 PMI think it’s often when the record name is the same but the table name differs
jen
05/04/2022, 8:14 PMsorta the opposite of the shitshow that is the Analytics Browser
jen
05/04/2022, 8:14 PMmessage has been deleted
💯 1
s
Shawn Talbert
05/04/2022, 8:15 PMI can't find anything on attachments in either place
j
jen
05/04/2022, 8:15 PMyo dawg I heard you liked accounting books
jen
05/04/2022, 8:25 PMI’m not much help unfortunately, we use Box for documents attached to transactions.
s
S Feld
05/04/2022, 8:27 PM@Shawn Talbert I've wasted so much time looking for this (the amount of work arounds I'll be removing once you find it .... )
😧 1
j
jen
05/04/2022, 9:00 PMthis is seriously bugging me now
s
Shawn Talbert
05/04/2022, 9:19 PMsame - I really expected this to be an easy one
s
S Feld
05/04/2022, 9:30 PMWhile we are on topic of complaining about missing links I'll add missing link between Vendor bills and inbound shipment item (though they reference each other on the UI)
c
creece
05/05/2022, 6:04 PMSummon @tdietrich he may know
j
jen
05/05/2022, 7:34 PMlol
t
tdietrich
05/05/2022, 7:56 PMI've never found a join table between transactions and related files. It might have something to do with SuiteQL not supporting any BLOB columns.
This seems to be one of those SuiteQL "blind spots" that we run into from time to time. But I this one is a big one.
Maybe someone with a good relationship with NetSuite can open a ticket?
j
jen
05/05/2022, 7:56 PMI’m pretty sure I have a black mark on my file for being hostile with support too many times
s
Shawn Talbert
05/05/2022, 9:40 PMdon't cross a crosstrek owner!
s
S Feld
05/05/2022, 10:28 PMI doesn't hurt to try, I'll open a ticket and copy my account manager
S Feld
05/30/2022, 12:10 PMso 25 days later, i have a issue number 673527
please vote, (not that i think that voting ever matters...[in netsuite])
b
burkybang
05/30/2022, 12:20 PMSend a link?
8 Views