SJEaton

Eek I'm struggling to do this @Steve Giller , useless on database direct I'm afraid. Can you provide what I need to enter to find this please?

('{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_o}}' = 'INR Star') OR ('{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_t}}' = 'INR Star') This works if only 1 site is selected in custom k, both not if both i.e if the above example didnt' have Southend or TRAC selected it works ok, but with both selected it doesn't present anything

Excuse my ignorance @Steve Giller, where can I check this? In the request questions it shows as this

Hi @Met I've tried both LIKE and CONTAINS and neither have worked if 2 things are selected in custom k. @VictorFor the record, the condition you provided does work if only 'Basildon' is selected in k. Sam

@Victor I had 'Basildon' in k and 'INS Star' in o. What may be tricking it is that k may also contain another value as it is a static check box field. Do I need to use Contains 'Basildon' instead of = 'Basildon'?

Hi @Victor It seems this syntax is still not working. I think the condition in source seems ok... <strong>Site System Access requested for (if different from above):</strong>&nbsp;<esp-condition contenteditable="false" expression="('{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_o}}' = 'INR Star') OR ('{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_t}}' = 'INR Star')">Basildon</esp-condition> Any other suggestions? Sam

Thanks @Victor, I'll try it

Hi @Victor Thanks, its good to hear any logical operators can be used in email template ESP conditions and thanks for the info, but I'm still struggling to get my ESP condition expression to work. I've tried multiple versions with no success. What I'm trying to achieve is: Global Variable -> Custom K = Basildon AND Global Variable -> Custom O = INR Star OR Global Variable -> Custom K = Basildon AND Global Variable -> Custom T = INR Star All of the following don't seem to work and no value is pulling through: '{{.H_custom_k}}' = 'Basildon' AND ('{{.H_custom_o}}' = 'INR Star' OR '{{.H_custom_t}}' = 'INR Star') ('{{.H_custom_o}}' = 'INR Star' OR '{{.H_custom_t}}' = 'INR Star') AND '{{.H_custom_k}}' = 'Basildon' '{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_o}}' = 'INR Star' OR '{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_t}}' = 'INR Star' ('{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_o}}' = 'INR Star') OR ('{{.H_custom_k}}' = 'Basildon' AND '{{.H_custom_t}}' = 'INR Star') What's the version that I am missing that will actually work? Thanks

Hi I want use ESP conditions to only present information in an email template if certain things are true. I know this works for simple expressions like '{{.H_custom_o}}' = 'DatixQ (DCIQ system)' OR '{{.H_custom_t}}' = 'DatixQ (DCIQ system)' but I want to include another layer into this expression to look at another custom field too (e.g. is it this, or this, and this). Can AND, OR and CONTAINS be used in ESP Condition expressions? Do I need to use brackets too? I've checked the wiki but it doesn't give many examples, hence my question. Thanks Sam

Hi, Hi Thanks for the detailed investigation. SR00478490, SR00478527 and SR00478571 were all examples that I provided where I was proving that it was working correctly originally, so I already knew that the custom fields pulled through as they should have done on these requests. Sorry if this was misleading in my email as its resulted in investigation you didn't need to undertake. The investigation into SR00478551 has however found the cause of the issue - an incorrect mapping of a character value to an integer field (custom 26). I thought custom fields 26-30 were for whole numbers so thought it would be ok to use but now I know lol. I've changed it to Custom 35 and all custom fields are pulling through, hooray!!

Thanks Gerry. A "Wait for Linked Requests to Complete" operation would be fab! Are you saying you are looking to implement this? Sam

Hi I've done some tests this morning using old versions of the IC which prove that at some point custom fields were pulling through into the BPM. I've updated IN00174847 with the details. Basically it tells me that the issue started after version 'DS_MSE - New Joiner 2 (copy 071122)' of the IC when I started adding the other 'Additional System Access Information' forms. None of these forms have custom fields in them though, they just have override flags based on what is selected in the previous forms for C,E,O,T so why would this cause the issue? It should also be noted that 'DS_MSE - New Joiner 2 (copy 071122)' still has the 3 inputs into a branch node and it works still!

