If you are wondering how to use Document queries in your Docs Made Easy, here is the step-by-step walkthrough of the Document Query creation process.
Step1: Login to Salesforce.
Step 2: Click on App Launcher.
Step 3: Now, in the search box, type HIC Docs Made Easy.
Step 4: Click on HIC Docs Made Easy.
This will navigate you to the HIC Docs Made Easy app’s home page.
Step 5: Here, click on Document Queries.
Step 6: Now, click on New.
The query builder page will open at this stage.
Step 7: Now, on the query builder page, add the query name and select the object on which you want to build the query.
Step 8: Next, select the field that you want to query from a multi-select picklist.
Step 9: Now, click on the Next button.
Step 10: On the next page, add the filter that you want to apply to the query.
Step 11: Now, click on the Next button.
Step 12: Here, give the order of fields as per requirement and click on Save.
Result: Query is created.
Step 13: Next, click on the gear icon and click on setup.
Step 14: Now, on the setup page, click on object manager.
Step 15: Select the object ”Account” as the query is created on the account.
Step 16: Now, click on the button, link, and action.
Step 17: Next, click on the button on which you want to add the Document Query.
Step 18: Now, click on the edit button.
Step 19: Add the QueryId parameter in the button URL and alias.
Please note that while adding dynamic filters in a query, you must use the pv0 parameter to run the query. In the above example, to add that filter value in button, the Query ID which is referencing pv0 is selected.
Likewise, If there are multiple filters, then parameter values will be referenced as pv1,pv2, and pv3 going upto N numbers.
Step 20: Now, click on the Save button.
Step 21: Next, open the Account Object and click on the record.
Step 22: Click on the button on which we updated the parameter.
Result: The composer page is opened.
Step 23: Click on the “Build your own” button.
Result: On the builder Page, a Query is available with its alias name.
Step 24: Now, if you want to execute the query and access the data from the query, use the query on the builder page.
Step 25: Then, click on the preview to check the output.
Result: All Account ids and names are downloaded.
Hope you find this helpful. Thanks for reading!