Skip to main content
Solved

Filters (Scheduling) - List on criteria expected


Forum|alt.badge.img+10

Hi,

Customer wants to create a new filter, in Dispatch Console, based on some contracts.

He has created a new “filter Activities”, column Name “Contract Number”, set operator as “In” and then, expected the list of the contracts to select them. But there is no list. Do you know why ?

Then he has entered manually “Contract_1;Contract_2”, saved. Using this filter in Dispatch console is not concluant. No result.

I did some tests and had to set operator as “Like” or 2 lines with “=” as operator and “OR” as logical to make it works.

 

What are your recommandations ? 

 

Alliance V15.1.0.12

Best answer by Phil Seifert

Hi Laurence,

I checked this functionality with R&D and it is not possible to use the IN operator for this filter:

The filter by Contract Number cannot use IN operator because the contract lookup does not allow multiple contracts selection.

If the for an ‘IN’ functionality for contract filter is required, please log new ticket with request to change Contract Number lookup (RFE) from singe- to multi-selection lookup.

Otherwise, the only option is the one which you are already using to set up multiple OR lines in a grouping.

 

View original
Did this topic help you find an answer to your question?

22 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • January 25, 2023

Hi Laurence,

I have not looked into this one but did you also try comma separators instead of semi-colon?  I know most of Europe uses semi-colons instead of commas but sometimes there are things that revert to using standard US type definitions.

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • January 26, 2023

Hi Phil,

Yes, I tried as well with coma with the same result : doesn’t work…

Laurence


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • Answer
  • January 30, 2023

Hi Laurence,

I checked this functionality with R&D and it is not possible to use the IN operator for this filter:

The filter by Contract Number cannot use IN operator because the contract lookup does not allow multiple contracts selection.

If the for an ‘IN’ functionality for contract filter is required, please log new ticket with request to change Contract Number lookup (RFE) from singe- to multi-selection lookup.

Otherwise, the only option is the one which you are already using to set up multiple OR lines in a grouping.

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • January 30, 2023

In addition, customer asks why this is not a list of contract here... indeed, you’ve talked about a lookup but actually, it is not. Just an empty field where you can type in… Any improvment possible ? 

 

 


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • January 30, 2023

What R&D is saying is that on a given order/activity, there can only be one contract thus when you do a contract lookup in those modules, you can only select one contract, not select a series of contracts.

What they are also saying is that if you want to use this more like the IN operator seen with SQL, this is a change that has to be requested and ticket logged.  There was no design to use a list of contracts in the filter as only one contract can be selected.

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • February 6, 2023

Hi Phil,

 

Yes, understood anyway is it possible to have a lookup here instead of typing enterily the contrat number ? 


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • February 6, 2023

Hi Laurence,

This would require a code change to implement so technically it would be possible however IFS does not have any plans to modify this code so the long answer is no, not at this time.

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • February 6, 2023

Hi Phil,

 

Thank you. However, I have to inform you that the customer is very unstaisfied with this answer and expects a solution. Any suggestion ? 


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • February 14, 2023

Hi Laurence,

Which version is the customer using that does not have a lookup for the Filter Activities - Customer Number?

Reason I am asking is that I see in our QAC environment which is basically the release of 15.4 SU4 there is a lookup button for the customer contracts in the filter definition:

Astea Browser:

 Web Employee Portal:

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • February 14, 2023

Hi Phil,

 

Good news ! Unfortunately, customer is in V15.1.0.12.

Any chance a HF would be provided for that version ? 

 

Thank you

Laurence


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • February 14, 2023

HI Laurence,

I am checking on that aspect of it. The next HF for v15.1 is HF14 tentatively scheduled for around end of March.  Whether this would be available with that or not, I don’t know but have asked.

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • March 20, 2023

Hi Phil,

 

Do you have any input on this topic please ? Do you know if March-HF will include this ? 

Thank you


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • March 20, 2023

Hi Laurence,

I received a response that this will not be added to v15.1 as that is now on extended support which means only critical and high severity bugs will be fixed.

This can be developed by your developers to add a lookup to the v15.1 version as this is not a framework issue and your company has the associated source code.

 


Forum|alt.badge.img+11
  • Sidekick (Customer)
  • 111 replies
  • March 24, 2023

Hi Phil

It seems this ticket is relevant to me as well. I am using standard IFS filter but cant select multiple values. If I use 2 competencies together, I get no results while I get when I use them individually.

Any way how I can get multiple selection?


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • March 24, 2023

Your screen looks like you are using IFS Apps, PSO or IFS Cloud, not Alliance which this specific forum group is Alliance only.  I am not involved with these products myself so do not have the expertise to advise you correctly.

Alliance does not have the fields in your screen such as Competency, Resource Group, etc.

How did you populate the search criteria?  Manually typing or selecting both within the Find option?  If the latter and it populates the same way as shown with a semi-colon separator, I would say this is an issue that should be logged as a ticket with your IFS Support resources.

 

-----------------------------------------------------------------------------------------------------------

If this were Alliance, I would think it necessary to use them individually with OR statements in a filter design.

Example with Skills on the Filter SAs:

If you have other conditions that also must be mean, you may have to insert an AND between each of the OR lines such as this:  (I have NOT tested this but parenthesis grouping is not available)

 


Forum|alt.badge.img+11
  • Sidekick (Customer)
  • 111 replies
  • April 27, 2023

Hi Phil

yes this is cloud & I used the Find option for search criteria. I have raised the ticket but it is pending since 10 days.


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • April 27, 2023

HI @anushakh,

I see you also posted this same question today in the proper group for your IFS Cloud which has already received a response:

multiple criteria in dispatch filters | IFS Community

Hopefully, you will get the assistance you need from that channel.

@Laurence DEBRIE, have you discussed with your company enhancing the Alliance 15.1 code for the change you need as indicated above?


Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 112 replies
  • April 27, 2023

Hi Phil,

At this time customer doesn’t want us to spend time on this, as it could be implemented in a comming HF.

 

Laurence


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • April 27, 2023

Hi Laurence,

This will not be coming in a later HF for Alliance v15.1.  Please see this response provided earlier in this topic chain:

I received a response that this will not be added to v15.1 as that is now on extended support which means only critical and high severity bugs will be fixed.


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • June 29, 2023

Hi Laurence,

Alliance SU5 was released today and has the capability of using multiple contracts in the filter now.  You may want to consider upgrading your v15.1 customer to v15.4 SU5.

 


athobie
Sidekick (Partner)
Forum|alt.badge.img+11
  • Sidekick (Partner)
  • 185 replies
  • June 30, 2023

Hi @Phil Seifert 

Would you mind us to send the what’s new SU5 ?
I didn’t find it here  : https://community.ifs.com/alliance-version-15-211
maybe i could find it elsewhere ?

Thanks and Regards

anthony


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1305 replies
  • June 30, 2023

Hi Anthony,

I have attached the SU5 What’s New document.

Kind regards,

Phil


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings