IT Asset Manager / Connect-IT User Discussions
cancel

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

Hitesha Arora
Senior Member.

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
Micro Focus Frequent Contributor
Micro Focus Frequent 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
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