Solutions
Items
solution items are the building blocks you include in a solution items include reports agents document templates html templates dashboards a single solution can contain multiple items working together for instance, a complex multi item merge might include a burst report (to determine recipients), several source reports (to provide the data), and a document template (to package the final output) when using templates, you can assign aliases to report items so the system knows exactly where to place specific data within the template reports these are the most common items and can include standard salesforce reports, custom reports created in unaric reports or reports from external data sources like google analytics or servicenow there are different report types you can add as items regular reports regular reports are included in the solution as a separate file as such, tthey are not used as the burst report or a source report for a document template if you are not sure which one to use, then most likely you should just use a regular report files for regular reports, select your formatting and file options you would like to apply to your solution item you can choose to specify the format or select a report template format select a format from the drop down that you would like to apply to the report you can add or update formats in the configure > formats page you can toggle select salesforce lightning style or salesforce classic style you can include the report as an attachment to the email or as an upload to a file storage service such as google drive in any of the following file types html, xlsx (excel), csv, pdf, and salesforce formatted pdf if file type options are missing, navigate to configure > settings , disable enable pdf download only and re login to unaric reports report options header toggles the metric header for lightning reports report chart toggles the chart on the report report table toggles the table on the report row counts toggles the row counts on the tables detail rows toggles the columns and rows with detailed data subtotals toggles the subtotals columns and rows on the table grand total toggles the grand total row on the table template select a template from the drop down that you would like to apply to the report the template will only affect the report embedded in the email, pdf, and excel (printable view) file types to add or update templates, go to the templates tab to add or update report templates, see docid\ r6 zcezbhy1rkvtlrtoxv naming options file name default file name will be the url encoded name of the report plus the file extension for example, the name of a pdf file for a report named 'test report' will be 'test+report pdf' to override, enter your own file name (don't include the file extension in your name) append date to filename you may choose to append the date to the file name this gives the file a unique identifier, which may be useful in case you are tracking the history of data date format default date format when you select "append date to filename" is mm dd yyyy hh mm ss, e g , 05 17 2024 11 12 35 if you'd like to use this default, leave this field empty if you would like to provide your own date format, enter that format here this field follows the https //docs oracle com/en/java/javase/11/docs/api/java base/java/text/simpledateformat html for example, if you just wanted to include a date with underscores instead of dashes, you would enter mm dd yyyy file password using this field will require your recipients to enter a password for the file for each attachment that is sent (pdf, excel & word only or zipped csv ftp files) file password field using this field will require your recipients to enter a password that comes from the burst report for the file for each attachment that is sent (pdf, excel & word only or zipped csv ftp files) data update (under advanced options ) you can use the fields below to update the records included in this report this feature requires the first column of the report to be either an id field or a field that contains the id in the link such as the first name , last name , and full name on the contact object to update api name of the oobject, such as contact, that you would like to update after the solution runs field to update api name of the field from the object to update that you would like to update after the solution runs update value value that you would like to use for the update use true if you would like to mark a checkbox as checked and false to mark it as unchecked use today() to use the current date and now() to use the current date / time if using a database other than salesforce, then for string fields, set the values with double quotes, for example "test" don't update if report is empty check if you don't want to update the field if the report is empty, then check this box agent you can assign an agent to this solution item to have it analyse the data in the report format specify which format to use when sending the data to ai most of the settings on a format are not applicable because ai doesn't look at the styles, colours, etc however, you can specify whether to use formatted or unformatted values, which does affect the data that is sent to the agent sending formatted values will help ai to better analyse the data as it will be able to pick up on things like currency symbols and note that the value is currency amount instead of just a raw number send criteria add criteria that define when this item will send for example, you could say you only want to send a report when the record count is over 100 or the sum of an amount is over $100,000 if you add more than one criterion, you can also specify how you would like the criteria to be evaluated using the filter logic for example, if you wanted the report to send if either your first criteria or second criteria is met, you would put in 1 or 2 if you don't input a filter logic value, then it will use and to combine the filters additional fields (these will only display if you are using a burst) filter field field on which to filter this report filter operator operator used when applying the filter to this report burst filter value field field from the burst report that contains the value used to filter this report no report filter if selected, the report will not be filtered and will run only once this enables you bring in a report that does not need to be filtered but still needs to be included for example, in a burst solution that sends your customers a report of their past orders, you may also want to include a report that lists out all your products that list of products is dynamic from salesforce (that is why you would use a report) but it is the same for each customer, so there is no need to filter it per customer like you would with the past order report burst reports burst reports are used to drive a burst solution and to filter the source and regular reports to learn more about burst reports, see docid\ zacjw9a2zlaaicicaj1vx burst reports can only be salesforce tabular reports or unaric reports custom reports without a grouping record identifier field the field that uniquely identifies a record in a burst report, which is usually an id field this is used for activity tracking and is also important if you are using the solution apis for example, if you set up a button in salesforce to run a filtered report on a contact, then you would set this field to the contact id that way when you click the button from salesforce (which passes in the contact id in the url), unaric reports knows how to take the contact id and filter the burst report down to just that contact also there is an advanced scenario where you can include the filter value directly in your regular or source custom report (either in the soql or on a filter) and then the record identifier field tells unaric reports to use this field as the filter value on those reports name value field the field to be used as the "name" for the activity record if this value is not set, then the activity will be tracked using the record identifier field setting this field makes it easier to review activity and determine the status of specific records for example, if you have a burst set up on contacts, then most likely the record identifier field would be set to the contact id when reviewing activity for a burst though the id is hard to use when looking for specific contacts in this case, you may want to use email as the name value field burst filter value field in some burst scenarios, you may need to filter down the burst report to a smaller set of records for example, if you are sending an email from a salesforce campaign and your burst report contains campaign members, then you would want to filter the burst report to just members of a specific campaign in that case, you would set the burst report filter value field to campaign id file format configuration is not available for burst and source reports, because you aren't sending these items but are using them to filter a report or personalize a document, respectively source & data record reports source reports are reports that are merged into a document template to learn more about document templates, see docid\ ezsn8kn8jykpfxkyev0iz data record reports are used to return individual records this allows you to bring in data from a specific set of records in salesforce and then reference it within your emails and / or documents for example, say you wanted to bring in data about the customer's subscription you could set up a report that returns the fields from their subscription record that you need and then use the burst to filter down to just their subscription alias alias used within the document template to merge in this report to learn more about document templates and aliasing, click here main source report this is an advanced feature for document templates, if selected you can then filter all other source reports by this report this option is only shown on the first source report of a solution using this feature you could create a document that repeats blocks of cases with a sub table of case comments hat specific case within each block to learn more about this feature, see docid\ psulh94elc8iiotmikp2v data update (under advanced options ) you can use the fields below to update the records included in this report this feature requires the first column of the report to be either an id field or a field that contains the id in the link such as the first name , last name , and full name on the contact object to update api name of the object, such as contact, that you would like to update after the solution runs field to update api name of the field from the object to update that you would like to update after the solution runs update value value that you would like to use for the update use true if you would like to mark a checkbox as checked and false to mark it as unchecked use today() to use the current date and now() to use the current date / time if using a database other than salesforce, then for string fields, set the values with double quotes, for example "test" agent you can assign an agent to this solution item to have it analyse the data in the report format specify which format to use when sending the data to ai most of the settings on a format are not applicable because ai doesn't look at the styles, colours, etc however, you can specify whether to use formatted or unformatted values, which does affect the data that is sent to the agent sending formatted values, will help ai to better analyse the data as it will be able to pick up on things like currency symbols and note that the value is currency amount instead of just a raw number file record reports choose this report type to include files from salesforce in the solution you need to set up a burst report first and add the file record report pointing to the https //developer salesforce com/docs/atlas en us object reference meta/object reference/sforce api objects contentdocumentlink htm so it gets filtered down by the id from the burst report for example, you can use file record reports to bring in a product document associated with a support case dashboard files select your formatting and file options you would like to apply to your solution item format select a format from the drop down that you would like to apply to the report you can add or update formats in the configure > formats page you can toggle select salesforce lightning style or salesforce classic style you can include the report as an attachment to the email or as an upload to a file storage service such as google drive in any of the following file types html, pdf, and salesforce formatted pdf template select a template from the drop down that you would like to apply to the dashboard the template will only affect the dashboard embedded in the email, pdf, and excel (printable view) file types to add or update report templates, see docid\ r6 zcezbhy1rkvtlrtoxv naming options file name default file name will be the url encoded name of the report plus the file extension for example, the name of a pdf file for a report named 'test report' will be 'test+report pdf' to override, enter your own file name (don't include the file extension in your name) append date to filename you may choose to append the date to the file name this gives the file a unique identifier, which may be useful in case you are tracking the history of data date format default date format when you select "append date to filename" is mm dd yyyy hh mm ss, e g , 05 17 2024 11 12 35 if you'd like to use this default, leave this field empty if you would like to provide your own date format, enter that format here this field follows the https //docs oracle com/en/java/javase/11/docs/api/java base/java/text/simpledateformat html for example, if you just wanted to include a date with underscores instead of dashes, you would enter mm dd yyyy file password using this field will require your recipients to enter a password for the file for each attachment that is sent (pdf, excel & word only or zipped csv ftp files) agent agent you would like to use agent type regular regular agents are simply ones that will be included in the solution as a separate item meaning they are not used as the burst report or a source report for a document template if you are not which one to use, then most likely you should just use a regular agent source source agents are merged into document templates to learn more about document templates, click here alias alias used within the document template to merge in this agent to learn more about document templates and aliasing, click here format specify which format to use when sending the data to ai most of the settings on a format are not applicable because ai doesn't look at the styles, colors, etc however, you can specify whether to use formatted or unformatted values, which does affect the data that is sent to the agent sending formatted values will help ai to better analyse the data as it will be able to pick up on things like currency symbols and note that the value is currency amount instead of just a raw number document & html template select a document or html template from the dropdown that you would like to send as a static document or to merge reports and/or data into file type (for html templates) file types you would like included file name default file name will be the url encoded name of the document template plus the file extension for example, the name of a pdf file for a document template named 'test document' will be 'test+document pdf' to override, enter your own file name (don't include the file extension in your name) append date to filename you may choose to append the date to the file name this gives the file a unique identifier, which may be useful in case you are tracking the history of data date format default date format when you select "append date to filename" is mm dd yyyy hh mm ss, e g , 05 17 2024 11 12 35 if you'd like to use this default, leave this field empty if you would like to provide your own date format, enter that format here this field follows the https //docs oracle com/en/java/javase/11/docs/api/java base/java/text/simpledateformat html for example, if you just wanted to include date with underscores instead of dashes, you would enter mm dd yyyy file password using this field will require your recipients to enter a password for the file for each attachment that is sent (pdf, excel & word only) html template file type (for html) file types you would like included file name default file name will be the url encoded name of the html template plus the file extension for example, the name of a pdf file for a html template named 'test document' will be 'test+document pdf' to override, enter your own file name (don't include the file extension in your name) append date to filename you may choose to append the date to the file name this gives the file a unique identifier, which may be useful in case you are tracking the history of data date format default date format when you select append date to filename is mm dd yyyy hh mm ss , e g , 05 17 2024 11 12 35 if you'd like to use this default, leave this field empty if you would like to provide your own date format, enter that format here this field follows the https //docs oracle com/en/java/javase/11/docs/api/java base/java/text/simpledateformat html for example, if you just wanted to include date with underscores instead of dashes, you would enter mm dd yyyy file password using this field will require your recipients to enter a password for the file for each attachment that is sent (pdf, excel &; word only)