function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Richard RobbinsRichard Robbins 

sooql

Hi

I am tring to write an SOQL Query to return all Contract Numbers from the Wessex Contract Table that match an entered Common fixing number, Please see the image below 

User-added image

Any help would be greatly apreciated

R
Ty WhitfieldTy Whitfield
I would think you would need 2 SOQL queries.  One to collect all of the Contract Numbers that are associated with a Common Fixing Number then loop through each one and with another SOQL query collect the information from the Wessex Contract based upon that iterated Contract Number.
Alain CabonAlain Cabon
Hi,

For SOQL, first change the display: "View Options" > "Display Element Names"

User-added image

... and repost the same perfect snapshot with the new element names that we will use in the SOQL request.

 
Richard Robbins 37Richard Robbins 37
Hi Thanks for the reply's, here are my tables with the field names


User-added image
Alain CabonAlain Cabon
 SOQL Query to return all Contract Numbers from the Wessex Contract Table that match an entered Common fixing number,

What is the "common fixing number" ? There is no field with this name.