https://community.dynatrace.com/t5/DQL/DQL-Query-how-to-get-the-appVersion/m-p/265307#M1536 <P>One option would be to use the parse command to <STRONG>parse</STRONG> out the version, like this:&nbsp;</P> <LI-CODE lang="markup">| parse appVersion, "(INT '.' INT '.' INT):truncated_version"</LI-CODE> <P>Could you show the query where your solution is NOT working?&nbsp;</P> Sun, 15 Dec 2024 21:18:22 GMT Tiit_Hallas 2024-12-15T21:18:22Z https://community.dynatrace.com/t5/DQL/DQL-Query-how-to-get-the-appVersion/m-p/264984#M1529 <P>the appVersion is 3.0.1.1234 (<STRONG>a.b.c.d</STRONG>- format). but, i need to get the appVersion as <STRONG><EM>a.b.c.&nbsp;</EM></STRONG><EM>how to achieve that in here?&nbsp;<BR />actually i achived that by using this code:&nbsp;<BR /></EM></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">data record(appVersion = "3.0.2.1102") | fieldsAdd versionParts = splitString(appVersion, ".") | fieldsAdd truncatedVersion = concat(versionParts[0], ".", versionParts[1],".", versionParts[2])</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><EM>but, i am unable to use this on my actual use case in <STRONG>userSessionQuery.&nbsp;</STRONG></EM></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-12-11 at 3.28.39 PM.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/25168i0BFFEFA14A9ED792/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2024-12-11 at 3.28.39 PM.png" alt="Screenshot 2024-12-11 at 3.28.39 PM.png" /></span></P> <P>Help me in this regard&nbsp;</P> <P>&nbsp;</P> Thu, 12 Dec 2024 08:22:50 GMT https://community.dynatrace.com/t5/DQL/DQL-Query-how-to-get-the-appVersion/m-p/264984#M1529 sivag1205 2024-12-12T08:22:50Z https://community.dynatrace.com/t5/DQL/DQL-Query-how-to-get-the-appVersion/m-p/265307#M1536 <P>One option would be to use the parse command to <STRONG>parse</STRONG> out the version, like this:&nbsp;</P> <LI-CODE lang="markup">| parse appVersion, "(INT '.' INT '.' INT):truncated_version"</LI-CODE> <P>Could you show the query where your solution is NOT working?&nbsp;</P> Sun, 15 Dec 2024 21:18:22 GMT https://community.dynatrace.com/t5/DQL/DQL-Query-how-to-get-the-appVersion/m-p/265307#M1536 Tiit_Hallas 2024-12-15T21:18:22Z