Hiya Happ, it depends wether the XPATH is being applied in a Microflow/Nanoflow or used in the UI (On a grid for example). It's normally advised to create a temporary holder which stores the converted value to be used in the XPATH statement. Example for microflow/nanoflow: Create a date-time variable before the XPATH statement using the function ParseDateTIme to convert the string into the Date-time variable, then use the variable in your query. Example for UI : Create a Non-persistent entity to store the date time attribute, which is created/populated by a datasource microflow or nanoflow. In the flow, copy and convert the fields which will be used in your query, if your datagrid is nested within this non-persistent entity on the page, the attributes will be accessible in your Xpath Statement.
@@MendixCommunity Thanks by the looks of it that would definitely work. But have to maintain the entity with attributes in it. So I guess I should create a generic entity to be used in this kind of scenario. Super many thanks! :)
iam so liked this video,usually i didn't see much videos on mendix
This was very helpful, great webinar
Great its help alot please post a video in domain model and microflows
Please make more deep dive videos! This was fantastic
how to convert field that is datatype is String (unlimited) to a data type DateTime to be used in Xpath.
Hiya Happ, it depends wether the XPATH is being applied in a Microflow/Nanoflow or used in the UI (On a grid for example). It's normally advised to create a temporary holder which stores the converted value to be used in the XPATH statement.
Example for microflow/nanoflow:
Create a date-time variable before the XPATH statement using the function ParseDateTIme to convert the string into the Date-time variable, then use the variable in your query.
Example for UI :
Create a Non-persistent entity to store the date time attribute, which is created/populated by a datasource microflow or nanoflow. In the flow, copy and convert the fields which will be used in your query, if your datagrid is nested within this non-persistent entity on the page, the attributes will be accessible in your Xpath Statement.
@@MendixCommunity Thanks by the looks of it that would definitely work. But have to maintain the entity with attributes in it. So I guess I should create a generic entity to be used in this kind of scenario.
Super many thanks! :)
how to find the login user's department