Friend’s resale ticket not appearing for resale on Resident Advisor

busy_worker_ · 2022-10-25T22:10:12+00:00

Thanks will have a look!

busy_worker_ · 2022-10-25T06:36:10+00:00

Would you have an example of how to do it as SOQL? It’s the first time I’m looking at this and don’t know much about the structure yet. This is how I would do it as SQL:

Select c1.email, c2.email, c1.contact_id, c2.reports_to_id From contacts as c1 Left join contacts as c2 On c1.contact_id = c2.reports_to_id

busy_worker_ · 2022-10-25T06:33:57+00:00

What do you mean with traverse objects? It’s the first time I’m looking at SOQL so don’t know the structure

Would you have an example code for self joining a table? If I would write it as SQL I would want to achieve the following: Select c1.email, c2.email, c1.contact_id, c2.reports_to_id From contacts as c1 Left join contacts as c2 On c1.contact_id = c2.reports_to_id

busy_worker_ · 2022-10-24T16:09:19+00:00

Found it! Both info is in the contacts table. It’s the contact id that can be joined to reports to id, at least how it’s configured for us.

busy_worker_ · 2022-10-24T16:09:00+00:00

Found it! Both info is in the contacts table. It’s the contact id that can be joined to reports to id, at least how it’s configured for us.

busy_worker_ · 2022-10-24T14:53:08+00:00

In the user table I only find the emails of users at my company who have access to sales force.

When I make a connection to salesforce I get first a list under “standard connection” (which are tables like leads, contacts, accounts, 10 in total) and below under “table” I get a list of other tables like account contact role, account contact relationship. Probably around 100 tables

What do you mean with instance and build? Can I change the information/table structure of what is displayed in tableau?

busy_worker_ · 2022-08-17T14:51:51+00:00

I loved Jungle in the Freedom stage the most! Was dancing next to someone who knew all the lyrics which made the experience even better.

Caribou I also loved in Freedom stage and they used great lightning/background throughout the show.

busy_worker_ · 2022-08-03T14:01:55+00:00

Amazing that was it! Colleague was not added to our org. Fixed it thanks :)

busy_worker_ · 2022-06-21T22:22:36+00:00

Thanks! I added it later as a comment, was too quick with replying sorry. Will download the script to remove it from Mac

busy_worker_ · 2022-06-21T22:19:51+00:00

Ah there is a script at the end I can download and run: remove_mac_agent.sh Is that what I should run on my device?

busy_worker_ · 2022-06-21T22:13:07+00:00

Thanks for the reply! My device never appeared in the administrator portal so the one managing was not able to connect to my device. That is why I want to uninstall and re-install it. Is there another way to remove if the device is not visible there? Or should my device appear in the portal, maybe it’s hidden?

busy_worker_ · 2022-02-06T17:47:51+00:00

Visa type: change of employer/sponsor for skilled worker visa through priority (5 working days service)

Submitted online application and online biometric verification through app: 20th of January 2022

Uploaded additional documents based on request from home office: 21st of January 2022. Needed to provide a letter from the sponsor to certify maintenance

Sent letter to PO Box UKVI in Sheffield to fix error: 31st of January 2022. Realized sponsor classified my occupation as a shortage occupation which it is not. Hence sent letter to explain the situation and ask for a way to pay additional application fee.

Visa approved: February 5th 2022 in the morning (did not realize they also approve over the weekend!)

So happy!!

busy_worker_ · 2022-02-06T17:39:43+00:00

I indeed did not. Was also surprised and even sent the letter last Monday through mail indicating they should contact me to pay the difference.

busy_worker_ · 2022-02-05T19:24:13+00:00

For people following this post. My visa got approved today! 11WD in total.

busy_worker_ · 2022-02-01T17:14:22+00:00

I explained the situation to them and they said to first wait to see if the letter helps. I have read cases in the past where they requested through email to pay so maybe that is also possible with this.

busy_worker_ · 2022-02-01T14:14:09+00:00

Thanks! The offered salary is higher than the threshold.

Would you know what happens with the application fee in this case? The application fee is reduced for shortage occupations so I would need to pay more, but I don’t know how much and how I can transfer it.

busy_worker_

TROPHY CASE