US 12,265,542 B2
No-code platform for generating reports as a transaction
Kavita Malhotra, Gurgaon (IN); Amit Kumar Bhola, Gurgaon (IN); Purushottam Soni, New Delhi (IN); Ratikanta Pal, New Delhi (IN); Devendra Kumar Singh, Gurgaon (IN); Vaishali Asija, Gurgaon (IN); Shweta Thapliyal, Gurgaon (IN); and Manoj Kumar Govel, Gurgaon (IN)
Assigned to TATA CONSULTANCY SERVICES LIMITED, Mumbai (IN)
Filed by Tata Consultancy Services Limited, Mumbai (IN)
Filed on Jan. 4, 2024, as Appl. No. 18/403,967.
Claims priority of application No. 202321001224 (IN), filed on Jan. 5, 2023.
Prior Publication US 2024/0232202 A1, Jul. 11, 2024
Int. Cl. G06F 16/2455 (2019.01); G06F 16/2457 (2019.01)
CPC G06F 16/24556 (2019.01) [G06F 16/24573 (2019.01)] 6 Claims
OG exemplary drawing
 
1. A processor implemented method comprising:
displaying, via an info slicer station implemented by one or more hardware processors, a plurality of slice objects, one or more information attributes in each of the plurality of slice objects and one or more report attributes for user selection, wherein the one or more report attributes comprise report type, report format, report title, and report frequency;
receiving, via the info slicer station, user selection comprising: a slice object among the plurality of slice objects, one or more information attributes of the slice object, one or more report attributes, and optionally one or more filters, grouping, splitting, and sorting conditions;
generating, via a context query generator implemented by the one or more hardware processors, a database query comprising a select clause, a from clause, and optionally a where clause, a join condition, a group by clause and an order by clause, wherein generating the data base query based on the user selection comprises:
creating the select clause comprising one or more database field names identified from the information attributes of the slice object using a metadata related to the slice object, wherein the metadata is a simplified representation of database that is generated for each of the plurality of slice objects by a metadata generator, implemented by the one or more hardware processors, based on (i) rules for transformation of database fields, (ii) metadata mapping to database fields in direct and transformed view, (iii) definition of join conditions for permutations and combinations of database fields in each of the plurality of slice objects, and (iv) business context of the database fields;
creating the from clause comprising one or more database table names identified using the metadata related to the slice object;
creating the where clause based on the one or more filters;
creating the join condition if the one or more database field names belong to more than one database tables as specified in the metadata related to the slice object;
creating the group by clause from the grouping conditions and the splitting conditions; and
creating the order by clause from the sorting conditions;
executing, via an info-bite generator implemented by the one or more hardware processors, the database query to retrieve data from a database; and
generating, via the info-bite generator, a report based on the retrieved data and the one or more report attributes.