Extract data with specific value in load script

[43918084]

I have a table from jira connection.  In this table, I only need to extract data where the field value is timespent.  I use where match but keeps getting error.  Would appreciate expertise to resolve.  Below is my script.  Many thanks in advance.

LIB CONNECT TO 'JIRA_PROD';

LOAD

field as [History.field],

    from as [History.from], 

fromString as [History.fromString], 

to as [History.to], 

toString as [History.toString];

SELECT 

field,

    from,

fromString,

to,

toString

FROM History

WITH PROPERTIES (

issueIdOrKey='$(vkey)'

)

where exists(field, 'timeestimate')

;

[henrikalmen · Accepted solution]

You state that you're trying to filter on the value 'timespent' but in the script you have written 'timeestimate'.

You also say that you are using "match" but your script uses "exists". You could try where wildmatch(field, '*timeestimate*', '*timespent*').

I don't know what kind of connection your JIRA_PROD connector is, but it kind of loks like SQL. The with propertied and where exists statements are not compatible with sql, perhaps you should move that to your preceding load statement (the part above the select statement)?

[43918084]

Thanks a lot for your advice.  Apology that I m new to the load editor.

[Anil_Babu_Samineni · Accepted solution]

same like @henrikalmen about confusion of field, otherwise this is how you can think writing?

LOAD

field as [History.field],

    from as [History.from], 

fromString as [History.fromString], 

to as [History.to], 

toString as [History.toString] where WildMatch(YourFieldName, '*timespent*');

Here you need to define your field name where you want extract. 

[43918084]

Thanks a lot for the guidance.  I can resolve my problem with both your expert knowledge.