[realdrouin Contributions: 0Level 1☆]

I’ve been asked to create the SQL Statement for a save searched.

It was quite easy until I tried to link to a “custom field”. Let me go in more detail.

The search is about location, so the field part is easy

select Name, City… from location

We have unique region. We created a custom fields with all the values

I’m trying to link to the custom field, which I have no idea

Any help will be greatly appreciate
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC Contributions: 0Level 1☆]

Are you trying to create an actual SQL statement because you are wuerying NS through ODBC, or do you mean you have to create a NetSuite saved search?

[realdrouin Contributions: 0Level 1☆]

I need to create an SQL Statement to connect to the database through ODBC. I’m trying to connect to the Other Custom Fields

[david.smith Contributions: 0Level 1☆]

Can you post your saved search here as code? You can use this Chrome plugin if you need help. https://chrome.google.com/webstore/d…epdmfaihdokglp

[chanarbon Contributions: 0Level 1☆]

@realdrouin,

If you are connecting using ODBC, you may refer to the Connect Browser (https://system.netsuite.com/help/hel…d/account.html). If you are getting the getting custom fields, you may concatenate the name of the custom entity field e.g. MY CUSTOM FIELD to MY_CUSTOM_FIELD

[realdrouin Contributions: 0Level 1☆]

SELECT LOCATIONS.NAME, SUBSIDIARIES.NAME, custrecord22_real

FROM LOCATIONS LOCATIONS,

SUBSIDIARIES SUBSIDIARIES,

SUBSIDIARY_LOCATION_MAP SUBSIDIARY_LOCATION_MAP

WHERE LOCATIONS.LOCATION_ID = SUBSIDIARY_LOCATION_MAP.LOCATION_ID

AND SUBSIDIARY_LOCATION_MAP.SUBSIDIARY_ID = SUBSIDIARIES.SUBSIDIARY_ID

custrecord22_real as the following values

Blue

Green

Yellow

The save search looks like this

Pepsico Sales Blue

Coke Revenues Red

Dr Pepper HR Orange

I’m trying to link to the customrecord table. That’s what I’m searching ? I need the table name, the field name and the link

Any help will be GREATLY appreciated

[david.smith Contributions: 0Level 1☆]

Do you have a saved search that already performs this? If so, it would be extremely helpful if you posted that for us to reference.

[chanarbon Contributions: 0Level 1☆]

realdrouin , the name of the ODBC table for the custom record should be similar to to concatenation of the name of the custom record e.g. a custom record with name Colors Available should be COLORS_AVAILABLE

[Author]

Posts