crunch | Crunch is an Apache TLP now , and lives at http

Calling update while build is ongoing is an example of dirty scenario. To fix your issue, do not call update inside the GetBuilder.

Sample...

In Home

You can do something like this:

One way could be to use a libraray which creates strings from a given regex like Generex. Using Generex your task is as simple as:

Edit

Right, it's a public page, it's called "Salesforce Sites". It's exposed to whole world without having to log in. These have special security in place because most of the time you don't want to expose data like that. At best you'd display contact us form, maybe some documents to download, product catalog... It's all very locked down, default is to ban everything and then admin decides what's allowed. It's bit unusual to have a Visualforce page + Aura component but ok, it happens.

You (and any other internal user) can see the results if you'd access this page from within salesforce. Something like https://mydomain.my.salesforce.com/apex/SearchBinReceiptsByYear and for you the page will work fine, "just" not outside of salesforce.

When exposed like that on the web - there's no logged in user. There's special "[Site Name] Guest User", you can see them if you search "Sites" in Setup. It has a special profile, also with [Site Name] in it. And nasty thing is - it doesn't show on the list of Users or Profiles.

Your code broke when Salesforce (auto)activated a critical update. Probably this one: https://releasenotes.docs.salesforce.com/en-us/spring20/release-notes/rn_networks_secure_perms_guests.htm There are some good resources on the net if you Google "Secure Object Permissions for Guest Users", for example https://katiekodes.com/salesforce-spring-20-guest-user/

Ask your system administrator colleague or read up a bit about sharing rules.

You'll have to go to Setup -> Sharing Rules. There's a checkbox that caused your stuff to break and you can't untick it.

Scroll down to your TRC Account object and hit "New". You'll need to create something like this, but with your criteria (TRC Member equals true)

Save, wait a bit (it might take a while to recalculate the sharing, you'll get an email) and try the page.

If it still doesn't work you'll have to check the Guest user's profile, it might need permissions to Read TRC Accounts and their Name field.

If it's Salesforce Sites - try this to find it: https://help.salesforce.com/articleView?id=000334554&type=1&mode=1

If it's a Customer Portal, Community, Digital Experience (they renamed the product few times) - try with https://help.salesforce.com/articleView?id=sf.rss_config_guest_user_profile.htm&type=5

Original answer

It looks like it's running OK because accounts (members?) are fetched first and in that fetch's callback (what to do when data comes back from server) you have helper.getLocationState, helper.getYear. And you wrote that these populate OK. It's not the best performance code but it should get the job done.

In no specific order...

Does the whole thing work OK for sysadmins? Or is it broken for everybody? If it works for sysadmins it might be something to do with sharing, your sysadmin should know (Setup -> Sharing settings is where you control who can see what. Maybe "mortals" are not allowed to see any data? Typically sysadmins bypass it. As a quick & dirty test you can modify the class definition to global without sharing class DataTableLocations but it's a really ugly hack.

What happens if you open DeveloperConsole (upper right corner) while running this component, do you see any errors in the logs? What happens if in the console you go Debug -> Open ExecuteAnonymous and run this piece of code:

You can check out this contributing guide and here's the compose source code: https://github.com/androidx/androidx/tree/androidx-main/compose. Note that not all libraries from Android are open for outside contribution AFAIK, but you can definitely contribute to the Compose compiler.

Yigit recently answered a related question on I/O 21. As a summary: they plan on opening up libraries so that everyone can contribute, but it has an effect on their regular development processes.

Also, here is the androidx github repo: https://github.com/androidx/androidx

to me you missed Syntax error, '>' expected for img tag in file Tools/Index.cshtml

I think you can use pandas to view the table and a list comprehension and split, in a loop over rows, to create the table html

The issue is /edit#gid=1652705509/ in the query string.

To target Sheet2, do this:

https://docs.google.com/spreadsheets/d/1pgdF1hoid8m1Zj3KburwjZRGkydLh1Sum4DshUMaIeo/gviz/tq?tq=SELECT%20B%20where%20A%20contains%20%22bird%22&sheet=Sheet2

Note the end parameter &sheet=Sheet2.

On type Dish you defined options: DishOptions, but then on type DishOptions you again defined a property options. So with you current types definition your options property looks like this: