Overview
Allows end users of the platform to construct their own grids, charts, and dashboards.
Key Features & Functionality
Note: Appian provides self-service analytics capabilities where end users can explore enterprise data and build their own custom reports. Before downloading this utility, refer to Appian Documentation to see if you can use the available self-service analytics capabilities.
Hi Mike, First I want to say Kudos!!!! Great Job!!!! Thank you so much!!! We owe you a pizza. I saw the breakout session you did at Appian World and it came at the exact right time.
Second, we are seeing an issue that the report or dashboard that is created cannot be seen in the interface until either the Record is synced manually or it is synced overnight during the scheduled sync. That is alittle concerning when giving this to the users that are to create their own reports that they can't see the report until they ask us to sync the record for them or they have to wait until the next day. We may be missing something so please let me know if that is the case.
Again, thank you for creating this app.
The sql statements included in the release are specifically for mariadb. One thing you could try is to publish the datastore and have it create the tables for you.
In terms of what it does, it is for creating the primary key for the table and setting up foreign keys for indexing. It is not a composite key.
That issue is going to be fixed in the next version. If you want to fix it manually as it might be a week or so before the new version is up here the fix is to update:
isnull(fv!item.choicesRuleRef)
to
rule!AH_isBlank(fv!item.choicesRuleRef)
in AH_GenerateExpression
As for what you are after, it does sound like a custom formatter - all of the documentation for this should be available in the Documentation tab (Question Mark icon).
Do you have a reference table where with a M:1 relationship against the main record type and instead use the value in the reference table rather than displaying what sounds like the foreign key?
Hi Mike,
The new version did indeed fix that issue. Ran into another issue thought I should share. I added an expression rule name to a record type field hoping to solve the data model issue we have where reference type relationships are using map of name / value pairs (e.g value stored is 1 but we display "Category 1"). Upon realizing my misunderstanding of what the choice rule expression would do I went to remove it from the record type configuration and receive this error when saving:Expression evaluation error [evaluation ID = 0d1a6:1b2d0] in rule 'ah_configurerecordtype' (called by rule 'ah_configurerecordtypes') at function a!buttonWidget [line 967]: An error occurred while executing a save: Expression evaluation error in rule 'ah_generateexpression' at function a!forEach [line 7]: Error in a!forEach() expression during iteration 3: Expression evaluation error: Invalid index: Cannot index property 'name' of type String into type List of Variant
Also with regards to resolving reference type values to labels in chart data points is this where I have to implement custom field formatters for all use cases (e.g. a chart of ticket category counts shows label of 1 instead of "Category 1")?Thanks,
Bob
I just downloaded it yesterday, must have just missed the latest updated version. Thanks for the quick reply. Will try to reinstall latest.
Please try the newest version, this is an issue with 2.0.1.
If you'd rather fix it, simply delete this line from AH_GenerateExpression:
" isMultiple: " & if(isnull(fv!item.isMultiple), false, fv!item.isMultiple) & "," & char(10) &
Hi,
Installed and attempting to import my first record type package and then configuriing record type for available fields and filters. When clicking the save button receive this error. Any thoughts if I did something wrong in stall or did I hit a bug?
Expression evaluation error [evaluation ID = 925d0:c9f92] in rule 'ah_configurerecordtype' (called by rule 'ah_configurerecordtypes') at function a!buttonWidget [line 967]: An error occurred while executing a save: Expression evaluation error in rule 'ah_generateexpression' at function a!forEach [line 7]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'isnull' parameter 1 [line 81]: Invalid index: Cannot index property 'isMultiple' of type Text into type AH_RecordField
Regards,