Summary
How it works
Crystal Reports
PRINT
Date
COPY_ARRAY
IS_WEEKEND
Decimal
COPY_ARRAY
Development
LINK_OPEN
VALIDATE
VALIDATE_TRANSACTION
VIEW_SCREEN
Integer
COPY_ARRAY
Short Integer
COPY_ARRAY
File
CREATE_DIRECTORY
CSV_TO_XLSX
DEL_DIRECTORY
DOWNLOAD
GET_COMPLETE_NAME
GET_EXTENSION
GET_HASH
GET_NAME
LIST_DIRECTORIES
LIST_FILES
PATH_TO_VOLUME
UNZIP
UPLOAD
VOLUME_TO_PATH
ZIP
FTP
DELETE
DOWNLOAD
LIST
UPLOAD
Image
GENERATE_CODE
IMAP
LIST_DIRECTORIES
Json
COUNT
DEL_KEY
GET_KEYS
GET_ONE
GET_POS_KEY
GET_TYPE
GET_VALUE
SET_VALUE
TO_ARRAY
MongoDB
QUERY
SMS
SEND
SMTP
SEND_EMAIL
Stock
GET_AVAILABLE_QTY
GET_COST
Text
COPY_ARRAY
COUNT_OCCURRENCES
HTML_DECODE
HTML_ENCODE
HTML_TO_TXT
IS_NUMERIC
LINK_DECODE
LINK_ENCODE
RANDOM
REPLACE
RTF_TO_TXT
SPLIT
TO_BASE64
User
CHECK_PASSWORD
Sale
CLOSE_ORDER
GET_PRICE
VALIDATE_DELIVERY
func X3.EN_MONGO_QUERY(Char QUERY_IN) : Clbfile

Starts a Crystal Reports print to a file on the server

  • QUERY_IN Clbfile Query to execute (Example : db.User.update({"_id":"XXX"},{$set:{"_creUser":"lvex3"}});)
Return Clbfile Returned Json or number for a count()
Example

[L]JSON = func X3.EN_MONGO_QUERY("db.User.find({}).count()")
[L]NB = val([L]JSON) # The NB variable contains the number of users in the MongoDB database without filter