Hello, I am almost sure I need to use an IF statement somewhere but my html coding skills are not adequate to figure this out. So looking for help. I have the following expression for the instance_name field for my survey concat (' ',${address_physical},' ',"; ",' ',format-date(${violation_obs},'%m-%d-%Y'),' '," ",' ',${issue_label},": ",${resolution_status_latest},' ') The resolution_status_latest field contains various options, including resolved. My colleagues asked me if only those responses that are unresolved appear in the Inbox, i.e. those that have been resolved disappear from the Inbox. Can someone help? Thanks!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Make resolved records invisible in Instance Name

dsinha

Hello,

I am almost sure I need to use an IF statement somewhere but my html coding skills are not adequate to figure this out. So looking for help.

I have the following expression for the instance_name field for my survey

concat ('',${address_physical},'',"; ",'',format-date(${violation_obs},'%m-%d-%Y'),''," ",'',${issue_label},": ",${resolution_status_latest},'')

The resolution_status_latest field contains various options, including resolved. My colleagues asked me if only those responses that are unresolved appear in the Inbox, i.e. those that have been resolved disappear from the Inbox.

Can someone help? Thanks!

Find more posts tagged with

Accepted answers

dsinha

Finally found a solution today after trying everything for the last one month and it was counterintuitive, at least to me. The filter works when I used the label value, instead of the name.

What I had overlooked is that the jr:choice-name() function generates the label value, and not the name value. Because resolution_status_latest was calculated using resolution_status_label, which in turn was generated using a jr:choice-name() function, it was producing the label value.

So when I used resolution_status_latest<>'resolved', it did not work because 'resolved' is the name value. When I changed it to resolution_status_latest<>'Resolved' it worked.

All comments

dsinha

Finally found a solution today after trying everything for the last one month and it was counterintuitive, at least to me. The filter works when I used the label value, instead of the name.

So when I used resolution_status_latest<>'resolved', it did not work because 'resolved' is the name value. When I changed it to resolution_status_latest<>'Resolved' it worked.

Neal_t_k

Filter is filtering, just not to what you want. Last thing I have is to check spelling, capitalization, ensure you are using names and not labels etc.

dsinha

Thanks @Neal_t_k.

When I tried resolution_status_latest NOT IN ('resolved'), nothing was filtered

When I tried resolution_status_latest IN ('othStatus1', 'othStatus2',...), all the records disappeared

Neal_t_k

@dsinha Well at least it is filtering then, just not filtering right.

One more thing to try: How about instead of =, use "NOT IN" or "IN"

so something like

resolution_status_latest NOT IN ('resolved')

or conversely

resolution_status_latest IN ('othStatus1', 'othStatus2',...)

dsinha

Strangely, when I tried to use = in the where clause, all the records disappeared from the Inbox. I am going to ask Tech Support for help.

Thanks!

dsinha

Thanks @Neal_t_k. I will try the first solution with '='. I am hesitant to add new fields since my colleagues have already collected data and adding new fields at this stage would delete all existing records.

Neal_t_k

Or you could set it up so that field is NULL until it is 'resolved' and then for your query: resolution_status_latest IS NULL

You could set a hidden helper field to: if(indexed-repeat(${resolution_status_label},${resolution_steps},${resolution_count}),'resolved','resolved','')

The 'is null' work for me in my test

Neal_t_k

hmm I don't use this too much, maybe try this:

where=resolution_status_latest<>'resolved'

https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service/#sql-92-where-clause

Not sure whats going on, I can't get it to work with '<>' or '!=' but it works with'='

So you could try the opposite, and set it to show when it equals resolution_status_latest = 'not resolved'

dsinha

Thats how it is set up. The resolution_status_latest field is in the main form where it is calculated based on what is entered in the repeat field.

This is the calculate expression for resolution_status_latest where resolution_status_label is the repeat field:

indexed-repeat(${resolution_status_label},${resolution_steps},${resolution_count})

Neal_t_k

That's a definite possibility. You might try to calculate a field in the main form, based when resolved is entered in a repeat, then use that for your where clause?

dsinha

Thanks @Neal_t_k. However it is not working. Do you think because it is a calculated field (pulls data from a repeat field)?

Neal_t_k

Sounds like you might want to put a where clause on there, instead of tackling it in the instance name.

resolution_status_latest<>'resolved'

https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepareforediting.htm#ESRI_SECTION1_635E8...

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.