Hi @Steve Giller I've amended the IC so the decision node only has 2 inputs. It would be useful if there was an error message (as there is in a BPM) that flags in the IC when this is done as it allowed me to do this and save and publish so it's misleading. I have however tested again, with a scenario that doesn't bypass the populating of custom N and it still isn't pulling it into the BPM - see timeline update on SR00478270. Custom Fields C, E, O and T still aren't pulling through either. These are captured in forms prior to the node that I have amended. Nanette has a passcode already to look into this. Sam

Hi @James Ainsworth, I'm finding more and more instances where the custom fields don't seem to be pulling through into the BPM. I have various 'get request details' all throughout the BPM and then I based a branch Gotoif statement on the value of a custom field and the branches aren't routing as they should, so it seems there's definitely a problem somewhere. I've numbered the Gotoif statements to see if that made a difference but it doesn't seem to have. I have an example where Custom N is used in 12 x forms on the IC, and then it's used in a branch Gotoif as follows, and it's not working. Although Custom N appear in 12 forms, it will only pass through one of the forms but is this the issue do you think? I've had other ICs that use the same custom field multiple times and there hasn't been an issue, so I've always thought that's ok?? This is really slowing down the configuration of a process that is top priority for me to be completed this week so its urgent that I get this sorted asap.

Hi @James Ainsworth I have lots of custom fields mapped in the IC. An example here shows custom C, E, O and T are in one form. These are text format... I do have multiple forms with these custom fields in, but each form has a different Form ID and I understand this is fine to have. The other custom fields I use are all set up in a similar way and some are dates, some are numbers, and some are text. These are only used once in the IC yet they do not pull through either, eg...

Hi I have various custom fields pulled into the description which is shown in the request details but they aren't pulling through. If I pull them through as a getICanswers variable they work ok but if I pull through as getrequestdetails and select the CustomFields it doesn't work. I've done some tests where I also update the timeline with all custom fields and they are all blank - SR00476821 I then changed custom field C to getICanswer instead and it pulled it through ok - SR00476859 I have a get request details node prior to setting the summary and description so any ideas why this is happening? Sam

OK, not sure what happened there then. I'll give it another go, thanks Steve

Hi @Steve Giller, this is the question.

Good morning. Further update on this... I changed nothing and re-tested the 6 that had this problem. 4 of them passed successfully this morning and 2 of them didn't. One of these then passed on the 3rd attempt. Sam @Victor @Steve Giller

Just to add, I also tried adding a manual update to take it around the wait loop again to see if it caught up with itself but after a few hours, custom field 40 still isn't populated with the correct amount of 1's even though the test nodes that update the timeline suggest otherwise. For context, of 20 tests I've run today, 6 have this problem. It's not filling me with confidence that this workaround is fit for purpose as we can't have this happening these many times in our live requests. Sam

Hi it's me again! So here's the thing... I've got my '1's working well now I think and have test update timeline nodes in the BPM for now so I can check that all 'update custom field 40 with a 1' nodes are being passed through correctly which they are. Sometimes however when I'm testing, even though it's passed through them all and timeline updates are being received to prove this, the node that then updates the timeline to display what's in custom 40 so I can see that it's appended all the necessary 1s shows there is one less 1 than there should be in custom 40. Sometimes this happens and other times it doesn't. I thought it might be to do with the speed of all the 1's being appended to the custom field and it not quite catching up with itself before it updates the timeline to show what's in custom 40 so i added a wait node that waits a minute prior to updating the timeline to show what's in custom 40. this however hasn't made any difference. Sometimes its correct, sometimes it isn't. Whatever it is, its meaning that sometimes my test parent requests don't resolve as they should because it's still waiting for another '1'. Even when it goes around the loop again when the final task is complete, it doesn't seem to rectify itself, it still thinks it has a 1 missing when I know for a fact all 'update custom field 40 with a 1' nodes have been passed through as they updated the timeline accordingly. Rather baffling! What do you think? Have anyone come across similar when you have been testing? Any other ideas for how I might be able to look in the backend to try and figure out what 1 it thinks didn't append to the custom field? Thanks

It seems to be ok now, thanks

Hi If you use the 'Add Value' function in a custom expression and use 'contains', does this allow for multiple values to have been selected in the Custom IC field, e.g. if Laptop, Computer Headset and Webcam were all selected in the IC, would this expression still resolve as 'Yes'? Thanks

Hi @Berto2002 I do have such a node in the originating BPM, but what is it that you select in the variable to pull the custom field through?? Thanks