Goal: Have a CSS rule that can utilize a date field extrapolated from a Jira Issue field (Parent.fields.customfield_10102) to create a rule to color the field when the Jira issue date is greater than [today].
Current Attempt: Parent.fields.customfield_10102:>[today]
Explanation of Effort
I've tried several versions of the filter using different virtual functions such as timestamp, jiraDate, formatDate, convertDate none of which worked. Sure I'm missing something with handling the date field from the Jira issue, but can't figure out how to manipulate the value correctly. The same process is used in another place on the page with a filter of Target:>[today]and works perfectly. Here though the Target field is as standard Confiforms date field.
<ac:structured-macro ac:macro-id="db8e41cc-9495-416e-b435-1919fae27086" ac:name="confiform-card" ac:schema-version="1">
<ac:parameter ac:name="useCache">true</ac:parameter>
<ac:parameter ac:name="formName">ProjectInfo</ac:parameter>
<ac:parameter ac:name="enableGridEdit">true</ac:parameter>
<ac:parameter ac:name="showEmptyValues">true</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="10f66642-9cc0-42b4-a491-48651c70d551" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="overrideLabel">Project Item</ac:parameter>
<ac:parameter ac:name="fieldName">Parent</ac:parameter>
</ac:structured-macro> <ac:structured-macro ac:macro-id="f2c7a7d5-c35b-4dbd-be1a-827b9828a88d" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="overrideLabel">Status</ac:parameter>
<ac:parameter ac:name="fieldName">Parent.fields.status.name</ac:parameter>
</ac:structured-macro> <ac:structured-macro ac:macro-id="341f7feb-eb0b-439a-9ffd-6afe608df490" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="overrideLabel">Target Due Date</ac:parameter>
<ac:parameter ac:name="fieldName">Parent.fields.customfield_10102</ac:parameter>
</ac:structured-macro> </p>
<p>
<ac:structured-macro ac:macro-id="718aa7d7-4c32-4b5c-852e-c02d3353799f" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="overrideLabel">Project Manager</ac:parameter>
<ac:parameter ac:name="fieldName">Parent.fields.assignee.displayName</ac:parameter>
</ac:structured-macro>
</p>
<h1>
<ac:structured-macro ac:macro-id="5ab9539c-f5a6-426d-89d5-fd2d793a73e4" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="overrideLabel">Last Updated</ac:parameter>
<ac:parameter ac:name="fieldName">Updated</ac:parameter>
</ac:structured-macro>
</h1>
<p>
<ac:structured-macro ac:macro-id="9b077991-4ceb-4a46-a863-7685974f970e" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">HideComplete</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="eabdf136-ca42-4802-ac15-44f6d5bfc364" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">ActionUpdate</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ad7840a1-a4b3-404d-83bb-b9c61a94495d" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">id.queryCount(ProjectActivities:@self;(Target:<[today] AND !JiraIssue.fields.status.statusCategory.name:done))</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="5cc8dd37-09f0-4654-a84d-df3f6c5e0d72" ac:name="confiform-field-css" ac:schema-version="1">
<ac:parameter ac:name="condition">Parent.fields.customfield_10102:>[today]</ac:parameter>
<ac:parameter ac:name="css">color:white;background-color:green</ac:parameter>
<ac:parameter ac:name="fieldName">Parent.fields.customfield_10102</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
