CONVERT(VARCHAR(10), aaa, 101) +' ' + CONVERT(VARCHAR(8), aaa, 108) AS ACTION_DATE ,
o/p :-09/20/2018 10:36:00
IIF(CONVERT(INT, col) = 0,
CONVERT(VARCHAR(2), DAY('2014-05-17')) + '/' +
CONVERT(VARCHAR(2), MONTH('2014-05-17')) + '/' +
CONVERT(VARCHAR(4), YEAR('2014-05-17')),
CONVERT(VARCHAR(2), DAY(col)) + '/' +
CONVERT(VARCHAR(2), MONTH(col)) + '/' +
CONVERT(VARCHAR(4), YEAR(col))) AS DATEC
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="account">
<attribute name="name" />
<attribute name="aa_accountrecordtype" />
<attribute name="aa_outletno" />
<attribute name="accountid" />
<attribute name="ownerid" />
<attribute name="parentaccountid" />
<attribute name="statecode" />
<attribute name="territoryid" />
<attribute name="aa_preferredagencymodifiedon" />
<attribute name="aa_preferredagencycomments" />
<attribute name="aa_preferred_agency" />
<attribute name="aa_additionalaccowner" />
<attribute name="aa_pref_agy_eff_start_dt" />
<attribute name="aa_pref_agy_eff_end_dt" />
<attribute name="aa_coveragecode" />
<attribute name="accountnumber" />
<order descending="false" attribute="name" />
<filter type="and">
<condition attribute="aa_accountrecordtype" operator="eq" value="100000001" />
<condition attribute="aa_outletno" operator="not-null" />
</filter>
<link-entity name="businessunit" from="businessunitid" to="owningbusinessunit" visible="false" link-type="outer" alias="a_6ad8133d2f1e4c43a3da460bacb3d6a5">
<attribute name="name" />
</link-entity>
</entity>
</fetch>
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="account">
<attribute name="name" />
<attribute name="aa_accountrecordtype" />
<attribute name="aa_outletno" />
<attribute name="accountid" />
<attribute name="ownerid" />
<attribute name="aa_preferredagencymodifiedon" />
<order descending="true" attribute ="aa_preferredagencycomments" />
<attribute name="aa_preferred_agency" />
<attribute name="aa_additionalaccowner" />
<attribute name="aa_pref_agy_eff_start_dt" />
<attribute name="aa_pref_agy_eff_end_dt" />
<attribute name="aa_coveragecode" />
<attribute name="accountnumber" />
<order descending="false" attribute="name" />
<filter type="and">
<condition attribute="aa_accountrecordtype" operator="eq" value="100000001" />
<condition attribute="aa_outletno" operator="not-null" />
</filter>
<link-entity name="systemuser" from="systemuserid" to="aa_additionalaccowner" link-type="outer" alias="su">
<attribute name="fullname" />
<attribute name="employeeid" />
</link-entity>
</entity>
</fetch>
<fetch>
<entity name='account'>
<attribute name='name' />
<attribute name='accountnumber' />
<attribute name='createdon' />
<order attribute='createdon' />
<order attribute='name' />
<order attribute='accountnumber' />
</entity>
</fetch>
Dataverse always orders attributes specified by the link-entity after attributes for the entity element.
The following example shows a conventional ordering pattern for both link-entity attributes and entity attributes.
<fetch>
<entity name='account'>
<attribute name='name' />
<attribute name='accountnumber' />
<attribute name='createdon' />
<link-entity name='account'
from='accountid'
to='parentaccountid'
link-type='inner'
alias='parentaccount'>
<attribute name='name'
alias='parentaccount' />
<!-- The link-entity parentaccount name -->
<order attribute='name' />
</link-entity>
<!-- The entity account name -->
<order attribute='name' />
</entity>
</fetch>
In this case, the results are ordered using following attributes:
account.nameparentaccountname.nameTo ensure the link-entity order is applied first, move the order element from the link-entity element to the entity element above the other order element, and use the entityname attribute on the order element to refer to the link-entity alias value.
--All Attributes
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="TEST">
<all-attributes />
<filter type="and">
<condition attribute="createdon" value="2018-01-01" operator="on-or-after" />
<condition attribute="createdon" value="3" operator="olderthan-x-months" />
</filter>
</entity>
</fetch>
===
COUNT()
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" aggregate="true">
<entity name="TEST">
<attribute name="aa_integration_responseid" alias="record_count" aggregate="count" />
<filter type="or">
<condition attribute="createdon" value="2018-01-01" operator="on-or-after" />
<condition attribute="createdon" value="3" operator="olderthan-x-months"/>
</filter>
</entity>
</fetch>
To check if a file has special characters in Notepad++, open the file, go to the "Search" menu, select "Find", then in the "Find what" field, use the regular expression [^\x00-\x7F] to identify any non-ASCII characters (which are generally considered special characters); this will highlight any special characters present in the file.
https://testguild.com/qtp-ascii-chr-code-chart/
[^\x00-\x7F]. [^\x00-\x7F] means "any character that is not within the range of ASCII codes from 0 to 127". Test again.� Test. test.
no period� no period no period
three spaces�� two spaces� one space x
1. Edit the job.2. Goto Field Mapping.3. Click On Edit Fields.4. Change the Field Type to nvarchar.5. Save and re run the job.
| QTP CODE | SYMBOL | DESCRIPTION |
| Chr(34) | “ | Double Quotes |
| Chr(10) | Line Feed | |
| Chr(13) | Carriage Return | |
| Chr(32) | Space |
| QTP CODE | SYMBOL | DESCRIPTION |
| Chr(0) | NUL | Null char |
| Chr(1) | SOH | Start of Heading |
| Chr(2) | STX | Start of Text |
| Chr(3) | ETX | End of Text |
| Chr(4) | EOT | End of Transmission |
| Chr(5) | ENQ | Enquiry |
| Chr(6) | ACK | Acknowledgment |
| Chr(7) | BEL | Bell |
| Chr(8) | BS | Back Space |
| Chr(9) | HT | Horizontal Tab |
| Chr(10) | LF | Line Feed |
| Chr(11) | VT | Vertical Tab |
| Chr(12) | FF | Form Feed |
| Chr(13) | CR | Carriage Return |
| Chr(14) | SO | Shift Out / X-On |
| Chr(15) | SI | Shift In / X-Off |
| Chr(16) | DLE | Data Line Escape |
| Chr(17) | DC1 | Device Control 1 (oft. XON) |
| Chr(18) | DC2 | Device Control 2 |
| Chr(19) | DC3 | Device Control 3 (oft. XOFF) |
| Chr(20) | DC4 | Device Control 4 |
| Chr(21) | NAK | Negative Acknowledgement |
| Chr(22) | SYN | Synchronous Idle |
| Chr(23) | ETB | End of Transmit Block |
| Chr(24) | CAN | Cancel |
| Chr(25) | EM | End of Medium |
| Chr(26) | SUB | Substitute |
| Chr(27) | ESC | Escape |
| Chr(28) | FS | File Separator |
| Chr(29) | GS | Group Separator |
| Chr(30) | RS | Record Separator |
| Chr(31) | US | Unit Separator |
| Chr(32) | Space | |
| Chr(33) | ! | Exclamation mark |
| Chr(34) | “ | Double quotes (or speech marks) |
| Chr(35) | # | Number |
| Chr(36) | $ | Dollar |
| Chr(37) | % | Procenttecken |
| Chr(38) | & | Ampersand |
| Chr(39) | ‘ | Single quote |
| Chr(40) | ( | Open parenthesis (or open bracket) |
| Chr(41) | ) | Close parenthesis (or close bracket) |
| Chr(42) | * | Asterisk |
| Chr(43) | + | Plus |
| Chr(44) | , | Comma |
| Chr(45) | – | Hyphen |
| Chr(46) | . | Period, dot or full stop |
| Chr(47) | / | Slash or divide |
| Chr(48) | 0 | Zero |
| Chr(49) | 1 | One |
| Chr(50) | 2 | Two |
| Chr(51) | 3 | Three |
| Chr(52) | 4 | Four |
| Chr(53) | 5 | Five |
| Chr(54) | 6 | Six |
| Chr(55) | 7 | Seven |
| Chr(56) | 8 | Eight |
| Chr(57) | 9 | Nine |
| Chr(58) | : | Colon |
| Chr(59) | ; | Semicolon |
| Chr(60) | < | Less than (or open angled bracket) |
| Chr(61) | = | Equals |
| Chr(62) | > | Greater than (or close angled bracket) |
| Chr(63) | ? | Question mark |
| Chr(64) | @ | At symbol |
| Chr(65) | A | Uppercase A |
| Chr(66) | B | Uppercase B |
| Chr(67) | C | Uppercase C |
| Chr(68) | D | Uppercase D |
| Chr(69) | E | Uppercase E |
| Chr(70) | F | Uppercase F |
| Chr(71) | G | Uppercase G |
| Chr(72) | H | Uppercase H |
| Chr(73) | I | Uppercase I |
| Chr(74) | J | Uppercase J |
| Chr(75) | K | Uppercase K |
| Chr(76) | L | Uppercase L |
| Chr(77) | M | Uppercase M |
| Chr(78) | N | Uppercase N |
| Chr(79) | O | Uppercase O |
| Chr(80) | P | Uppercase P |
| Chr(81) | Q | Uppercase Q |
| Chr(82) | R | Uppercase R |
| Chr(83) | S | Uppercase S |
| Chr(84) | T | Uppercase T |
| Chr(85) | U | Uppercase U |
| Chr(86) | V | Uppercase V |
| Chr(87) | W | Uppercase W |
| Chr(88) | X | Uppercase X |
| Chr(89) | Y | Uppercase Y |
| Chr(90) | Z | Uppercase Z |
| Chr(91) | [ | Opening bracket |
| Chr(92) | \ | Backslash |
| Chr(93) | ] | Closing bracket |
| Chr(94) | ^ | Caret – circumflex |
| Chr(95) | _ | Underscore |
| Chr(96) | ` | Grave accent |
| Chr(97) | a | Lowercase a |
| Chr(98) | b | Lowercase b |
| Chr(99) | c | Lowercase c |
| Chr(100) | d | Lowercase d |
| Chr(101) | e | Lowercase e |
| Chr(102) | f | Lowercase f |
| Chr(103) | g | Lowercase g |
| Chr(104) | h | Lowercase h |
| Chr(105) | i | Lowercase i |
| Chr(106) | j | Lowercase j |
| Chr(107) | k | Lowercase k |
| Chr(108) | l | Lowercase l |
| Chr(109) | m | Lowercase m |
| Chr(110) | n | Lowercase n |
| Chr(111) | o | Lowercase o |
| Chr(112) | p | Lowercase p |
| Chr(113) | q | Lowercase q |
| Chr(114) | r | Lowercase r |
| Chr(115) | s | Lowercase s |
| Chr(116) | t | Lowercase t |
| Chr(117) | u | Lowercase u |
| Chr(118) | v | Lowercase v |
| Chr(119) | w | Lowercase w |
| Chr(120) | x | Lowercase x |
| Chr(121) | y | Lowercase y |
| Chr(122) | z | Lowercase z |
| Chr(123) | { | Opening brace |
| Chr(124) | | | Vertical bar |
| Chr(125) | } | Closing brace |
| Chr(126) | ~ | Equivalency sign – tilde |
| Chr(127) | Delete |
