How to pass dynamic filter to combo box - Kinetic

Kinetic ERP
,
1

Hi,
I have a combo box in a dashboard for which I have assigned BAQ to it and the BAQ values are populating correctly with no filter.
I have one textbox of Project whose value I need to pass to my combo box dynamically as a filter.
I tried by passing project binding to combo box and it showed me “No Data Found” but if I pass static value to filter of the combo box it works fine.
Below is the screenshot of passing the static filter to combo box:

image
image392×511 5.64 KB

Any help with how to pass dynamic filter to combo box will be helpful !!
Thanks in advance.

2

image
image369×816 6.87 KB

Is an example. The ‘LongDescColumn’ in the ‘Filters’ section is essentially just a placeholder that is replaced via the ‘Filters Params’ configuration.

JSONC Example

“svc”: “Ice.BO.UserCodessvc”,

      "svcPath": "GetRows",

      "textField": "CodeDesc",

      "valueField": "CodeID",

      "isDelimited": true,

      "comboId": "Test2",

      "tableName": "UDCodes",

      "filters": [

        "CodeTypeID = 'WFFunction' AND LongDesc='?{LongDescColumn,''}'"

      ],

      "filtersParams": [

        "LongDescColumn=?[DescriptionLibraryID]"

      ]
3 Likes
3

I tried your approach but still it is not working, I am attaching the below screenshots for reference:

image
image379×535 48.9 KB

image
image382×519 5.25 KB

image

4

In the above screenshot, it looks like you’ve used curly brackets ‘{’ instead of square ones ‘[’. See my example:
“LongDescColumn=?[DescriptionLibraryID]”

How/where the difference types of brackets and syntaxes are used is a bit all over the place and I am yet to see a good resource/document with examples for all which is making it a lot harder than it should be at the moment. Hopefully soon Epicor or someone else can share a solid guide for clarity and assistance.

Maybe try square brackets and then if that doesn’t work, confirm that a static filter value works.