DynamicFieldRemoteDB with filter

[jlima]

Hi
I have two dynamic fields (category and subCategory) that are filed by the agent when picking a ticket. I need to have another dynamic field (problem) with a selection of the problems reported on the last 7 days in the selected cat+subCat combination. For this last field I'm considering to use a DynamicFieldRemoteDB.

I already have it linked to a db view that selects the problems of the last 7 days BUT I need to fetch only the ones of the selected cat+subCat.

My question is:
Is it possible to use the value of another dynamic field as a parameter to filter the data fetched to a DynamicFieldRemoteDB?

best regards
Jorge

[tto]

Hi
I have two dynamic fields (category and subCategory) that are filed by the agent when picking a ticket. I need to have another dynamic field (problem) with a selection of the problems reported on the last 7 days in the selected cat+subCat combination. For this last field I'm considering to use a DynamicFieldRemoteDB.

I already have it linked to a db view that selects the problems of the last 7 days BUT I need to fetch only the ones of the selected cat+subCat.

My question is:
Is it possible to use the value of another dynamic field as a parameter to filter the data fetched to a DynamicFieldRemoteDB?
[..]

Hi there,
...yes it is possible, but requires some development (of DynamicFieldRemoteDB). Feel free to contact our sales department for a coresponding offer - just send an email to sales@cape-it.de.

Another simple solution would be to use a single field fo type "DynamicFieldRemoteDB" using a VIEW which contains all cross-products of (cat + " / " + subCat) set in the recent 7 days, in one column. Then the "intelligence" is in the VIEW, not in the dynamic field.

regards, T.

[jlima]

hi tto
thanks for your reply

1) I'll talk to my boss

2) I think you're suggesting I merge the three combos (cat + subCat + problem) into one. In that case I'll have a huge list that I don't think my agents will accept. Or didn't I understand your idea?

best regards
Jorge

[tto]

2) I think you're suggesting I merge the three combos (cat + subCat + problem) into one. In that case I'll have a huge list that I don't think my agents will accept. Or didn't I understand your idea?

...I didn't think of field "problem" too, but if you're saying it's required, then yes merge three combos. Howver, since you can use auto-complete and wildcards, finding some selection is not impossible and it's some solution you can do on your own.

regards, T.