Finance | Project Operations, Human Resources, ...

Adding query based filter

(1) Share

Report

Posted on by VV-22040800-0

Hi,

Our client using the custom accounting source explorer report which is almost the same as standard one but with some additional fields, in custom report they're still using the 'Update' filter and in standard report they're using the latest 'Advanced filtering' option, now they are expecting to add the query based 'Voucher' filter which is available in the 'Advanced filter' to be included in the 'Update' filter present in custom report - could you confirm if this is feasible and provide your inputs?

I have the same question (0)

All responses (12)

Answers (0)

VV-22040800-0 12 on at

Like (0)

Report

Hi,

Anyone has inputs for this?

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I'm not getting your question; can you share screen shots of the original filters and what you want to achieve?

Thanks,
Waed Ayyad

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

Hi Waed,

Below is the current 'Update' filter which client is using in custom account source report and here they're expected to add the similar 'Voucher' filter which is present in the latest 'Advanced filtering', they will filter the voucher values with not equal (!) and select all (*) ranges which is possible in query based 'Advanced filtering'.While adding the new voucher filter in the 'Update' form, they're expecting the existing filters (From - to) should also work along with the new voucher filter.

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

What do you mean by this "with not equal (!) and select all (*)"? the customer wants to filter the report data based on the entered Voucher (From, To) to be not the entered values? Also, the form you showed is it Dialog form?

I have a question are you duplicating the filters? You already have Voucher from and to, so they want to add duplicate functionality?

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

I'm referring that not equal (!) and all (*) criteria which can be used in the query based advanced filtering when we want to search any fields like 'Voucher' which not equals to some value but this type of filter is not available in the existing 'Update' filter and it will just fetch the voucher by the from and to condition. They will use the 'From and To' voucher filter and along with the new 'Voucher' filter - like From voucher 1 To voucher 10 and in the new voucher filter they will exclude some voucher like ! voucher 5. The 'Update' filter form which I shown is the standard dialog form - 'AccountingSourceExplorerParameters'

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (1)

Report

Hi,

Any response?

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Do you mean the new filter will only exclude values?

Thanks

Waed Ayyad

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

The new voucher filter will be primarily used for excluding the values but it should also provide the option to perform other filter options as well which is available in standard advanced filtering - like search all vouchers matching the given value like abc*.Basically we need to get the standard query based voucher filter in the 'Update' form where all other existing filters are not query based.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

As you mentioned it's customised then you will have all the capabilities to customise it.

To answer your question, yes if it is using ui builder or a dialog form, then based on that you can change your code.

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

Actually the standard accounting source report has been duplicated and the 'update' filter belongs to standard form 'AccountingSourceExplorerParameters'. The query is right now this form will get the From & To filter values in the form field control and those values will be used as condition in accountingsourceexplorerprocessor class filterby methods but the new voucher field which needs to be added in same form should be the query/data source based and we need to modify the class to include the query based filter criteria along with the existing non data source form field control filter criteria.

Was this reply helpful? Yes No