Finance | Project Operations, Human Resources, ...

Can't remove the field from filter records query

(0) Share

Report

Posted on by Harshal Jain

162

Hi ,

So, I added the field 'channel' in the AOT query in front end and then click okay. I again filter the records and then remove the field and clicked okay. If I come again to the fitler records and see the field is still present. It doesnt get removed. This is not happening with any other field. Can't figure out the issue.

Step 1 - The fields before adding

Step 2- Added the channel field and clicked ok.

Step 3 - Clicked on the filter fields and then removed the channel field.

Step 4- Opened the filter records again and the field comes

As said this issue is only for channel field and not other field.

I have the same question (0)

All responses (12)

Answers (0)

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

What exactly are you doing? It's not clear to me what you mean by "adding in the AOT query in front end".

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

Hi Martin,

I wanted to add the field 'channel' in filter records as it wasn't mentioned in my AOT query. But later decided to not to use it so removed it. When I came back here again then i could see the field. It wasn't removed. So this is the issue.

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

Martin, this is the backend custom AOT query. Maybe my words would be wrong. I hope you got my scenario that what issue am i facing?

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

By AOT query I mean was it is the custom query with only limited ranges . I am adding a new range explicitly from front end and when i remove it then, it comes back again.

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

I known what an AOT query is, but I have no idea where "in your front end" you opened this query dialog. This is what I hoped to hear from you.

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

Hi Martin,

So this is a query based report. It has few filters. When i add an extra filter field on clicking the filter records, it allows me to do so. When i remove this field it get removes at that time but if i click again on filter record that field will still be available.

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi Harshal,

did you try to click reset?

Or did you try to clear usage data?

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future. You can do this by ticking the box "Does this answer your question"

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

Hey Layan,

I tried both. But the issue persists.

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

This issue is happening for Order lines not invoiced report too. This is a standard report . But when i add the channel field it gives me the following message -

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

Like (0)

Report

Hi Harshal,

If the suggestion from Layan didn't work, you can go to the User options and open Usage data. Here you can search for ranges, report selections or all usage data. You can clean up specific records. In the end, you can also try to reset all usage data.

Was this reply helpful? Yes No