How do I get past this error when using SuiteQL: Invalid search query. Detailed unprocessed description follows. Search error occurred: Unknown identifier 'tc_entity_balert_sent'. Available identifiers are: {customer=customer}

AI generated answer (using internal Slack threads):

It seems like you're encountering an error with SuiteQL due to an unknown identifier 'tc_entity_balert_sent'. This error typically occurs when you're trying to access a field or table that doesn't exist or isn't available in the context of your query. In your case, the error message is indicating that 'tc_entity_balert_sent' is not a recognized identifier. The available identifiers listed in the error message include 'customer'. If 'tc_entity_balert_sent' is a custom field, you need to ensure that you're using the correct script id for the field. If it's a standard field, you need to ensure that you're using the correct field name as per the NetSuite Records Browser. If 'tc_entity_balert_sent' is a table, you need to ensure that the table is accessible in your current context. Not all tables are accessible in all contexts. For example, some tables are only accessible in SuiteScript and not in SuiteQL. Here's a general example of how to use identifiers in SuiteQL:

sql
SELECT {field_name} FROM {table_name}

Replace

{field_name}

with the name of the field you want to select, and replace

{table_name}

with the name of the table from which you want to select the field. Remember to always double-check the field and table names in the NetSuite Records Browser or in your custom record definitions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******