cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

How do I write service for case sensitive ??

RM12
13-Aquamarine

How do I write service for case sensitive ??

Hello,

         I want to compare database data and mashup data ,for this please suggest How do I write  JavaScript service with case sensitive ??

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Ashritha
13-Aquamarine
(To:RM12)

Hi,

Following snippet can be used for the case sensitive search on infotable.

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].EQFilter({
    fieldName: undefined /* STRING */,
    isCaseSensitive: undefined /* BOOLEAN */,
    t: undefined /* INFOTABLE */,
    value: undefined /* STRING */
});

 

Inputs:
fieldName: "<Name of column that needs to be compared>"
isCaseSensitive: true/false based on requirement
t: Infotable that contains data 
value: <value that needs to be compared>

View solution in original post

4 REPLIES 4
tmisner
16-Pearl
(To:RM12)

Hello RM12,

 

Seeing as JavaScript is a case sensitive programming language this should be a fairly straightforward comparison of both the input parameters. One input would be the Database data and the other would be the Mashup data.

 

The service could be configured as follows:

Inputs:

Name: databaseInput, Data Type: <Desired Data Type To Compare>

Name: mashupInput, Data Type: <Desired Data Type To Compare>

Service Code:

var result = databaseInput === mashupInput;

 

Output:

Name: result, Data Type: Boolean

 

Regards,

Tyler

RM12
13-Aquamarine
(To:tmisner)

not getting an proper output while entering any data it show me true value ,it should not comparing database data with case sensitive please suggest and refer below attachment 

1) Is there any other way to comparing database data with case sensitivity ?? 

2) which function is used for case sensitive for comparing database data??

Ashritha
13-Aquamarine
(To:RM12)

Hi,

Following snippet can be used for the case sensitive search on infotable.

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].EQFilter({
    fieldName: undefined /* STRING */,
    isCaseSensitive: undefined /* BOOLEAN */,
    t: undefined /* INFOTABLE */,
    value: undefined /* STRING */
});

 

Inputs:
fieldName: "<Name of column that needs to be compared>"
isCaseSensitive: true/false based on requirement
t: Infotable that contains data 
value: <value that needs to be compared>

slangley
23-Emerald II
(To:RM12)

Hi @RM12.

 

If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Top Tags