JRS Custom Expression documentation
I'm trying to create better reports on JRS and I am having no luck finding documentation on what can be done with Custom Expressions. The few resources only go into a couple of options, and I've been able to find more random options on this forum or other pages (for example GROUP_CONCAT), so I imagine there's different expressions that can be used. Is there anywhere where all these are documented?
2 answers
Actually I think Lita is asking about the option newly added in V7 to create a custom expression in a column of data on the "Format Results" tab of the guided UI (rather than using an advanced query). The available functions differ by database (Data warehouse with Db2, Oracle or SQL Server) or LQE.
Comments
You're correct Daniel. The custom expression provides some options you can click on, but looking through the forum I happened to find GROUP_CONCAT which has been useful but it's not an obvious option on JRS and I was hoping there was some documentation from IBM that I missed about this and other functions.