Changes to the community structure and the menu bar
Significant changes have happened to the structure of our community and our drop down menu bar. READ ABOUT IT HERE
IT Asset Manager / Connect-IT User Discussions
cancel

Maximum Value in a column of a table using Connect-IT

Maximum Value in a column of a table using Connect-IT

Hi

Can you please suggest how can we find maximum value in a column of a table using Connect-It.

For example if I filter out 100 records from complete table and I want largest value from date last modified column for those 100 records, how can we find it.

2 REPLIES
Trusted Contributor... JohnLaw Trusted Contributor...
Trusted Contributor...

Re: Maximum Value in a column of a table using Connect-IT

Does this section of the documentation help you at all :

https://docs.microfocus.com/Connect-It/9.80/Content/Connector_Guide/AQL%20Queries.htm

Highlighted
Micro Focus Expert ran_b
Micro Focus Expert

Re: Maximum Value in a column of a table using Connect-IT

Hi  Hitesha,

Max( <column> ) function is what you need to use. It returns the maximum value of a "number", "string" or "date" type column. There are examples given in the Connector Guide. Do let us know if you have further queries.

Best regards

Ranjan Bhattacharya

Micro Focus