npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

sfdx-extended-soql

v0.0.2

Published

Extension to the standard SOQL queries

Downloads

22

Readme

sfdx-extended-soql

Extension to the standard SOQL queries

Version CircleCI Appveyor CI Codecov Greenkeeper Known Vulnerabilities Downloads/week License

$ npm install -g sfdx-extended-soql
$ sfdx-extended-soql COMMAND
running command...
$ sfdx-extended-soql (-v|--version|version)
sfdx-extended-soql/0.0.2 darwin-x64 node-v9.2.0
$ sfdx-extended-soql --help [COMMAND]
USAGE
  $ sfdx-extended-soql COMMAND
...

sfdx-extended-soql gilgou:genquery

Generates a SOQL query with all explicit fieldnames instead of '*'

USAGE
  $ sfdx-extended-soql gilgou:genquery

OPTIONS
  -a, --fieldaccess=fieldaccess                   Field access : all, or updateable
  -q, --query=query                               Query to execute (select * from Account)
  -u, --targetusername=targetusername             username or alias for the target org; overrides default target org
  --apiversion=apiversion                         override the api version used for api requests made by this command
  --json                                          format output as json
  --loglevel=(trace|debug|info|warn|error|fatal)  logging level for this command invocation

EXAMPLES
  $ sfdx gilgou:genquery --targetusername [email protected] --query "Select * From Account"
     Select Id,IsDeleted,MasterRecordId,Name,Type, ... From Account

  $ sfdx gilgou:genquery --targetusername [email protected] --fieldaccess updateable --query "Select * From Account"
     Select Name,Type,RecordTypeId,ParentId, ... From Account

See code: src/commands/gilgou/genquery.ts

sfdx-extended-soql gilgou:soql

Executes a SOQL query with all explicit fieldnames instead of '*'

USAGE
  $ sfdx-extended-soql gilgou:soql

OPTIONS
  -a, --fieldaccess=fieldaccess                   Field access : all, or updateable
  -f, --outputformat=outputformat                 Output format of the results (empty, csv, tree)
  -q, --query=query                               Query to execute (select * from Account)
  -u, --targetusername=targetusername             username or alias for the target org; overrides default target org
  --apiversion=apiversion                         override the api version used for api requests made by this command
  --json                                          format output as json
  --loglevel=(trace|debug|info|warn|error|fatal)  logging level for this command invocation

EXAMPLES
  $ sfdx gilgou:soql --targetusername [email protected] --query "Select * From Account"
     | Id | IsDeleted | MasterRecordId | Name | Type | RecordTypeId | ...
     | 001i00000093gBiAAI | false | null | GenePoint5 | Customer - Channel | null | ...
     ...
  

  $ sfdx gilgou:soql --targetusername [email protected] --fieldaccess updateable --query "Select * From Account"
     | Name | Type | RecordTypeId | ParentId | BillingStreet | ...
     | GenePoint5 | Customer - Channel | null | null | 345 Shoreline Park
  Mountain View, CA 94043
  USA | ...
     ...
  

  $ sfdx gilgou:soql --targetusername [email protected] --fieldaccess updateable --query "Select * From Account" 
  --format csv
     "Name","Type","RecordTypeId","ParentId","BillingStreet" ...
     "GenePoint5","Customer - Channel","null","null","345 Shoreline Park
  Mountain View, CA 94043
  USA", ...
     ...
  

  $ sfdx gilgou:soql --targetusername [email protected] --fieldaccess updateable --query "Select * From Account" 
  --format tree
     {"records":[{"attributes":{"type":"Account","referenceId":"AccountRef1"},"Name":"GenePoint5","Type":"Customer - 
  Channel","RecordTypeId":null,"ParentId":null,"BillingStreet":"345 Shoreline Park
  Mountain View, CA 94043
  USA", ... }]}
     ...

See code: src/commands/gilgou/soql.ts

Debugging your plugin

We recommend using the Visual Studio Code (VS Code) IDE for your plugin development. Included in the .vscode directory of this plugin is a launch.json config file, which allows you to attach a debugger to the node process when running your commands.

To debug the hello:org command:

  1. Start the inspector

If you linked your plugin to the sfdx cli, call your command with the dev-suspend switch:

$ sfdx hello:org -u [email protected] --dev-suspend

Alternatively, to call your command using the bin/run script, set the NODE_OPTIONS environment variable to --inspect-brk when starting the debugger:

$ NODE_OPTIONS=--inspect-brk bin/run hello:org -u [email protected]
  1. Set some breakpoints in your command code
  2. Click on the Debug icon in the Activity Bar on the side of VS Code to open up the Debug view.
  3. In the upper left hand corner of VS Code, verify that the "Attach to Remote" launch configuration has been chosen.
  4. Hit the green play button to the left of the "Attach to Remote" launch configuration window. The debugger should now be suspended on the first line of the program.
  5. Hit the green play button at the top middle of VS Code (this play button will be to the right of the play button that you clicked in step #5). Congrats, you are debugging!