Using the Salesforce provider

when working with the salesforce provider, it is helpful to know how to reference more than one salesforce object at a time, filter the columns you require, join data from different objects, and use it in a jig below are code examples of each using intellisense in the salesforce provider, use intellisense (ctrl+space) in the entities properties to select objects from the standard salesforce objects or start typing the name of the object, and the list will provide you with a selection when using custom objects, you need to manually type in the name a blue line will display under the name, this indicates that it is an unknown salesforce entity, and you can ignore the warning if it is a custom object intellisense in salesforce provider referencing multiple objects in a jig below is an example of syncing data from six salesforce objects when the jig is onfocus , using action sync entities multiple objects onfocus type action action list options actions \ type action sync entities options provider data provider salesforce entities \ account \ opportunity \ opportunitystage \ user \ userrole \ territory filtering columns below is a simple example of filtering the account object's name column to only return accounts starting with the letter a filter query title accounts starting with a type jig list icon contact header type component jig header options height medium children type component image options source uri https //images unsplash com/photo 1577974291737 faf660945d53?ixlib=rb 4 0 3\&ixid=m3wxmja3fdb8mhxwag90by1wywdlfhx8fgvufdb8fhx8fa%3d%3d\&auto=format\&fit=crop\&w=2674\&q=80 onfocus type action action list options actions \ type action sync entities options provider data provider salesforce entities \ account datasources filter account type datasource sqlite options provider data provider local entities \ entity account \# filter the account object to return specific columns and a select number of rows query select id, '$ name', '$ billingcountry' from \[account] where '$ name' like 'a%' data =@ctx datasources filter account item type component list item options title =@ctx current item name subtitle =@ctx current item billingcountry joining data below is an example of how you join data from multiple objects in salesforce using sqlite queries in this example we joining data in the account and case objects join data query select id as accid, '$ name', '$ billingcountry' from \[account] left join \[case] on accountid = accid group by casepriority = caseprior examples and code snippets the following examples with code snippets are provided create records in objects https //docs jigx com/examples/create records in objectsdelete records in objects https //docs jigx com/examples/delete records in objectssave & update records in objects https //docs jigx com/examples/save and update records in objectslist records in objects https //docs jigx com/examples/list records in objects