Hi,
I need query entity model for below scenario.
I have one database table. It has request number, application name, ID, etc., Every request number has one application. But every application has many request numbers. For Eg., XYZ0001 - Appian. But Appian - XYZ0001, XYZ0002., I need to display all the latest request number and all remaining fields in each application in report.
For Eg.,
Appian: XYZ0002
ABC: XYZ0008
Application count also dynamic. Application count can change in any time like if we create new request with new application name, we need to add this new application name in that report with request number.
Thanks for your help!
Discussion posts and replies are publicly visible
Hi Manju N,
I would suggest you write a MySql View and get all your desired result.
Note: Mysql group_concat() will help you get all the reference numbers comma separated for a particular application.
Regards,
Sachin
Are you able to articulate your data model more clearly? You say "one table" but it sounds like it might be one table (to hold Application) and another table to hold many Request Numbers. If this is the case, then Sachon's suggestion (to create a View to "flatten" the data) is the way to go. I'm not clear if you're also asking to be able to retrieve only her the very latest Request for any given Application. In which case you'll need to add a datetime value to help you retrieve the latest value.
No, I have application and request number in same CDT.
So, how are you having multiple Requests in the same Application? Are they in a single attribute as comma-delimited text (or something similar)?
Not like that, Every request number has one application name. There are 40 database entries. Every entry has one request number and one application name. For Eg., under Appian Application, I've 15 entries. Now I need to retrieve the latest request among these 15 entry. This is like Group By function.
Thanks for the response!
Yes Sachin, I need to write View I guess. Thanks again!